PostgreSQL Performance (read-only)

Name: PostgreSQL Performance (read-only)
Author: gouranshul

Community

MCP server by gouranshul · updated 3 days ago · ★ 0

Score 30

Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions PostgreSQL Performance (read-only) is a community project by gouranshul, not verified by a company domain.

Install Add to Cursor Add to VS Code GitHub Website

Yours? Claim it

Works withClaude Code Claude Desktop Cursor Codex Gemini CLI VS Code Windsurf Antigravity CLI

Maintenance

Last commit 3 days ago

Licence

MIT: permissive, fine for commercial use

Quality

Clear description, published package or server URL, original repository

Security

Not checked yet. What we check

What you need

Setting	Needed	What it is
`PGPERF_DB_URL`Environment variable	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`Environment variable	Required	A read-only role with pg_read_all_stats and pg_monitor (see docker/init.sql) Default: `mcp_readonly`
`PGPERF_DB_PASSWORD`Environment variable, secret	Required	Password of that role
`MCP_API_KEY`Environment variable, secret	Required	Bearer token clients must send, at least 16 characters (32+ random recommended)

From the publisher's entry in the official MCP Registry. Required settings are already in the install config below as placeholders.

Install PostgreSQL Performance (read-only)

Built from the published package, never by AI

claude mcp add postgresql-performance-read-only -e PGPERF_DB_URL=YOUR_PGPERF_DB_URL -e PGPERF_DB_USER=YOUR_PGPERF_DB_USER -e PGPERF_DB_PASSWORD=YOUR_PGPERF_DB_PASSWORD -e MCP_API_KEY=YOUR_MCP_API_KEY -- docker run -i --rm -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

Run in your terminal. Add --scope user to use it in every project.

Step-by-step: install PostgreSQL Performance (read-only) in Claude Code

{
  "mcpServers": {
    "postgresql-performance-read-only": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-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": "YOUR_PGPERF_DB_URL",
        "PGPERF_DB_USER": "YOUR_PGPERF_DB_USER",
        "PGPERF_DB_PASSWORD": "YOUR_PGPERF_DB_PASSWORD",
        "MCP_API_KEY": "YOUR_MCP_API_KEY"
      }
    }
  }
}

Settings, Developer, Edit config. Paste into claude_desktop_config.json and restart.

Step-by-step: install PostgreSQL Performance (read-only) in Claude Desktop

{
  "mcpServers": {
    "postgresql-performance-read-only": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-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": "YOUR_PGPERF_DB_URL",
        "PGPERF_DB_USER": "YOUR_PGPERF_DB_USER",
        "PGPERF_DB_PASSWORD": "YOUR_PGPERF_DB_PASSWORD",
        "MCP_API_KEY": "YOUR_MCP_API_KEY"
      }
    }
  }
}

Add to ~/.cursor/mcp.json (all projects) or .cursor/mcp.json (this project).

Step-by-step: install PostgreSQL Performance (read-only) in Cursor

{
  "servers": {
    "postgresql-performance-read-only": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-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": "YOUR_PGPERF_DB_URL",
        "PGPERF_DB_USER": "YOUR_PGPERF_DB_USER",
        "PGPERF_DB_PASSWORD": "YOUR_PGPERF_DB_PASSWORD",
        "MCP_API_KEY": "YOUR_MCP_API_KEY"
      }
    }
  }
}

Add to .vscode/mcp.json. VS Code uses "servers", not "mcpServers".

Step-by-step: install PostgreSQL Performance (read-only) in VS Code

codex mcp add postgresql-performance-read-only --env PGPERF_DB_URL=YOUR_PGPERF_DB_URL --env PGPERF_DB_USER=YOUR_PGPERF_DB_USER --env PGPERF_DB_PASSWORD=YOUR_PGPERF_DB_PASSWORD --env MCP_API_KEY=YOUR_MCP_API_KEY -- docker run -i --rm -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

Step-by-step: install PostgreSQL Performance (read-only) in Codex

{
  "mcpServers": {
    "postgresql-performance-read-only": {
      "command": "docker",
      "args": [
        "run",
        "-i",
        "--rm",
        "-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": "YOUR_PGPERF_DB_URL",
        "PGPERF_DB_USER": "YOUR_PGPERF_DB_USER",
        "PGPERF_DB_PASSWORD": "YOUR_PGPERF_DB_PASSWORD",
        "MCP_API_KEY": "YOUR_MCP_API_KEY"
      }
    }
  }
}

Add to ~/.gemini/config/mcp_config.json (all projects) or .agents/mcp_config.json (this project).

Step-by-step: install PostgreSQL Performance (read-only) in Antigravity CLI

gemini mcp add postgresql-performance-read-only docker run -i --rm -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

Gemini CLI was replaced by Antigravity CLI in June 2026 and remains only for enterprise licences and paid API keys.

Step-by-step: install PostgreSQL Performance (read-only) in Gemini CLI

MCP servers run with your permissions and can read what you give them access to. Some need an API key: check the README and add it under env in the postgresql-performance-read-only block.

Weekly newsletter

Like PostgreSQL Performance (read-only)? Get the best new MCP servers every week

The best new tools, security warnings before you install something risky, and one practical tip. Free, three minute read.

Alternatives to PostgreSQL Performance (read-only)

All alternatives →

Supabase supabase

MCP server for interacting with the Supabase platform

AAB Local and remote 65k/wk

ArcadeDB MCP Server ArcadeData

Built-in MCP server for ArcadeDB multi-model database (graph, document, vector, time-series)

AAA Local 1.2k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

MCP Toolbox for Databasesgoogleapis

MCP Toolbox for Databases enables your agent to connect to your database.

AAA Local 17k

mcpkubeshark

Real-time Kubernetes network traffic visibility and API analysis for HTTP, gRPC, Redis, Kafka, DNS.

AAA Local 12k

Ruvector ruvnet

Self-learning vector database for Node.js — hybrid search, Graph RAG, FlashAttention-3, HNSW, 50+ attention mechanisms

AAA Local 72k/wk

PostgreSQL Performance (read-only) vs Supabase PostgreSQL Performance (read-only) vs ArcadeDB MCP Server PostgreSQL Performance (read-only) vs MCP Toolbox for Databases

PostgreSQL Performance (read-only): common questions

How do I install PostgreSQL Performance (read-only)?

In Claude Code run claude mcp add postgresql-performance-read-only -e PGPERF_DB_URL=YOUR_PGPERF_DB_URL -e PGPERF_DB_USER=YOUR_PGPERF_DB_USER -e PGPERF_DB_PASSWORD=YOUR_PGPERF_DB_PASSWORD -e MCP_API_KEY=YOUR_MCP_API_KEY -- docker run -i --rm -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. For Claude Desktop, Cursor and VS Code, paste the config shown above and restart. See the install guides.

Is PostgreSQL Performance (read-only) the official server?

PostgreSQL Performance (read-only) is a community project by gouranshul, not verified by a company domain.

Is PostgreSQL Performance (read-only) free?

The code is published under the MIT licence. The service it connects to may have its own pricing.

Is PostgreSQL Performance (read-only) safe to use?

It scores 30 of 100. Grades: maintenance A, licence A, quality C. The security check has not run for it yet. Review the code before you install. How grades work.

What are alternatives to PostgreSQL Performance (read-only)?

Does PostgreSQL Performance (read-only) work with ChatGPT?

Not directly. It runs locally, and ChatGPT only connects to remote servers with a URL. Use it in Claude Code, Claude Desktop, Cursor, VS Code or Codex.