NestDaddy
All servers NestDaddy MCP Blog Sign inTry it free
Databases

PostgreSQL Performance (read-only)

io.github.gouranshul/pg-perf-mcp · v0.1.0

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

Website Source code Set it up

Connect Runs on your machine

Terminal
claude mcp add pg-perf-mcp -e PGPERF_DB_URL=<PGPERF_DB_URL> -e PGPERF_DB_USER=<PGPERF_DB_USER> -e PGPERF_DB_PASSWORD=<PGPERF_DB_PASSWORD> -e MCP_API_KEY=<MCP_API_KEY> -- docker run -i --rm ghcr.io/gouranshul/pg-perf-mcp:0.1.0
claude_desktop_config.json
{
  "mcpServers": {
    "pg-perf-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "env": {
        "PGPERF_DB_URL": "<PGPERF_DB_URL>",
        "PGPERF_DB_USER": "<PGPERF_DB_USER>",
        "PGPERF_DB_PASSWORD": "<PGPERF_DB_PASSWORD>",
        "MCP_API_KEY": "<MCP_API_KEY>"
      }
    }
  }
}
~/.cursor/mcp.json
{
  "mcpServers": {
    "pg-perf-mcp": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "env": {
        "PGPERF_DB_URL": "<PGPERF_DB_URL>",
        "PGPERF_DB_USER": "<PGPERF_DB_USER>",
        "PGPERF_DB_PASSWORD": "<PGPERF_DB_PASSWORD>",
        "MCP_API_KEY": "<MCP_API_KEY>"
      }
    }
  }
}
.vscode/mcp.json
{
  "servers": {
    "pg-perf-mcp": {
      "type": "stdio",
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "ghcr.io/gouranshul/pg-perf-mcp:0.1.0"
      ],
      "env": {
        "PGPERF_DB_URL": "<PGPERF_DB_URL>",
        "PGPERF_DB_USER": "<PGPERF_DB_USER>",
        "PGPERF_DB_PASSWORD": "<PGPERF_DB_PASSWORD>",
        "MCP_API_KEY": "<MCP_API_KEY>"
      }
    }
  }
}

Replace the values in angle brackets with your own. Keys stay on your machine; we never see them.

Tools

This server runs locally, so its tools are listed by your MCP client once it starts.

Environment variables

NameDescription
PGPERF_DB_URL
Required		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
PGPERF_DB_USER
Required		A read-only role with pg_read_all_stats and pg_monitor (see docker/init.sql)
PGPERF_DB_PASSWORD
Required, secret		Password of that role
MCP_API_KEY
Required, secret		Bearer token clients must send, at least 16 characters (32+ random recommended)

Details

Packageghcr.io/gouranshul/pg-perf-mcp:0.1.0 (OCI, streamable-http)
First published10 Oct 2026
Last updated10 Oct 2026
Registry nameio.github.gouranshul/pg-perf-mcp

More databases servers See all

  • VibeScale

    Pre-launch checks for AI-built apps: leaked keys, Supabase RLS gaps, browser-exposed env vars.

  • Imf Mcp Server

    Query IMF SDMX 3.0 macroeconomic dataflows — WEO, BOP, CPI, exchange rates, 190 countries.

  • Apex DB

    Vehicle specifications, emissions, and powertrain data with source provenance.

  • TrialBase DB

    Clinical trials across multiple registries with identifiers and source links.

  • PatchLabs

    Security checks for AI-built apps (Lovable, Supabase, Bolt): RLS, headers, monitoring, fixes.

  • Tidy Byte Tools API

    Remote MCP for JSON repair, hashing, formatting, IDs, dates, units, and other small tools.

Listing data from the official MCP registry. Status and tools from NestDaddy's daily check. Browse all MCP servers.