MCP Server MCP

pgmcp

By github 👁 1 views ▲ 0 votes

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

Homepage Verified source GitHub

Install

oci:ghcr.io/pascalallen/pgmcp:1.1.0

Configuration Example

{
  "remotes": [],
  "packages": [
    {
      "registryType": "oci",
      "identifier": "ghcr.io/pascalallen/pgmcp:1.1.0",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "Postgres connection string (read-only role recommended)",
          "isRequired": true,
          "isSecret": true,
          "name": "PGMCP_DATABASE_URL"
        }
      ]
    },
    {
      "registryType": "mcpb",
      "identifier": "https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb",
      "fileSha256": "10c7a4c328edddbcc0e1b0c3df7f25113b865676861bed79a52d9a4b9246ad13",
      "transport": {
        "type": "stdio"
      },
      "environmentVariables": [
        {
          "description": "Postgres connection string (read-only role recommended)",
          "isRequired": true,
          "isSecret": true,
          "name": "PGMCP_DATABASE_URL"
        }
      ]
    }
  ]
}

mcp model-context-protocol oci mcpb