{
  "slug": "postgres-mcp-pro",
  "name": "Postgres MCP Pro",
  "url": "https://github.com/crystaldba/postgres-mcp",
  "cat": "mcp",
  "group": "ai",
  "tagline": "Community MCP server (Postgres)",
  "price": "Free, MIT",
  "tier": "free",
  "pick": false,
  "what": "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": "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.",
  "warn": "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.",
  "install": "pipx install postgres-mcp",
  "format": "text",
  "category": {
    "key": "mcp",
    "name": "MCP servers & registries",
    "desc": "How your agent reaches past the terminal. Directory scale is not a quality signal.",
    "group": "ai",
    "groupName": "Put AI inside it"
  },
  "freshness": null,
  "health": {
    "ok": true,
    "status_code": 200,
    "final_url": null,
    "checked_at": "2026-10-02T23:00:08.119+00:00"
  },
  "corrected_at": null,
  "upstream_changed_at": null
}