P

pg-perf-mcp

gouranshul/pg-perf · v0.1.0 · Tools & Integrations

by gouranshulOwner verifiedScan grade: caution

Read-only MCP server that lets AI assistants diagnose PostgreSQL performance: slow queries, EXPLAIN plans, index advice, locks, and the queries inside database functions

Follow0
Protect this install with HOL Guard

Guard checks the skills and MCP servers a plugin adds on your machine and asks you before a risky action runs. The scores above are free, and no plan changes them.

Is pg-perf-mcp a fit?

From the plugin's manifest and HOL's scan. Anything the plugin does not declare is shown as not declared.

Works with

  • Claude Code
  • MCP
  • 1 MCP server

Before you install

Sign-in
Not declared
Settings it asks for
pg-perf-mcp endpoint, API key (secret)
Declared access
Not declared
License
MIT

Check before relying on it

What is pg-perf-mcp?

pg-perf-mcp is a published tools & integrations plugin for AI coding agents that works with Claude Code and MCP, developed by gouranshul and distributed through the HOL AI plugin registry. Read-only MCP server that lets AI assistants diagnose PostgreSQL performance: slow queries, EXPLAIN plans, index advice, locks, and the queries inside database functions.

Canonical slug
gouranshul/pg-perf
Version
v0.1.0 · updated Oct 15, 2026

Registry snapshot

Owner verification
Verified on HOL as @gouranshul
Scanner
Registry fallback scan
Security result
Caution
Digest verified
Yes

Trust and security

Trust & reputation

On-Chain Verified
65

HOL Trust Score

Per-metric points (0–100 each) combined via a weighted average into the overall score.

Installability
64/100
Maintenance
55/100
MCP server setup
100/100
Plugin Security
59/100
Provenance
80/100
Publisher Quality
100/100

Provenance

Plugin root
.
Source repo
https://github.com/gouranshul/pg-perf-mcp
Source commit
3f46eda54be9…
Publisher verified
Yes
Owner verified
@gouranshul

Continuous scanner CI not detected

This plugin remains listed. Its overall trust score is reduced by 10% because security checks are not maintained in the source repository's CI.

Optional: maintain the scanner in the source repository's CI to receive the full trust score. Listing does not require that change.

README badge not detected

Plugin owners can add the HOL badge to the repository README from Guard Plugins. Distribution, not security evidence. It adds a 2% engagement adjustment to the overall trust score and never changes the security result.

Caution
Security result
59
Security score
0
High findings
Provider
registry-broker-fallback
Grade
F · caution
Version
Unknown
cisco-skill-scanner: not_applicable

Published advisories

None matched in GitHub security advisories, checked . This covers published advisories only, not problems nobody has reported.

GitHub security advisories are those the source repository has published.

Findings

mediumpublishabilitypublishability.link.missing.websiteURL

websiteURL should be present for marketplace readiness.

mediumpublishabilitypublishability.link.missing.privacyPolicyURL

privacyPolicyURL should be present for marketplace readiness.

mediumpublishabilitypublishability.link.missing.termsOfServiceURL

termsOfServiceURL should be present for marketplace readiness.

lowoperational-securitysupply-chain.lockfile-missing

Repository snapshot does not include a lockfile.

Install guidance

Install in Claude Code

Install through the Claude Code plugin marketplace.

Claude Code plugin docs

Optional: install HOL Guard for Claude Code first, so it can check this plugin's tools on your machine before Claude Code uses them.

  1. 1

    Add the marketplace

    Run this inside a Claude Code session. It registers the marketplace manifest shipped at the repository root. If the repository ships none, add the generated entry from the Advanced section below first.

    claude code
  2. 2

    Find the marketplace and plugin names

    The install id is <plugin-entry>@<marketplace-name>, and the marketplace name is declared inside the manifest — it can differ from the repository name. List registered marketplaces to read both names.

    shell
  3. 3

    Install the plugin

    Substitute the plugin entry name and the marketplace name shown by the previous step.

    claude code

Did setup work in Claude Code?

No setup reports for Claude Code yet. Self-reported by signed-in visitors. Copying a command is not counted, and most installs are never reported.

Attested installs: Fewer than 10 attested installs of this plugin in week 2026-W43, so no number is shown. Counted from opt-in HOL Guard install reports, once per machine and runtime, and never mixed with the answers above. How install reports work.

Loading reviews

Plugin manifest

{
  "name": "pg-perf",
  "displayName": "PostgreSQL Performance (read-only)",
  "version": "0.1.0",
  "description": "Read-only PostgreSQL performance diagnostics over MCP: slow queries, EXPLAIN summaries, index advice, table health, locks and slow database functions. Connects to a running pg-perf-mcp server.",
  "author": {
    "name": "Anshul Gour",
    "url": "https://github.com/gouranshul"
  },
  "homepage": "https://github.com/gouranshul/pg-perf-mcp#readme",
  "repository": "https://github.com/gouranshul/pg-perf-mcp",
  "license": "MIT",
  "keywords": [
    "postgresql",
    "performance",
    "explain",
    "pg_stat_statements",
    "mcp",
    "read-only"
  ],
  "userConfig": {
    "mcp_url": {
      "type": "string",
      "title": "pg-perf-mcp endpoint",
      "description": "URL of the running server's MCP endpoint",
      "default": "http://localhost:8080/mcp"
    },
    "api_key": {
      "type": "string",
      "title": "API key",
      "description": "The value of MCP_API_KEY the server was started with",
      "required": true,
      "sensitive": true
    }
  },
  "mcpServers": "./.registry/mcp.json",
  "interface": {
    "displayName": "PostgreSQL Performance (read-only)",
    "developerName": "gouranshul"
  },
  "holManifestOrigin": "repository",
  "registryIndexVersion": 5
}

Marketplace source

Repo URL
https://github.com/gouranshul/pg-perf-mcp
Marketplace path
Unknown
Source path
.
Install policy
Unspecified

File inventory

.claude-plugin/plugin.json

file

1,257 bytes

896b4eee0e896fb5…

.codex-plugin/plugin.json

plugin-manifest

1,095 bytes

069e48ccec7c8c42…

.registry/mcp.json

mcp-config

133 bytes

47609483510443f4…

CLAUDE.md

file

3,780 bytes

f4f2f30251fd5c19…

README.md

file

16,916 bytes

15a3473ea6a9fb7d…

SECURITY.md

file

2,003 bytes

31ca58f0d015128a…

pg-perf-mcp — Frequently asked questions

What is pg-perf-mcp?
pg-perf-mcp is an AI plugin in the HOL registry. Read-only MCP server that lets AI assistants diagnose PostgreSQL performance: slow queries, EXPLAIN plans, index advice, locks, and the queries inside database functions.
How do I install pg-perf-mcp?
Install pg-perf-mcp in your harness: Claude Code — /plugin marketplace add gouranshul/pg-perf-mcp; MCP — git clone https://github.com/gouranshul/pg-perf-mcp. Full step-by-step guidance is on the HOL plugin page.
How do I install pg-perf-mcp in Claude Code?
To install pg-perf-mcp in Claude Code, start with /plugin marketplace add gouranshul/pg-perf-mcp. The complete step-by-step install guide for Claude Code is on the HOL plugin page.
How do I install pg-perf-mcp in MCP?
To install pg-perf-mcp in MCP, start with git clone https://github.com/gouranshul/pg-perf-mcp. The complete step-by-step install guide for MCP is on the HOL plugin page.
How is the Trust Score for pg-perf-mcp computed?
pg-perf-mcp has a HOL Trust Score of 65 out of 100. The score is a weighted sum of six components from a static scan of the source, capped for high-severity findings and adjusted by two disclosed policies. Memberships and payments are not inputs, and a scan is not a safety guarantee. Full breakdown: https://hol.org/registry/plugins/gouranshul%2Fpg-perf/trust
Who publishes pg-perf-mcp?
pg-perf-mcp is published by gouranshul and listed on HOL.

Install signal

HOL cannot see every install. These are separate signals from different sources, so they are not added together. Counts under each floor show as <N.

Install commands issued here
<5
HOL Guard install commands issued from this listing, last 28 days.
Opt-in install reports
<10
Machines that reported installing it through HOL Guard in week 2026-W43. Reporting is opt-in, so most installs are not counted.
HOL Guard workspaces
<5
Workspaces that approved it or include it in an approved-plugin feed, as of today.

Reviews and similar plugins