PostgreSQL MCP Server
by Anthropic · ⭐ 4.9k stars · updated 2 months ago
Read-only access to PostgreSQL databases. Run SQL queries, inspect schemas, and explore data — all through your AI assistant. Official Anthropic reference implementation.
96
Excellent
Quality Score Breakdown
maintenance98/100
community95/100
documentation96/100
compatibility95/100
Use Cases
- ✓query databases
- ✓inspect schemas
- ✓run SQL queries
- ✓explore data
⚡ One-Click Install Configs
Copy the config below and paste it into your AI client's config file.
🤖 Claude Desktop
~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://localhost/mydb"
]
}
}
}⚡ Cursor
~/.cursor/mcp.json
{
"mcpServers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://localhost/mydb"
]
}
}
}💙 VS Code
.vscode/mcp.json
{
"mcp": {
"servers": {
"postgres": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://localhost/mydb"
]
}
}
}
}