Databases
PostgreSQL MCP
Full-featured PostgreSQL MCP server. Supports schema introspection, queries, updates, and deletes. Requires a running PostgreSQL instance.
0% Pass ❌Free to Test 🆓Tested 📅
0% (0/0 tasks)View on GitHubby kristofer84
README badge
[](https://mcpselect.com/servers/postgresql-mcp/)
Benchmark results
Pass Rate0% (0/0 tasks)
0%(5 tasks)
SpeedN/A
Tested OnJun 8, 2026Could not discover tools
| Metric | Value |
|---|---|
| Tools discovered | Could not discover tools |
| Scope | Local only |
| Pricing | Free |
| Auth requirement | None. Free to test |
| Verdict | 0% pass rate on 0 tasks |
Install config
Claude Desktop (macOS)
{"mcpServers": {"postgres": {"command": "npx", "args": ["-y", "mcp-postgres@latest"], "env": {"DB_HOST": "localhost", "DB_PORT": "5432", "DB_USER": "your_user", "DB_PASSWORD": "your_password", "DB_NAME": "your_database", "DB_SSL_MODE": "disable"}}}}Cursor
{"mcpServers": {"postgres": {"command": "npx", "args": ["-y", "mcp-postgres@latest"], "env": {"DB_HOST": "localhost", "DB_PORT": "5432", "DB_USER": "your_user", "DB_PASSWORD": "your_password", "DB_NAME": "your_database", "DB_SSL_MODE": "disable"}}}}VS Code
// .vscode/mcp.json
{
"servers": {
"postgres": {
"command": "npx",
"args": ["-y", "mcp-postgres@latest"],
"env": {
"DB_HOST": "localhost",
"DB_PORT": "5432",
"DB_USER": "your_user",
"DB_PASSWORD": "your_password",
"DB_NAME": "your_database",
"DB_SSL_MODE": "disable"
}
}
}
}Pros
- +Package installs successfully
Cons
- −Requires configuration/credentials
- −Could not evaluate without setup
Best for
Production apps, complex queries, multi-user systems, data warehousing
Related servers in Databases
Frequently asked questions
How do I install PostgreSQL MCP?▼
Copy the config above into your AI assistant's MCP settings file:
- Claude Desktop:
~/Library/Application Support/Claude/claude_desktop_config.json - Cursor: Settings → MCP → Add Server
- VS Code:
.vscode/mcp.json
Does it require an API key?▼
No. PostgreSQL MCP is free to test. No API key or signup required. We tested it independently.
How were these results measured?▼
We run each server through a standardized test harness that:
- Installs the server via
npxin a fresh environment - Discovers available tools using the MCP SDK
- Executes real tasks (navigate, click, screenshot, etc.)
- Validates outputs with semantic assertions (not string matching)
- Measures latency percentiles and pass rate
All test scripts are open source on GitHub.