Optimize queries, analyze indexes, and find bottlenecks. Understand query performance, identify slow queries, analyze index usage, and maintain database performance.
This MCP server bundle is compatible with any MCP client including Claude Desktop, Cursor, and other Model Context Protocol implementations.
Get comprehensive table statistics: size on disk, index sizes, row count, last vacuum/analyze time, and dead tuple ratio. Essential for capacity plann...
Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, relationships, and sample v...
Analyze query performance with EXPLAIN ANALYZE. Returns execution plan with actual timing, rows processed, and performance bottlenecks. Essential for ...
Identify potential missing indexes by analyzing foreign keys and columns frequently used in WHERE clauses. Suggests CREATE INDEX statements for optimi...
Comprehensive index analysis tool. Without table parameter: finds unused/rarely-used indexes across database for optimization. With table parameter: d...
Analyze tables and suggest VACUUM and ANALYZE operations based on dead tuple ratio and last analyze time. Helps maintain database performance and recl...
Find slow queries from pg_stat_statements extension. Requires pg_stat_statements extension to be enabled. Returns queries sorted by total execution ti...
Show current database locks and identify blocking queries. Helps diagnose performance issues and deadlocks. Shows which queries are waiting for locks ...
Connect this Performance Analysis MCP server to any MCP client in minutes
Compatible with Claude Desktop, Cursor, and all Model Context Protocol clients
Model Context Protocol lets AI tools call external capabilities securely through a single URL. This bundle groups tools behind an MCP endpoint that many clients can use.
Skip the manual setup! Use the .mcpb file format for one-click installation. Check the Claude Desktop tab for setup instructions.
Select ChatGPT, Cursor, Claude Code, or another tab for copy-paste config.