PostgreSQL
Databases
Local
Official
Top 100
3 tools
Full SQL access to PostgreSQL with schema inspection and query execution.
How to connect
1
Install (Claude Code / CLI)
Run this in your terminal, then restart your client.
claude mcp add postgres -- npx -y @modelcontextprotocol/server-postgres postgresql://user:pass@localhost/db
2
Verify the tools loaded
Confirm
tools/list returns the expected tools before relying on them in production.Tools
(3)-
queryExecute SQL queries
-
list_tablesList tables in the database
-
describe_tableGet column definitions for a table