MCPIndependentCrystal DBA
Postgres MCP Pro
Diagnoses a Postgres database, reads EXPLAIN plans and picks indexes for the workload.
An open-source server for any Postgres database: it checks the health of indexes, vacuum, connections and replication, analyzes query plans, simulates hypothetical indexes and runs SQL. The database URL goes in the DATABASE_URI variable, and “restricted” mode (read-only with a query time limit) is suitable for production databases too.
Installation
Manual install
$uvx postgres-mcp --access-mode=restrictedDetails
- Works in
- Claude Code, Claude, Cursor, VS Code, Windsurf, Codex, Gemini CLI, Zed
- Transport
- local
- License
- MIT
- Tasks
- Data, Code
- Rating
- Source
- github.com/crystaldba/postgres-mcp (opens in a new tab)
Tags
- postgres
- postgresql
- indexes
- performance
- explain
- dba
- sql
A pack is your own set of skills and MCP servers. sciver loads it in your AI with one command.