PostgreSQL Performance (read-only)
Read-only PostgreSQL performance diagnostics: slow queries, EXPLAIN, index advice, locks, functions
Open the source (opens github.com) https://github.com/gouranshul/pg-perf-mcp
Before you use it
- Runs on your computer with your permissions. Read what it can do before connecting it to an agent.
- Needs credentials: MCP_API_KEY, PGPERF_DB_PASSWORD. Use a key with the least access you can.
What it is
MCP servers from io.github.gouranshul.
The problem it solves and who it suits haven't been reviewed by InnerVault. The description above is the source's own.
How to get it
oci package (streamable-http)
ghcr.io/gouranshul/pg-perf-mcp:0.1.0
From the server's entry in the official MCP Registry
Settings it asks for
PGPERF_DB_URLrequired · JDBC URL of the database to diagnose. From inside the container, use host.docker.internal for a database on your machine, e.g…PGPERF_DB_USERrequired · A read-only role with pg_read_all_stats and pg_monitor (see docker/init.sql)PGPERF_DB_PASSWORDsecret required · Password of that roleMCP_API_KEYsecret required · Bearer token clients must send, at least 16 characters (32+ random recommended)
Related
-
pgtriage
MCP serversRead-only MCP server for evidence-based PostgreSQL performance auditing.
pgtriage@0.3.0 -
MCP-PostgreSQL-Ops
MCP servers🐘 Give AI assistants full PostgreSQL DBA superpowers — 30+ tools for performance analysis, bloat detection, lock/deadlock monitoring, autovacuum & schema inspection. No extensions required. PG 12-18.
git clone https://github.com/call518/MCP-PostgreSQL-Ops.git -
PostgreSQL performance Tuner MCP Server
MCP serversprovides AI-powered PostgreSQL performance tuning capabilities.
pgtuner-mcp@0.5.2 -
PerformanceMonitor
MCP serversFree, open-source SQL Server and Postgres performance monitoring. Collectors, real-time alerts, graphical plan viewer, MCP server for AI analysis. Supports SQL 2016-2025, Azure SQL, AWS RDS, Postgres, Aurora Postgres.
git clone https://github.com/erikdarlingdata/PerformanceMonitor.git -
culprit-sql-studio
MCP serversFind what's slowing your database down: a free desktop app, CLI and MCP server for SQL Server, PostgreSQL, YugabyteDB, TimescaleDB, MySQL, MariaDB and SQLite performance (slow queries, execution plans, indexes, blocking, deadlocks).
git clone https://github.com/cristipufu/culprit-sql-studio.git -
DBeast PostgreSQL MCP
MCP serversPostgreSQL MCP server for schema, query, health, security, and performance analysis.
ghcr.io/snss10/dbeast:2.0.2