databaseOfficial
PostgreSQL MCP
88
Anthropic
Query and interact with PostgreSQL databases, inspect schemas, and run SQL directly from your AI editor.
83.0k72.6k/wk4.1K tokens(2%)Official1w ago
Network
databasepostgressqlqueries
Quick Setup
Paste in ~/.claude.json
json
{
"mcpServers": {
"postgres-mcp": {
"command": "npx",
"args": [
"-y",
"@modelcontextprotocol/server-postgres",
"postgresql://localhost/mydb"
],
"env": {
"POSTGRES_CONNECTION_STRING": "YOUR_POSTGRES_CONNECTION_STRING"
}
}
}
}Part of these stacks
Recommended Skills
Skills specialize your AI editor when working with PostgreSQL MCP. Learn more
PostgreSQL Best Practicesbest-practices
PostgreSQL optimization guide covering query performance, connection management, indexing strategies, and schema design.
PostgreSQL Table Designbest-practices
PostgreSQL table design patterns including normalization, indexing, partitioning, and data type selection.