Postgres DBA MCP
Bounded, read-only PostgreSQL access for AI assistants: nine DBA tools, compact CSV output
Open the source (opens github.com) https://github.com/a-lafon/postgres-dba-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: DATABASE_URI. Use a key with the least access you can.
What it is
MCP servers from io.github.a-lafon.
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 (stdio)
ghcr.io/a-lafon/postgres-dba-mcp:0.3.3
From the server's entry in the official MCP Registry
Settings it asks for
DATABASE_URIsecret required · PostgreSQL connection URI of the database to serve
Related
-
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 -
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 -
Postgres AIops
MCP serversGoverned PostgreSQL DBA ops: slow-query RCA, bloat/vacuum & blocking-lock analysis; 35 MCP tools.
postgres-aiops@0.13.0 -
pgmcp
MCP serversRead-only Postgres ops/DBA diagnostics: slow queries, EXPLAIN, locks, index and table health.
ghcr.io/pascalallen/pgmcp:1.1.0 -
dbatools-mcp-server
MCP serversMCP server for dbatools — exposes SQL Server management commands as MCP tools
dbatools-mcp-server@0.5.0 -
PerformanceStudio
MCP serversFree, open-source SQL Server execution plan analyzer — cross-platform GUI + CLI with 30 analysis rules, missing index detection, SSMS extension. Built-in MCP server for AI-assisted plan review.
git clone https://github.com/erikdarlingdata/PerformanceStudio.git