PostgreSQL Performance (read-only)

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

What does this entry provide?

PostgreSQL Performance (read-only) is an MCP server entry in ChatHome Skills, sourced from Official MCP Registry and scored 78/100. As a Model Context Protocol server, it exposes tools that MCP-compatible LLM clients such as Claude, Cursor, and Copilot can call directly, extending an agent's reach beyond its built-in capabilities. ChatHome Skills discovered this entry through its daily ingest of official registries and GitHub discovery queries, and re-verifies repository facts, freshness signals, and install metadata on every run. The quality score weighs official-registry presence, a working install command, license clarity, GitHub star trajectory, and repository freshness — the full formula is on the Sources page. The install command above is ready to copy. Review the last-pushed date and repository status before adding PostgreSQL Performance (read-only) to a production agent workflow; the snapshot facts below are point-in-time values from the most recent ingest.

Snapshot facts

Source: Official MCP Registry
Quality: 78/100
Install method: oci
Repo: gouranshul/pg-perf-mcp
Repo updated: Oct 10, 2026

Install command

docker run -i --rm ghcr.io/gouranshul/pg-perf-mcp:0.1.0

Install method: oci

Review the upstream source before running this command.

GitHub project Homepage

Quality

Repo stars

Repo updated

Oct 10, 2026

How is this score calculated?

Weighted across six dimensions, scored 0-100.
Provenance (25): listed in an official or curated registry.
Installability (25): a runnable install command beats a declared transport, which beats a source checkout.
Maintenance (20): recency of the last push; archived entries score zero here.
Adoption (20): repository stars on a log curve.

MCP manifest

{
  "_meta": {
    "io.modelcontextprotocol.registry/official": {
      "status": "active",
      "isLatest": true,
      "updatedAt": "2026-10-10T13:42:12.172523Z",
      "publishedAt": "2026-10-10T13:42:12.172523Z",
      "statusChangedAt": "2026-10-10T13:42:12.172523Z"
    }
  },
  "server": {
    "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"
  }
}

Report an issue with this listing