Home/Directory/Data & Databases/Postgres

Postgres

@crystaldba · github.com/crystaldba/postgres-mcp

All-in-one MCP server for Postgres development and operations, with tools for performance analysis, tuning, and health checks

ClaimedData & DatabasesstdioToolslocal auth

GitHub

Install one command

terminal

$ pipx install postgres-mcp

Or add it with the Claude CLI: claude mcp add crystaldba-postgres-mcp

Tools exposed 3 tools

analyze_query_workload

get_top_queries

analyze_query_indexes

Configuration generate & copy

DATABASE_URI

OPENAI_API_KEY

Values are filled in locally in your browser — nothing is sent anywhere.

claude_desktop_config.json

{
  "mcpServers": {
    "crystaldba-postgres-mcp": {
      "command": "pipx",
      "args": ["install", "postgres-mcp"],
      "env": {
        "DATABASE_URI": "<your-database-uri>",
        "OPENAI_API_KEY": "<your-openai-api-key>"
      }
    }
  }
}

Paste the Claude Desktop snippet under mcpServers in your config, then restart Claude Desktop — or run the Claude Code command in your terminal.

Postgres

Install one command

Tools exposed 3 tools

Configuration generate & copy

Similar servers