{
  "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 <code>hypopg</code>, 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 <code>npx</code>, and it is community-maintained, not first-party Postgres.",
  "install": "pipx install postgres-mcp",
  "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-08-19T00:17:14.278+00:00"
  },
  "corrected_at": null,
  "upstream_changed_at": null
}