Postgres MCP Pro

Example Use Cases

• 1

  Analyze database health and detect issues like unused/duplicate indexes, vacuum/transaction wraparound risks, buffer cache hit rates, and replication lag.

• 2

  Recommend and validate indexes by simulating planner behavior (hypothetical indexes) and searching index combinations to balance performance and storage cost.

• 3

  Safely execute or evaluate SQL (read-only/restricted modes), obtain EXPLAIN plans, and integrate with MCP clients over stdio or SSE.

Description

Postgres MCP Pro is an MCP server that combines deterministic database tools and classical optimization algorithms with LLM workflows to help develop, test, tune, and maintain PostgreSQL databases. It provides index tuning (including hypopg-based "what if" simulations), EXPLAIN plan analysis, workload-driven recommendations, comprehensive health checks adapted from PgHero, and configurable protected SQL execution modes. The server supports stdio and SSE transports, Docker and Python deployment options, and integrates with MCP clients such as Claude Desktop, Cursor, and others.