Postgres MCP Onboarding
Purpose
Get Postgres MCP connected with minimal errors.
Required Input
A valid Postgres URL:
postgresql://user:password@host:5432/database
Steps
- Set env var (preferred):
POSTGRES_MCP_URL. - Configure command argument to read URL from env placeholder.
- Keep server disabled by default until URL exists.
- Validate and run
/statusoropencode mcp list.
Provider Notes
- Supabase/Neon/Railway: use pooled or direct DB URL from dashboard.
- Local Docker: map host port and use
localhost:<port>.
Common Failures
- Missing URL arg ->
Connection closed - Wrong sslmode or firewall block -> timeout/auth failures