Databases

PostgreSQL

Container: magic_pim_postgres_dev Image: PostgreSQL 16 Alpine Port: 5432 Credentials: postgres / See Vaultwarden Total databases: 43

Tenant Databases (9)

Commerce tenant data (Medusa + APLT B2B ERP):

Database	Tenant
`magic_b2b_development`	Development
`magic_b2b_brinxx`	Brinxx
`magic_b2b_default`	Default
`magic_b2b_demo`	Demo
`magic_b2b_desluis`	De Sluis
`magic_b2b_bovisales`	Bovisales
`magic_b2b_jodasign`	Jodasign
`magic_b2b_logohorloge`	Logohorloge
`magic_b2b_spranz`	Spranz

PIM Database

Database	Purpose
`magic_pim`	PIM master product data

Master Database

Database	Purpose
`master_magic`	Master invoicing/facturatie portal

Agent Databases (14)

AI agent data per brand/function:

Database	Agent
`magic_agent`	Base agent database
`magic_agent_brandbutler`	Brand Butler agent
`magic_agent_brinxx`	Brinxx agent
`magic_agent_default_agent`	Default agent
`magic_agent_langenberg`	Langenberg agent
`magic_agent_logohorloge`	Logohorloge agent
`magic_agent_magic_dwf`	Magic DWF agent
`magic_agent_magiceverse`	Magic e-Verse agent
`magic_agent_ollivanders`	Ollivanders agent
`magic_agent_princess`	Princess agent
`magic_agent_spranz`	Spranz agent
`magic_agent_support_agent`	Support agent
`magic_agent_topgiving`	Topgiving agent
`magic_agent_wayne`	Wayne agent

Service Databases (5)

Database	Purpose
`magic_access`	Access control / permissions
`magic_connector`	External connectors / integrations
`magic_contact`	Contact management
`magic_escalation`	Escalation management
`magic_management`	General management data

Logo / Designer Databases (5)

Database	Purpose
`magic_logo`	Logo designer (main)
`magic_logo_default`	Logo designer (default config)
`magic_logohorloge_logo`	Logohorloge logo designer
`magic_spranz_logo`	Spranz logo designer
`magic_demokkenkoning_logo`	Demokkenkoning logo designer

Other Databases (8)

Database	Purpose
`magic_dwf`	DWF (Digital Workflow)
`magiceverse`	Magic e-Verse core data
`magiceverse3_cms`	Magic e-Verse CMS v3
`ollivanders`	Ollivanders brand data
`princess`	Princess brand data
`spranz`	Spranz brand data
`topgiving`	Topgiving brand data
`postgres`	PostgreSQL system/default database

Connection Pattern

All tenant backends connect via Docker host networking:

postgres://postgres:See Vaultwarden@host.docker.internal:5432/magic_b2b_{tenant}?sslmode=disable

Each backend has two DB connections:

Medusa DB (DATABASE_URL) — Standard Medusa data
APLT DB (APLT_DB_*) — Custom B2B ERP data

Backup

# Full PostgreSQL backup (all 43 databases)
docker exec magic_pim_postgres_dev \
  pg_dumpall -U postgres > /tmp/postgres_backup_$(date +%Y%m%d_%H%M).sql

# Single database backup
docker exec magic_pim_postgres_dev \
  pg_dump -U postgres magic_b2b_brinxx > /tmp/brinxx_backup.sql

Direct Access

# Interactive psql
docker exec -it magic_pim_postgres_dev psql -U postgres

# List all databases
docker exec magic_pim_postgres_dev psql -U postgres -c "\l"

# Query specific database
docker exec magic_pim_postgres_dev \
  psql -U postgres -d magic_b2b_brinxx -c "SELECT * FROM aplt_brands;"

MySQL

Container: mysql Port: 3306 Credentials: root / See Vaultwarden

Databases

Database	Purpose
`magic_doc`	Portal documentation, users, sessions, support
`magic_promotionalz`	Promotionalz integration data
`dartv2dev`	DART v2 development data
`uren`	Time tracking / hours registration

System databases (not application data): information_schema, mysql, performance_schema, sys

Key Tables (magic_doc)

Table	Purpose
`users`	Portal user accounts
`documents`	Documentation articles
`portal_sessions`	Express session store
`portal_clients`	Client organizations
`portal_projects`	Project metadata
`portal_support_tickets`	Support tickets
`portal_tenant_deployments`	Deployment history
`system_updates`	System announcements

Backup

docker exec mysql \
  mysqldump -uroot -pSee Vaultwarden --all-databases > /tmp/mysql_backup_$(date +%Y%m%d_%H%M).sql

Direct Access

docker exec -it mysql mysql -uroot -pSee Vaultwarden magic_doc

Storage

PostgreSQL data is stored on NVMe for performance:

/mnt/nvme/docker/volumes/magic_pim_postgres_data_dev/_data