postgres-mcp

Why we included this project

postgres-mcp is a Model Context Protocol server that gives AI coding agents a governed way to work with Postgres, plugging directly into assistants like Claude Desktop and Cursor. Beyond plain SQL access it also handles performance work that usually needs a DBA: it can tune indexes by exploring many candidates, review EXPLAIN plans while simulating hypothetical indexes, and run health checks that cover vacuum state, replication lag, buffer cache, and connection utilization. The configurable access controls matter in production, where you can force read-only mode or strict safe-SQL parsing instead of letting agents write freely. Teams building agents that need to touch a real Postgres database without risking the data will find this a solid option.