pgmcp MCP Server

by pascalallenio.github.pascalallen/pgmcpv1.1.0

Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.

0Dockerstdioofficial registry

context tax

queued

security

queued

cold start

queued

freshness

Maintained50d ago

Install pgmcp MCP server

claude mcp add pgmcp -e PGMCP_DATABASE_URL='<pgmcp-database-url>' -- docker run -i --rm -e PGMCP_DATABASE_URL ghcr.io/pascalallen/pgmcp:1.1.0

{
  "mcpServers": {
    "pgmcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "env": {
        "PGMCP_DATABASE_URL": "<pgmcp-database-url>"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (project).

{
  "mcpServers": {
    "pgmcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "env": {
        "PGMCP_DATABASE_URL": "<pgmcp-database-url>"
      }
    }
  }
}

Settings → Developer → Edit Config (claude_desktop_config.json), then restart.

{
  "servers": {
    "pgmcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "env": {
        "PGMCP_DATABASE_URL": "<pgmcp-database-url>"
      }
    }
  }
}

Add to .vscode/mcp.json in your workspace.

{
  "mcpServers": {
    "pgmcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "env": {
        "PGMCP_DATABASE_URL": "<pgmcp-database-url>"
      }
    }
  }
}

Add to ~/.codeium/windsurf/mcp_config.json.

Configuration

Variable	Required	Secret	Description
PGMCP_DATABASE_URL	yes	yes	Postgres connection string (read-only role recommended)

Freshness

Maintained — last maintenance signal 50d ago. The newest of the signals below sets the band.

Last commit (default branch)
2026-08-20 · 50d ago · GitHub
Latest release
2026-08-20 · 50d ago · GitHub · v1.1.0
Package published
no data · npm/PyPI
Registry entry updated
2026-08-20 · 50d ago · official registry · v1.1.0

FAQ

›How do I install the pgmcp MCP server in Claude Code?

Run: claude mcp add pgmcp -e PGMCP_DATABASE_URL='<pgmcp-database-url>' -- docker run -i --rm -e PGMCP_DATABASE_URL ghcr.io/pascalallen/pgmcp:1.1.0. For Cursor, VS Code, Claude Desktop and Windsurf, use the install tabs above.

›Does pgmcp require an API key?

Yes. It expects PGMCP_DATABASE_URL, of which 1 is a secret.

›Can I use pgmcp as a remote (hosted) MCP server?

No hosted endpoint is published; it runs locally over stdio.

›Is pgmcp in the official MCP registry?

Yes, as io.github.pascalallen/pgmcp.