Postgres MCP Pro

Content

Postgres MCP Pro is a PostgreSQL MCP server from Crystal DBA for database inspection, SQL execution, query-plan analysis, index tuning, and health checks. It connects Claude to a PostgreSQL database over stdio, SSE, or Streamable HTTP and exposes tools for schema exploration, EXPLAIN plans, slow-query analysis, workload index recommendations, and health checks.

Use it when a Postgres-backed project needs more than a simple read-only query wrapper. It is especially useful for development and DBA workflows where Claude needs schema context, query plans, workload statistics, index recommendations, and repeatable health checks before proposing code or migration changes.

Source Review

• https://github.com/crystaldba/postgres-mcp
• https://github.com/crystaldba/postgres-mcp/blob/main/README.md
• https://pypi.org/project/postgres-mcp/
• https://github.com/crystaldba/postgres-mcp/blob/main/LICENSE
• https://github.com/crystaldba/postgres-mcp/blob/main/pyproject.toml
• https://github.com/crystaldba/postgres-mcp/blob/main/src/postgres_mcp/server.py
• https://github.com/crystaldba/postgres-mcp/blob/main/src/postgres_mcp/sql/safe_sql.py
• https://github.com/crystaldba/postgres-mcp/blob/main/src/postgres_mcp/explain/README.md
• https://github.com/crystaldba/postgres-mcp/blob/main/src/postgres_mcp/database_health/database_health.py
• https://github.com/crystaldba/postgres-mcp/blob/main/src/postgres_mcp/index/dta_calc.py

These sources were reviewed on 2026-06-06. Prefer the live repository, README, PyPI package page, license, package manifest, MCP server implementation, safe SQL driver, EXPLAIN tool documentation, database health implementation, and index tuning implementation for current installation and behavior details.

Features

• List schemas and schema objects.
• Inspect table, view, sequence, extension, column, constraint, and index details.
• Execute SQL with different behavior in unrestricted and restricted modes.
• Explain queries, optionally with real execution statistics or hypothetical indexes.
• Report top queries from pg_stat_statements.
• Analyze workload or specific queries for index recommendations.
• Run database health checks for indexes, connections, vacuum, sequences, replication, buffer cache, and constraints.
• Run over stdio for local MCP clients or over SSE and Streamable HTTP for shared server setups.

Installation

Run with uvx and a scoped PostgreSQL connection string:

{
  "mcpServers": {
    "postgres-pro": {
      "command": "uvx",
      "args": ["postgres-mcp", "--access-mode=restricted"],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

The upstream README also documents Docker, pipx, uv, SSE, and Streamable HTTP setups. Use restricted mode for production-like databases and reserve unrestricted mode for approved development databases where write access is acceptable.

Use Cases

• Ask Claude to inspect a Postgres schema before generating SQL or ORM code.
• Explain a slow query and compare plans before and after hypothetical indexes.
• Analyze top queries from pg_stat_statements.
• Generate index recommendations for a specific query list or workload.
• Check database health for invalid or duplicate indexes, connection pressure, vacuum risk, sequence exhaustion, replication lag, buffer cache issues, and invalid constraints.
• Let an agent ground migration or performance work in actual database metadata while keeping human review on destructive changes.

Safety and Privacy

Treat Postgres MCP Pro as direct database access. Unrestricted mode can modify data or schema, so use restricted mode by default, use least-privilege database roles, and keep a human approval gate before destructive or production-impacting work.

Even restricted database access can expose sensitive schema, query, and result data to the MCP client, model provider, logs, and chat transcripts. Avoid connecting agents to production databases unless access controls, redaction, audit logging, and data-handling approvals are already in place.

EXPLAIN, health, and index-analysis tools can create load or rely on privileged extensions. Verify the database role, extension permissions, query timeout, and expected workload impact before running analysis against shared databases.

Duplicate Check

Existing entries cover the official read-only PostgreSQL MCP server, Timescale's pg-aiguide documentation server, generic database servers such as MCP Toolbox and DBHub, and managed Postgres platforms such as Neon and Supabase. Postgres MCP Pro is distinct because it combines PostgreSQL schema inspection, configurable restricted or unrestricted SQL execution, EXPLAIN plans, workload index recommendations, top-query analysis, and database health checks from crystaldba/postgres-mcp. No crystaldba/postgres-mcp entry or matching source URL was found in content/mcp.

• Source repositorygithub.com 2026-07-21T07:17:01+00:00
• Documentationgithub.com
• Submitted by oktofeesh12026-06-06