Claude Desktop · MCP
Add PostgreSQL to Claude Desktop
Let Claude run read-only queries against your Postgres database.
One-click installs
claude mcp add-json postgres '{"command":"npx","args":["-y","@modelcontextprotocol/server-postgres","postgresql://user:pass@localhost:5432/dbname"]}'The Cursor button installs it instantly; the command does the same for Claude Code.
Claude Desktop config (manual)
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://user:pass@localhost:5432/dbname"
]
}
}
}›Replace the connection string with your own. Access is read-only by design.
How to add it
01
Open Claude Desktop → Settings → Developer → Edit Config.
02
Paste the block below into claude_desktop_config.json (merge it into "mcpServers" if you already have some).
03
Fill in any placeholder values (paths, API keys).
04
Fully quit and reopen Claude Desktop. The server’s tools appear in the 🔌 menu.
The linked repo is the source of truth — if the package name ever changes, it’ll be current there.