Product / UX / Agent tools & protocols

Postgres MCP Pro

Actively maintained PostgreSQL MCP server (Python) by Crystal DBA, 'Postgres MCP Pro', that goes beyond read-only querying to database performance and health tooling for agents: schema/object inspection, execute_sql with access modes, EXPLAIN with hypothetical-index simulation, slow-query analysis, index advising, and health checks.

The original reference Postgres server was archived read-only in May 2025 and only did read-only queries, so this is the maintained successor. "Pro" is part of the product name rather than a paid edition; there is no second tier. Verified 2026-08-13 via GitHub and the repository LICENSE.

Openness

5 high confidence

5.0

license: MIT(OSI)
source: public
core-gated: ungated

Fully MIT, no feature-gated core. Despite the "Pro" in the product name there is no paid edition - the whole server, index tuning and health checks included, ships in the tree and runs from PyPI or the crystaldba/postgres-mcp Docker image with only a DATABASE_URI, and there is no license key, second license or enterprise directory.

https://raw.githubusercontent.com/crystaldba/postgres-mcp/main/LICENSE recorded 2026-08-13
Plain MIT License text: "Copyright (c) 2025, Crystal Corp."
https://github.com/crystaldba/postgres-mcp recorded 2026-08-13
Repo page - MIT badge, 3,188 stargazers, the whole server in the tree. Runs from PyPI or the crystaldba/postgres-mcp Docker image with a DATABASE_URI and an --access-mode flag; nothing is withheld for a paid tier.

Adoption

3 medium confidence

3.0

491,612 downloads of postgres-mcp in the trailing 30 days, which bands at 100K-1M, level 3 on the software adoption scale. The package is first-party.

https://pypistats.org/api/packages/postgres-mcp/recent recorded 2026-08-12
491,612 downloads in the trailing 30 days for postgres-mcp

Capability

4 medium confidence

4.0

Richest open Postgres MCP surface, well beyond the archived read-only reference server.

https://github.com/crystaldba/postgres-mcp recorded 2026-08-13
"A Postgres MCP server with index tuning, explain plans, health checks, and safe sql execution." Tool table - explain_query "Can be invoked with hypothetical indexes to simulate the behavior after adding indexes"; get_top_queries "Reports the slowest SQL queries based on total execution time"; analyze_db_health "buffer cache hit rates, connection health, constraint validation, index health (duplicate/unused/invalid), sequence limits, and vacuum health". Access modes set by --access-mode.

Verified 2026-08-12