Postgres MCP Pro

uvx postgres-mcp --access-mode=restricted

{
  "mcpServers": {
    "postgres-mcp": {
      "command": "uvx",
      "args": [
        "postgres-mcp",
        "--access-mode=restricted"
      ]
    }
  }
}

Connects to a PostgreSQL instance through a connection string and exposes schema listing, SQL execution and EXPLAIN plans as tools. Beyond running queries it scans the workload to propose index candidates and reports health signals such as cache hit rates, vacuum status and connection utilisation. The access mode is configurable, so a restricted setup keeps the model read-only.