What is the PostgreSQL MCP Server MCP server?
PostgreSQL MCP Server — 27 tools for queries, schema, CRUD, DBA, HA & server management
How to install PostgreSQL MCP Server
Copy-paste configuration for popular MCP clients.
transport: stdio
Config generated by PluginBench — verify against the source before use.Environment / auth
POSTGRES_CONNECTION_STRINGPostgreSQL connection string (e.g. postgresql://user:pass@host:5432/db)
Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@itunified.io/mcp-postgres"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<YOUR_POSTGRES_CONNECTION_STRING>"
}
}
}
}Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@itunified.io/mcp-postgres"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<YOUR_POSTGRES_CONNECTION_STRING>"
}
}
}
}Windsurf
~/.codeium/windsurf/mcp_config.json
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@itunified.io/mcp-postgres"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<YOUR_POSTGRES_CONNECTION_STRING>"
}
}
}
}VS Code
.vscode/mcp.json
{
"servers": {
"postgres": {
"type": "stdio",
"command": "npx",
"args": [
"-y",
"@itunified.io/mcp-postgres"
],
"env": {
"POSTGRES_CONNECTION_STRING": "<YOUR_POSTGRES_CONNECTION_STRING>"
}
}
}
}Claude Code
claude mcp add postgres --env POSTGRES_CONNECTION_STRING=<YOUR_POSTGRES_CONNECTION_STRING> -- npx -y @itunified.io/mcp-postgresRelated MCP servers
Cloudflare MCP Server — 84 tools for DNS, Tunnels, WAF, Zero Trust, R2, KV & Workers
View repository →OPNsense MCP Server — 72 tools for DNS, Firewall, DHCP, ACME, Routing, VLANs & more
View repository →Secure MCP access for private infrastructure over Tailscale — 48 tools across 9 domains
View repository →