PostgreSQL Performance (read-only)

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