Connect

8 clients · secrets stay placeholders

JSON (mcpServers)Claude CodeCodexOpenCodeCursorVS CodeGemini CLIGoose

{
  "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}"
      }
    }
  }
}

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

[mcp_servers.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}" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "pgmcp": {
      "type": "local",
      "command": [
        "docker",
        "run",
        "-i",
        "--rm",
        "-e",
        "PGMCP_DATABASE_URL",
        "ghcr.io/pascalallen/pgmcp:1.1.0"
      ],
      "enabled": true,
      "environment": {
        "PGMCP_DATABASE_URL": "{env:PGMCP_DATABASE_URL}"
      }
    }
  }
}

{
  "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}"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=pgmcp&config=eyJjb21tYW5kIjoiZG9ja2VyIiwiYXJncyI6WyJydW4iLCItaSIsIi0tcm0iLCItZSIsIlBHTUNQX0RBVEFCQVNFX1VSTCIsImdoY3IuaW8vcGFzY2FsYWxsZW4vcGdtY3A6MS4xLjAiXSwiZW52Ijp7IlBHTUNQX0RBVEFCQVNFX1VSTCI6IiR7UEdNQ1BfREFUQUJBU0VfVVJMfSJ9fQ%3D%3D"
}

{
  "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}"
      }
    }
  }
}

{
  "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}"
      }
    }
  }
}

extensions:
  "pgmcp":
    enabled: true
    name: "pgmcp"
    type: stdio
    cmd: "docker"
    args:
      - "run"
      - "-i"
      - "--rm"
      - "-e"
      - "PGMCP_DATABASE_URL"
      - "ghcr.io/pascalallen/pgmcp:1.1.0"
    envs:
      "PGMCP_DATABASE_URL": "${PGMCP_DATABASE_URL}"
    timeout: 300

Placeholders to fill from your own secret store: ${PGMCP_DATABASE_URL}. The registry never accepts secret values.

This is a local package: the command runs on your machine.

Quality – / 100not scored

Not scored: fewer than three checks apply, usually because no remote answered a credential-free probe or the server is a local package.

protocoln/a · weight 25

n/a
protocol.modern, protocol.stateless, protocol.transport, protocol.list_ttlno remote answered a protocol handshake (not probed yet, unreachable, or local-only)

authorizationn/a · weight 15

n/a
auth.prm, auth.as_metadata, auth.cimdno remote uses OAuth
n/a
auth.secret_in_urlno templated URL

tool hygienen/a · weight 30

n/a
tools.descriptions, tools.description_length, tools.schemas, tools.annotations, tools.directory_hints, tools.token_cost, tools.api_dumptool list unknown (behind auth, not probed, or empty)

stabilityn/a · weight 15

n/a
stability.changes, stability.rug_pulltool list unknown

dependenciesn/a · weight 15

n/a
deps.known_vulns, deps.mcp_sdk_version, deps.resolvableno npm or PyPI package

Tool list unknown · checked 2026-10-19 10:20 UTC

Tool changes

No tool definition changes recorded. A server's first observation is its baseline; later probes record what changes.

Checks run on what our credential-free, read-only probes observe; tools are never called and no code audit is performed. How it is computed.

Trust 90 / 100

provenance90

livenessn/a

freshness85

hygiene95

+repository +namespace-matches-repo +website ~liveness-unmeasured ~updated-60d-ago -unpinned-packages(2)

Derived from observable signals (official registry feed and our own credential-free probes); no code audit performed. How it is computed.

Endpoints

package	registry	version	runtime	secrets
`ghcr.io/pascalallen/pgmcp:1.1.0`	oci	unpinned	–	`PGMCP_DATABASE_URL`
`https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb`	mcpb	unpinned	–	`PGMCP_DATABASE_URL`

Tools (0)

No tools observed. Local packages are never executed by the registry.

Schemas: list_tools.

Similar MCP servers

Official server.json

{
  "name": "io.github.pascalallen/pgmcp",
  "title": "pgmcp",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "1.1.0",
  "packages": [
    {
      "transport": {
        "type": "stdio"
      },
      "identifier": "ghcr.io/pascalallen/pgmcp:1.1.0",
      "registryType": "oci",
      "environmentVariables": [
        {
          "name": "PGMCP_DATABASE_URL",
          "isSecret": true,
          "isRequired": true,
          "description": "Postgres connection string (read-only role recommended)"
        }
      ]
    },
    {
      "transport": {
        "type": "stdio"
      },
      "fileSha256": "10c7a4c328edddbcc0e1b0c3df7f25113b865676861bed79a52d9a4b9246ad13",
      "identifier": "https://github.com/pascalallen/pgmcp/releases/download/v1.1.0/pgmcp_1.1.0.mcpb",
      "registryType": "mcpb",
      "environmentVariables": [
        {
          "name": "PGMCP_DATABASE_URL",
          "isSecret": true,
          "isRequired": true,
          "description": "Postgres connection string (read-only role recommended)"
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/pascalallen/pgmcp",
    "source": "github"
  },
  "websiteUrl": "https://github.com/pascalallen/pgmcp",
  "description": "Read-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health."
}