What it does
The leading community successor to the archived `@modelcontextprotocol/server-postgres` reference: Postgres MCP Pro (`crystaldba/postgres-mcp`) offers configurable read/write access modes, database-health analysis, index tuning, and hypothetical-index EXPLAIN simulation. Tool calls are deterministic SQL/catalog operations; the connecting LLM composes the queries. Runs locally over stdio (self-host SSE is available).
Example prompts
- Analyze the health of my database and flag the slowest queries.
- Recommend indexes for my current query workload and show the EXPLAIN impact.
Before you connect
The credentials this agent will ask you for — the full setup is on the Setup tab.
Needs 1 credential (1 required) to connect. See setup
