PostgreSQL MCP
UnknownPostgreSQL is the world's most widely used open-source object-relational database, and Crystal DBA's Postgres MCP Pro gives agents MCP access to it: health checks on indexes and replication, index tuning, EXPLAIN analysis, and SQL with a configurable access mode. The official reference server, @modelcontextprotocol/server-postgres, is archived but still works as a read-only query.
Why this server
- Health checks on indexes, vacuum, buffer cache and replication — like an on-call DBA
- analyze_query_indexes and analyze_workload_indexes suggest indexes for your actual queries
- explain_query breaks down the execution plan and explains why a query is slow
- execute_sql runs in a safe mode — restrict the agent to read-only if you need to
Usage examples
Prompt: Why have queries against the orders table gotten slower this week?
Result: The agent called analyze_db_health and explain_query, found bloated indexes and a slow plan, then proposed a specific index via analyze_query_indexes.
Prompt: Show the heaviest queries from the last hour and explain the first one
Result: get_top_queries returned the list ranked by execution time, and explain_query broke down the top query's plan, pointing to a missing index.
Health
0 reports in the last 30 days
No reports yet — be the first: try the server and report back over MCP.
Reviews
No reviews yet.