Postgres MCP Pro

Postgres MCP Pro

Postgres MCP Pro is a Model Context Protocol server that gives AI agents deep, guarded access to PostgreSQL. It goes beyond plain query execution: agents can inspect schemas, run configurable read-only or read/write SQL, diagnose slow queries, and get principled index recommendations backed by the query planner.

Key features

• Configurable access modes: unrestricted for local development, restricted read-only for production safety
• Index tuning that simulates hypothetical indexes and reports the estimated plan-cost change
• Database health checks covering bloat, cache hit rates, vacuum status, and connection saturation
• EXPLAIN/EXPLAIN ANALYZE plan inspection so agents can reason about and optimize queries
• Works with any Postgres 13+ instance over a standard connection string, local or managed
• Ships as a container and via pip/uvx for drop-in wiring into MCP clients

It is a practical bridge for coding agents that need to understand a real database's structure and performance rather than blindly issuing SQL.

Curated mirror of the open-source Postgres MCP Pro (MIT). Get it from the source.