What it is

An open-source Postgres server from Crystal DBA spanning the full lifecycle: index tuning with industrial-strength search, health checks for buffer cache, connections, index bloat and vacuum, EXPLAIN plans with hypothetical indexes via hypopg, and configurable SQL execution. The steering group's own Postgres reference server is archived.

Why it earns a slot

Beyond running queries it tells the agent why a query is slow and which index fixes it. Restricted mode gives read-only transactions with execution time limits, which is what you want near real data.

Know before you commit

Unrestricted mode is full read/write — dev databases only. Needs Python 3.12+ or Docker rather than a one-line npx, and it is community-maintained, not first-party Postgres.

Getting started

pipx install postgres-mcp

Field notes

0 from the community

Sign in to add a field note. Reading is always open.

Loading notes…

Field check

Unverified

Sign in to confirm this entry is still accurate.

Pricing snapshot

Free, MIT

Snapshots move fast — verify at checkout, and post a field note if it changed.

Drop into your Lovable chat

Evaluate Postgres MCP Pro (https://github.com/crystaldba/postgres-mcp) for this project, then use it only if it fits what we are already building.
Context: Community MCP server (Postgres). An open-source Postgres server from Crystal DBA spanning the full lifecycle: index tuning with industrial-strength search, health checks for buffer cache, connections, index bloat and vacuum, EXPLAIN plans with hypothetical indexes via hypopg, and configurable SQL execution. The steering group's own Postgres reference server is archived.
Reviewer notes (general, not written for this codebase): Beyond running queries it tells the agent why a query is slow and which index fixes it. Restricted mode gives read-only transactions with execution time limits, which is what you want near real data.
Watch out for: Unrestricted mode is full read/write — dev databases only. Needs Python 3.12+ or Docker rather than a one-line npx, and it is community-maintained, not first-party Postgres.
Pricing: Free, MIT
Setup: pipx install postgres-mcp
Rules: treat the notes above as background only. Do not assume a theme, style, layout or feature that is not already in this project — inspect the existing code first and ask me before changing visual direction.

/api/public/tools/postgres-mcp-pro