Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions
PostgreSQL Performance (read-only) is an MCP integration. Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions.
The published oci package is ghcr.io/gouranshul/pg-perf-mcp:0.1.0. Its declared MCP transport is streamable-http.
The package declares 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): Password of that role; MCP_API_KEY (required): Bearer token clients must send, at least 16 characters (32+ random recommended).
This package has launch arguments in its registry record. Use the maintainer’s configuration for those arguments rather than launching it with only the package name.
Check the maintainer’s instructions for account access, authentication and the supported client configuration. Once connected, inspect the tools your client receives and try a small task that matches the server’s stated purpose. The registry description does not include a verified, complete tool list.
View the publisher’s registry entry · Project repository · Project website. This profile uses version 0.1.0 from the registry. Registration identifies the publisher namespace; it does not establish that this is a first-party integration for every service it connects.
Browse related databases MCP servers for tools that cover the same kind of work.
| Variable | Description | Required |
|---|---|---|
| PGPERF_DB_URL | 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 | Yes |
| PGPERF_DB_USER | A read-only role with pg_read_all_stats and pg_monitor (see docker/init.sql) | Yes |
| PGPERF_DB_PASSWORD | Password of that role | Yes |
| MCP_API_KEY | Bearer token clients must send, at least 16 characters (32+ random recommended) | Yes |
Inspect PostgreSQL schemas and run read-only queries with the archived MCP reference server. Review its maintenance status before choosing it.
Connect the Notion MCP server to search workspace content and work with pages and databases through Notion’s hosted OAuth service.
Use the Supabase MCP server to inspect database schemas, query project data and retrieve docs through a project-scoped connection.
Query, modify and analyse local SQLite databases in conversation — the fastest way to chat with a data file.
Metabase ships its own MCP endpoint — search your BI content, build and run queries, and save questions and dashboards without leaving the chat.
Official MongoDB server covering data, schemas and Atlas management — from find queries to spinning up clusters.