Postgres MCP Pro

Query, analyze, and tune PostgreSQL databases through your AI agent with safe access controls. Beyond basic SQL execution, it provides index tuning recommendations, query plan analysis, database health monitoring, and schema intelligence.

Overview

Postgres MCP Pro is an open-source MCP server by Crystal DBA that goes beyond wrapping a database connection. It provides deep database intelligence including index tuning, EXPLAIN plan analysis, health diagnostics, and configurable access controls.

Best for

Running queries with configurable read-only or full-access modes

Diagnosing database performance problems with EXPLAIN plan analysis

Getting industrial-strength index tuning recommendations

Monitoring database health: connection utilization, buffer cache, vacuum health, replication lag

Access modes