Postgres MCP Pro

Fit and risk

Setup

{
  "mcpServers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

{
  "servers": {
    "postgres": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "DATABASE_URI",
        "crystaldba/postgres-mcp",
        "--access-mode=unrestricted"
      ],
      "env": {
        "DATABASE_URI": "postgresql://username:password@localhost:5432/dbname"
      }
    }
  }
}

claude mcp add postgres -e DATABASE_URI=postgresql://username:password@localhost:5432/dbname -- docker run -i --rm -e DATABASE_URI crystaldba/postgres-mcp --access-mode=unrestricted

Check that it works

After startup, the client's tool list should show tools such as list_schemas, execute_sql, and analyze_db_health; asking "Check the health of my database and identify any issues" and getting buffer cache hit rate, connection, and index health results confirms the connection works.

Troubleshooting

1. Ensure DATABASE_URI is correct and the database is reachable
2. Check that required extensions (pg_stat_statements, hypopg) are installed
3. If using Docker, verify port and network configuration
4. Inspect server logs for error messages
5. Try different access modes (unrestricted or restricted)

Things to try

Once connected, you can ask your AI assistant things like:

• Check the health of my database and identify any issues.Copy
• What are the slowest queries in my database? And how can I speed them up?Copy
• Analyze my database workload and suggest indexes to improve performance.Copy
• Help me optimize this query: SELECT * FROM orders JOIN customers ON orders.customer_id = customers.id WHERE orders.created_at > '2023-01-01';Copy

Tools 9

No matching tools

Use cases

Supported clients

Listed from the project's documentation, not tested by this site.

Overview

Similar servers