PostgreSQL
local MCP serverInstallation
Terminal
claude mcp add mcp-postgres-server -e DATABASE_URL=... -e PG_HOST=... -e PG_PORT=... -e PG_USER=... -e PG_PASSWORD=... -e PG_DATABASE=... -e PG_ALLOW_WRITE=... -e PG_SSLMODE=... -e PG_SSL_CA=... -e PG_ENABLE_RUNTIME_CONNECT=... -e PG_MAX_RESULT_BYTES=... -e PG_STATEMENT_TIMEOUT=... -e PG_CONNECT_TIMEOUT=... -e PG_SSH_HOST=... -e PG_SSH_PORT=... -e PG_SSH_USER=... -e PG_SSH_PRIVATE_KEY=... -e PG_SSH_PASSPHRASE=... -e PG_SSH_AGENT=... -e PG_SSH_PASSWORD=... -e PG_SSH_FINGERPRINT=... -e PG_SSH_KEEPALIVE_INTERVAL=... -- npx -y mcp-postgres-server
Run in your project folder. Add --scope user to use it everywhere.
Claude Desktop, Cursor & other clients
Add to claude_desktop_config.json or .cursor/mcp.json.
{
"mcpServers": {
"mcp-postgres-server": {
"command": "npx",
"args": [
"-y",
"mcp-postgres-server"
],
"env": {
"DATABASE_URL": "...",
"PG_HOST": "...",
"PG_PORT": "...",
"PG_USER": "...",
"PG_PASSWORD": "...",
"PG_DATABASE": "...",
"PG_ALLOW_WRITE": "...",
"PG_SSLMODE": "...",
"PG_SSL_CA": "...",
"PG_ENABLE_RUNTIME_CONNECT": "...",
"PG_MAX_RESULT_BYTES": "...",
"PG_STATEMENT_TIMEOUT": "...",
"PG_CONNECT_TIMEOUT": "...",
"PG_SSH_HOST": "...",
"PG_SSH_PORT": "...",
"PG_SSH_USER": "...",
"PG_SSH_PRIVATE_KEY": "...",
"PG_SSH_PASSPHRASE": "...",
"PG_SSH_AGENT": "...",
"PG_SSH_PASSWORD": "...",
"PG_SSH_FINGERPRINT": "...",
"PG_SSH_KEEPALIVE_INTERVAL": "..."
}
}
}
}Fill in the environment variables with your own credentials.
Summary
MCP server for PostgreSQL: local, Docker, RDS, Neon, Supabase, or behind an SSH bastion.
Questions
PostgreSQL is a local MCP server distributed as the npm package mcp-postgres-server.
Run: claude mcp add mcp-postgres-server -e DATABASE_URL=... -e PG_HOST=... -e PG_PORT=... -e PG_USER=... -e PG_PASSWORD=... -e PG_DATABASE=... -e PG_ALLOW_WRITE=... -e PG_SSLMODE=... -e PG_SSL_CA=... -e PG_ENABLE_RUNTIME_CONNECT=... -e PG_MAX_RESULT_BYTES=... -e PG_STATEMENT_TIMEOUT=... -e PG_CONNECT_TIMEOUT=... -e PG_SSH_HOST=... -e PG_SSH_PORT=... -e PG_SSH_USER=... -e PG_SSH_PRIVATE_KEY=... -e PG_SSH_PASSPHRASE=... -e PG_SSH_AGENT=... -e PG_SSH_PASSWORD=... -e PG_SSH_FINGERPRINT=... -e PG_SSH_KEEPALIVE_INTERVAL=... -- npx -y mcp-postgres-server
Run: codex mcp add mcp-postgres-server --env DATABASE_URL=... --env PG_HOST=... --env PG_PORT=... --env PG_USER=... --env PG_PASSWORD=... --env PG_DATABASE=... --env PG_ALLOW_WRITE=... --env PG_SSLMODE=... --env PG_SSL_CA=... --env PG_ENABLE_RUNTIME_CONNECT=... --env PG_MAX_RESULT_BYTES=... --env PG_STATEMENT_TIMEOUT=... --env PG_CONNECT_TIMEOUT=... --env PG_SSH_HOST=... --env PG_SSH_PORT=... --env PG_SSH_USER=... --env PG_SSH_PRIVATE_KEY=... --env PG_SSH_PASSPHRASE=... --env PG_SSH_AGENT=... --env PG_SSH_PASSWORD=... --env PG_SSH_FINGERPRINT=... --env PG_SSH_KEEPALIVE_INTERVAL=... -- npx -y mcp-postgres-server
Similar MCP servers
NameStars
- DBHubio.github.bytebase/dbhub3,574
- wigoloio.github.KnockOutEZ/wigolo5,418
- socraticodeio.github.giancarloerra/socraticode3,322
- Supabasecom.supabase/mcp2,926
- Persomeio.github.Intuition-Lab/personal-model1,324
- projectmemio.github.riponcm/projectmem844
- Agent Swarmio.github.desplega-ai/agent-swarm835
- HOL Guardio.github.hashgraph-online/hol-guard670