SERVER

pgmcp

Rank #25,642

io.github.pascalallen/pgmcp

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

2 versions

by pascalallen (1 servers)View repository ↗Claim this server

Listed & last published

Aug 20, 2026

OVERVIEW

pgmcp is a Model Context Protocol (MCP) server published by pascalallen. It ranks #25,642 of 132,046 servers tracked on MCP Toplist. pgmcp is listed across 2 registries — Official MCP and Glama, with 2 tracked versions. It was first listed on Aug 20, 2026 and most recently updated on Aug 20, 2026.

STANDING

#25,642of 132,046 tracked serversTop 25%

Ranks ahead of 106,404 of 132,046 servers on MCP Toplist.

CONNECT

Use pgmcp

API keyNeeds credentials

Requires user-supplied configuration before first use — typically an API key, token or connection string set via environment variables.

Docker image

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

Replace each placeholder with your own value before saving.

MCP bundle

Published as mcp bundle `https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb` — install it through your client’s extension manager.

Docker image

[mcp_servers.pgmcp]
command = "docker"
args = ["run", "-i", "--rm", "ghcr.io/pascalallen/pgmcp:1.1.0"]

[mcp_servers.pgmcp.env]
PGMCP_DATABASE_URL = "<your PGMCP_DATABASE_URL>"

Add to ~/.codex/config.toml. Replace each placeholder with your own value before saving.

MCP bundle

Published as mcp bundle `https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb` — install it through your client’s extension manager.

Docker image

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

Add to claude_desktop_config.json (Settings → Developer → Edit Config). Replace each placeholder with your own value before saving.

MCP bundle

Published as mcp bundle `https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb` — install it through your client’s extension manager.

Docker image

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

Add to ~/.cursor/mcp.json (global) or .cursor/mcp.json (per project). Replace each placeholder with your own value before saving.

MCP bundle

Published as mcp bundle `https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb` — install it through your client’s extension manager.

Docker image

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

Save as .vscode/mcp.json in your workspace. Replace each placeholder with your own value before saving.

MCP bundle

Published as mcp bundle `https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb` — install it through your client’s extension manager.

Docker image

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

Add to ~/.codeium/windsurf/mcp_config.json. Replace each placeholder with your own value before saving.

MCP bundle

Published as mcp bundle `https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb` — install it through your client’s extension manager.

Docker image

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

Replace each placeholder with your own value before saving.

MCP bundle

Published as mcp bundle `https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb` — install it through your client’s extension manager.

BADGE

Show your rank

Maintain this server? Add the live rank badge to your README — it updates automatically as the leaderboard changes.

Markdown

[![MCP Toplist](https://mcptoplist.com/badge/io.github.pascalallen%2Fpgmcp.svg)](https://mcptoplist.com/server/io.github.pascalallen%2Fpgmcp)

HTML

<a href="https://mcptoplist.com/server/io.github.pascalallen%2Fpgmcp"><img src="https://mcptoplist.com/badge/io.github.pascalallen%2Fpgmcp.svg" alt="MCP Toplist: Top 25% of 132,046" /></a>

Variants: append ?metric=score or ?metric=stars to the image URL.

REGISTRIES

Listed on 2 registries

ORGANIZATION

pascalallen

Organization

Servers in org

1

Versions across org

2

VERSIONS

Available versions (2)

Version	Published
1.1.0	Aug 20, 2026
1.0.0	Aug 20, 2026

FAQ

Frequently asked questions

Who maintains pgmcp?: pgmcp is maintained by pascalallen, which publishes 1 MCP server (2 total versions) tracked on MCP Toplist.
Is pgmcp listed on the Official MCP Registry?: Yes — pgmcp is listed on the Official MCP Registry, alongside Glama.
How many versions does pgmcp have?: MCP Toplist tracks 2 versions of pgmcp, most recently published on Aug 20, 2026.
Where can I find the source code for pgmcp?: The source code for pgmcp is hosted at github.com/pascalallen/pgmcp.

Used in projects

Do you run this server?

Add to a project

Community projects list the MCP servers behind real agents and apps. Publish yours and this page will link to it.

EXPLORE

All MCP Servers Official MCP Servers GitHub MCP Servers Best MCP Servers Most Active MCP Servers New MCP Servers Best New MCP Servers