protogrid
Sign inAdd to your agent

Search / io.github.gouranshul/pg-perf-mcp

PostgreSQL Performance (read-only)

L0· runs locally

Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions

v0.1.0 · active · repository · website · descriptor JSON · versions

Runs on your machine: something must execute the package.Only local packages are published (npm, PyPI, OCI, …). The registry never executes them, so tools are unknown until you run it.
Quality–not scored
Trust94of 100
Packages1
Tools seen0

Connect

8 clients · secrets stay placeholders
{
  "mcpServers": {
    "pg-perf-mcp": {
      "command": "docker",
      "args": [
        "-p",
        "127.0.0.1:8080:8080",
        "-e",
        "PGPERF_DB_URL",
        "-e",
        "PGPERF_DB_USER",
        "-e",
        "PGPERF_DB_PASSWORD",
        "-e",
        "MCP_API_KEY",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "env": {
        "PGPERF_DB_URL": "${PGPERF_DB_URL}",
        "PGPERF_DB_USER": "mcp_readonly",
        "PGPERF_DB_PASSWORD": "${PGPERF_DB_PASSWORD}",
        "MCP_API_KEY": "${MCP_API_KEY}"
      }
    }
  }
}
claude mcp add pg-perf-mcp -e "PGPERF_DB_URL=${PGPERF_DB_URL}" -e "PGPERF_DB_USER=mcp_readonly" -e "PGPERF_DB_PASSWORD=${PGPERF_DB_PASSWORD}" -e "MCP_API_KEY=${MCP_API_KEY}" -- docker -p 127.0.0.1:8080:8080 -e PGPERF_DB_URL -e PGPERF_DB_USER -e PGPERF_DB_PASSWORD -e MCP_API_KEY ghcr.io/gouranshul/pg-perf-mcp:0.1.0
[mcp_servers.pg-perf-mcp]
command = "docker"
args = ["-p", "127.0.0.1:8080:8080", "-e", "PGPERF_DB_URL", "-e", "PGPERF_DB_USER", "-e", "PGPERF_DB_PASSWORD", "-e", "MCP_API_KEY", "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"]
env = { "PGPERF_DB_URL" = "${PGPERF_DB_URL}", "PGPERF_DB_USER" = "mcp_readonly", "PGPERF_DB_PASSWORD" = "${PGPERF_DB_PASSWORD}", "MCP_API_KEY" = "${MCP_API_KEY}" }

{
  "$schema": "https://opencode.ai/config.json",
  "mcp": {
    "pg-perf-mcp": {
      "type": "local",
      "command": [
        "docker",
        "-p",
        "127.0.0.1:8080:8080",
        "-e",
        "PGPERF_DB_URL",
        "-e",
        "PGPERF_DB_USER",
        "-e",
        "PGPERF_DB_PASSWORD",
        "-e",
        "MCP_API_KEY",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "enabled": true,
      "environment": {
        "PGPERF_DB_URL": "{env:PGPERF_DB_URL}",
        "PGPERF_DB_USER": "mcp_readonly",
        "PGPERF_DB_PASSWORD": "{env:PGPERF_DB_PASSWORD}",
        "MCP_API_KEY": "{env:MCP_API_KEY}"
      }
    }
  }
}
{
  "mcpServers": {
    "pg-perf-mcp": {
      "command": "docker",
      "args": [
        "-p",
        "127.0.0.1:8080:8080",
        "-e",
        "PGPERF_DB_URL",
        "-e",
        "PGPERF_DB_USER",
        "-e",
        "PGPERF_DB_PASSWORD",
        "-e",
        "MCP_API_KEY",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "env": {
        "PGPERF_DB_URL": "${PGPERF_DB_URL}",
        "PGPERF_DB_USER": "mcp_readonly",
        "PGPERF_DB_PASSWORD": "${PGPERF_DB_PASSWORD}",
        "MCP_API_KEY": "${MCP_API_KEY}"
      }
    }
  },
  "deeplink": "cursor://anysphere.cursor-deeplink/mcp/install?name=pg-perf-mcp&config=eyJjb21tYW5kIjoiZG9ja2VyIiwiYXJncyI6WyItcCIsIjEyNy4wLjAuMTo4MDgwOjgwODAiLCItZSIsIlBHUEVSRl9EQl9VUkwiLCItZSIsIlBHUEVSRl9EQl9VU0VSIiwiLWUiLCJQR1BFUkZfREJfUEFTU1dPUkQiLCItZSIsIk1DUF9BUElfS0VZIiwiZ2hjci5pby9nb3VyYW5zaHVsL3BnLXBlcmYtbWNwOjAuMS4wIl0sImVudiI6eyJQR1BFUkZfREJfVVJMIjoiJHtQR1BFUkZfREJfVVJMfSIsIlBHUEVSRl9EQl9VU0VSIjoibWNwX3JlYWRvbmx5IiwiUEdQRVJGX0RCX1BBU1NXT1JEIjoiJHtQR1BFUkZfREJfUEFTU1dPUkR9IiwiTUNQX0FQSV9LRVkiOiIke01DUF9BUElfS0VZfSJ9fQ%3D%3D"
}
{
  "servers": {
    "pg-perf-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "-p",
        "127.0.0.1:8080:8080",
        "-e",
        "PGPERF_DB_URL",
        "-e",
        "PGPERF_DB_USER",
        "-e",
        "PGPERF_DB_PASSWORD",
        "-e",
        "MCP_API_KEY",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "env": {
        "PGPERF_DB_URL": "${PGPERF_DB_URL}",
        "PGPERF_DB_USER": "mcp_readonly",
        "PGPERF_DB_PASSWORD": "${PGPERF_DB_PASSWORD}",
        "MCP_API_KEY": "${MCP_API_KEY}"
      }
    }
  }
}
{
  "mcpServers": {
    "pg-perf-mcp": {
      "command": "docker",
      "args": [
        "-p",
        "127.0.0.1:8080:8080",
        "-e",
        "PGPERF_DB_URL",
        "-e",
        "PGPERF_DB_USER",
        "-e",
        "PGPERF_DB_PASSWORD",
        "-e",
        "MCP_API_KEY",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "env": {
        "PGPERF_DB_URL": "${PGPERF_DB_URL}",
        "PGPERF_DB_USER": "mcp_readonly",
        "PGPERF_DB_PASSWORD": "${PGPERF_DB_PASSWORD}",
        "MCP_API_KEY": "${MCP_API_KEY}"
      }
    }
  }
}
extensions:
  "pg-perf-mcp":
    enabled: true
    name: "pg-perf-mcp"
    type: stdio
    cmd: "docker"
    args:
      - "-p"
      - "127.0.0.1:8080:8080"
      - "-e"
      - "PGPERF_DB_URL"
      - "-e"
      - "PGPERF_DB_USER"
      - "-e"
      - "PGPERF_DB_PASSWORD"
      - "-e"
      - "MCP_API_KEY"
      - "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
    envs:
      "PGPERF_DB_URL": "${PGPERF_DB_URL}"
      "PGPERF_DB_USER": "mcp_readonly"
      "PGPERF_DB_PASSWORD": "${PGPERF_DB_PASSWORD}"
      "MCP_API_KEY": "${MCP_API_KEY}"
    timeout: 300

Placeholders to fill from your own secret store: ${PGPERF_DB_PASSWORD}, ${MCP_API_KEY}. 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-20 15:57 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 94 / 100

provenance90
livenessn/a
freshness100
hygiene95

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

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

Endpoints

packageregistryversionruntimesecrets
ghcr.io/gouranshul/pg-perf-mcp:0.1.0ociunpinned–PGPERF_DB_PASSWORD, MCP_API_KEY

Tools (0)

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

Schemas: list_tools.

Similar MCP servers

  • pgmcpL0
    io.github.pascalallen/pgmcp

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

  • Postgres (read-only)L0
    io.github.contextflo/postgres-mcp

    Read-only Postgres: drop-in for the archived server-postgres, with schema context.

  • pg-readonly-mcpL0
    io.github.les-k/pg-readonly-mcp

    A read-only Postgres MCP server that parses SQL rather than pattern-matching it.

  • PostgreSQL (hardened, read-only)L0
    io.github.Eszetael/postgres-mcp-hardened

    Read-only PostgreSQL over MCP. Writes refused at the parsed SQL, plus a READ ONLY transaction.

  • mcpgL0
    io.github.devopam/mcpg

    Production-grade PostgreSQL MCP server — 254 tools for query, tuning & ops, read-only by default.

  • postgresL0
    io.github.ofershap/postgres

    PostgreSQL MCP — query databases, inspect schemas, explain queries.

Official server.json
{
  "name": "io.github.gouranshul/pg-perf-mcp",
  "title": "PostgreSQL Performance (read-only)",
  "$schema": "https://static.modelcontextprotocol.io/schemas/2025-12-11/server.schema.json",
  "version": "0.1.0",
  "packages": [
    {
      "transport": {
        "url": "http://localhost:8080/mcp",
        "type": "streamable-http",
        "headers": [
          {
            "name": "Authorization",
            "value": "Bearer {api_key}",
            "isSecret": true,
            "variables": {
              "api_key": {
                "isSecret": true,
                "isRequired": true,
                "description": "The value you set for MCP_API_KEY"
              }
            },
            "isRequired": true,
            "description": "The same API key as MCP_API_KEY, sent as a bearer token"
          }
        ]
      },
      "identifier": "ghcr.io/gouranshul/pg-perf-mcp:0.1.0",
      "registryType": "oci",
      "runtimeArguments": [
        {
          "name": "-p",
          "type": "named",
          "value": "127.0.0.1:8080:8080",
          "description": "Publish the MCP endpoint on localhost only"
        }
      ],
      "environmentVariables": [
        {
          "name": "PGPERF_DB_URL",
          "isRequired": true,
          "description": "JDBC URL of the database to diagnose. From inside the container, use host.docker.internal for a database on your machine, e.g. jdbc:postgresql://host.docker.internal:5432/mydb"
        },
        {
          "name": "PGPERF_DB_USER",
          "default": "mcp_readonly",
          "isRequired": true,
          "description": "A read-only role with pg_read_all_stats and pg_monitor (see docker/init.sql)"
        },
        {
          "name": "PGPERF_DB_PASSWORD",
          "isSecret": true,
          "isRequired": true,
          "description": "Password of that role"
        },
        {
          "name": "MCP_API_KEY",
          "isSecret": true,
          "isRequired": true,
          "description": "Bearer token clients must send, at least 16 characters (32+ random recommended)"
        }
      ]
    }
  ],
  "repository": {
    "url": "https://github.com/gouranshul/pg-perf-mcp",
    "source": "github"
  },
  "websiteUrl": "https://github.com/gouranshul/pg-perf-mcp#readme",
  "description": "Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions"
}