Loading MCP server directory, please wait...
Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions
npx @getmcp/cli add io.github.gouranshul/pg-perf-mcpRequires Docker Engine. Community-contributed server. Review source before installing.
PGPERF_DB_URLJDBC 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_USERA read-only role with pg_read_all_stats and pg_monitor (see docker/init.sql)
PGPERF_DB_PASSWORDPassword of that role
MCP_API_KEYBearer token clients must send, at least 16 characters (32+ random recommended)
Config file: ~/Library/Application Support/Claude/claude_desktop_config.json
{
"mcpServers": {
"io.github.gouranshul/pg-perf-mcp": {
"command": "docker",
"args": [
"127.0.0.1:8080:8080",
"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": "",
"PGPERF_DB_USER": "mcp_readonly",
"PGPERF_DB_PASSWORD": "",
"MCP_API_KEY": ""
}
}
}
}Ephemeral data sandbox for AI workflows with guardrails and security
Self-hosted homelab log intelligence over MCP, CLI, and REST with SQLite/FTS.
Rust MCP server for homelab logs, syslog, Docker logs, FTS search, and AI transcript correlation.
Rust MCP server and CLI for Unraid GraphQL operations across NAS, Docker, VM, and storage workflows.