Back to Gap Map Product / UX / Agent tools & connectors

Postgres MCP Pro

open source / Overall score: 3.0

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.

Openness

5 high confidence

5.0

license: MIT(OSI)
source: public
core features withheld: no

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://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.
https://pypi.org/pypi/postgres-mcp/json recorded 2026-09-29
The PyPI metadata for postgres-mcp 0.3.0 carries the project README, which shows a "License: MIT" badge and describes the server as "is an open source Model Context Protocol (MCP) server built to support you" with installs by "pipx install postgres-mcp" or the Docker image; the only key mentioned is an OPENAI_API_KEY for the optional experimental LLM index tuning ("you must provide an OpenAI API key"), and no license key, paid edition or enterprise build appears.
https://raw.githubusercontent.com/crystaldba/postgres-mcp/main/LICENSE recorded 2026-08-13
Plain MIT License text: "Copyright (c) 2025, Crystal Corp."

Adoption

3 medium confidence

3.0

Adoption is measured by monthly PyPI downloads of postgres-mcp, the first-party package.

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

Capability

3 medium confidence

3.0

The server covers one system, PostgreSQL, with the caller supplying credentials through a DATABASE_URI environment variable rather than the server authenticating on its own. Its tooling goes deep - index advising and health checks are DBA work, not simple CRUD - but depth of coverage is not what earns a higher score, so postgres-mcp lands at the same level as Playwright MCP.

https://raw.githubusercontent.com/crystaldba/postgres-mcp/main/README.md recorded 2026-09-17
The README's configuration passes `DATABASE_URI` as an environment variable to the container - "postgresql://..." supplied by the caller - with `--access-mode` controlling what the server may execute. The tools cover schema inspection, SQL execution, EXPLAIN with hypothetical indexes, slow-query analysis, index advice and health checks.

Verified 2026-09-17