agent-platform/deployments/docker/postgres-init/002_service_databases.sql

SELECT 'CREATE DATABASE workflow_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'workflow_service')\gexec
SELECT 'CREATE DATABASE session_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'session_service')\gexec
SELECT 'CREATE DATABASE runtime_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'runtime_service')\gexec
SELECT 'CREATE DATABASE tool_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'tool_service')\gexec
SELECT 'CREATE DATABASE agent_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'agent_service')\gexec
SELECT 'CREATE DATABASE memory_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'memory_service')\gexec
SELECT 'CREATE DATABASE team_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'team_service')\gexec
SELECT 'CREATE DATABASE skill_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'skill_service')\gexec
SELECT 'CREATE DATABASE human_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'human_service')\gexec
SELECT 'CREATE DATABASE knowledge_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'knowledge_service')\gexec
SELECT 'CREATE DATABASE event_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'event_service')\gexec
SELECT 'CREATE DATABASE auth_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'auth_service')\gexec
SELECT 'CREATE DATABASE scheduler_service'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'scheduler_service')\gexec
SELECT 'CREATE DATABASE api_gateway'
WHERE NOT EXISTS (SELECT FROM pg_database WHERE datname = 'api_gateway')\gexec