postgres-mcp

Debug database connection issues including too many connections, idle transactions, lock contention, and connection pool exhaustion. Use when the database is unresponsive, connections are refused, or queries are stuck waiting.

Diagnose database health issues including cache performance, connection saturation, vacuum status, and unused indexes. Use when investigating database problems or running routine health checks.

Analyze slow queries and suggest optimizations including missing indexes and query rewrites. Use when investigating query performance, high CPU usage, or slow response times.