Postgres MCP Pro
MCP server giving AI agents configurable read/write access to Postgres plus index tuning, explain plans and health checks.
Not verified yetKnown vulnerabilities
How far pickfit got
pickfit hasn’t verified Postgres MCP Pro yet, so there are no tested install steps.
What follows comes from its README only.
Use it
Before you install: known vulnerabilities
pickfit found 40 known high or critical vulnerabilities in the packages a fresh install brings (OSV.dev, 16 Nov 2026). Weigh this before you install it.
pypi:anyio 4.9.0AnyIO: TLSStream IDNA 2003 host name encoding enables potential TLS certificate spoofing (GHSA-82r6-8w77-94w6, critical, fixed in 4.14.2)pypi:certifi 2025.1.31certifi bundles emSign root CAs with compromised intermediate CA keys (GHSA-6q48-6c7w-9gw2, critical, fixed in 2026.10.18)
See 8 more
pypi:h11 0.14.0— GHSA-vqfr-h8mv-ghfj (critical), fixed in 0.16.0pypi:pyjwt 2.10.1— GHSA-ffc3-869f-jxw9 (critical), fixed in 2.14.0pypi:aiohttp 3.11.16— GHSA-2g87-pp6c-29x5 (high), fixed in 3.14.4pypi:aiohttp 3.11.16— GHSA-5wr8-gcqf-gqf3 (high), fixed in 3.14.4pypi:aiohttp 3.11.16— GHSA-6mq8-rvhq-8wgg (high), fixed in 3.13.3pypi:aiohttp 3.11.16— GHSA-9xw5-w5jj-pvcg (high), fixed in 3.14.4pypi:aiohttp 3.11.16— GHSA-cq5v-8q36-5273 (high), fixed in 3.14.3pypi:mcp 1.25.0— GHSA-hvrp-rf83-w775 (high), fixed in 1.27.2
30 more findings not listed here.
You need first
- Runtimes:
python>=3.12 - Keys or accounts: OpenAI API key (only for experimental LLM index tuning)
What it does
pickfit hasn’t run it yet, so these come from the README only.
- Check the health of a Postgres databaseNot tested
- Get index recommendations for a workloadNot tested
- Review EXPLAIN plans with hypothetical indexesNot tested
- Run SQL in read-only access modeNot tested
Good for
- check the health of a Postgres database
- find the slowest queries and speed them up
- get index recommendations for a workload
An alternative to Reference PostgreSQL MCP Server and Dexter.