Connect your account, then chat with AI to run tools.
Optimize queries, analyze indexes, and find bottlenecks. Understand query performance, identify slow queries, analyze index usage, and maintain database performance.
Opens MCPBundles Studio with this server selected. After sign-in, chat and run tools from the same thread.
Browse all toolsDomain knowledge for Performance Analysis — workflow patterns, data models, and gotchas for your AI agent.
Capture execution plans, hunt historically slow statements, review index usage, maintain table statistics, spot missing indexes, and inspect blocking locks when latency spikes.
Full index analysis tool. Without table parameter: finds unused/rarely-used indexes across database for optimization. With table parameter: detailed u...
Run ANALYZE on a table to update query planner statistics. Returns updated statistics after analysis. Essential for maintaining query performance.
Identify potential missing indexes by analyzing foreign keys and columns frequently used in WHERE clauses. Suggests CREATE INDEX statements for optimi...
Analyze query performance with EXPLAIN ANALYZE. Returns execution plan with actual timing, rows processed, and performance bottlenecks. Essential for ...
Find slow queries from pg_stat_statements extension. Requires pg_stat_statements extension to be enabled. Returns queries sorted by total execution ti...
Get compact, token-efficient database schema description optimized for AI text-to-SQL. Returns tables with columns, types, relationships, and sample v...
Show current database locks and identify blocking queries. Helps diagnose performance issues and deadlocks. Shows which queries are waiting for locks ...
Get detailed table statistics: size on disk, index sizes, row count, last vacuum/analyze time, and dead tuple ratio. Essential for capacity planning a...
Analyze tables and suggest VACUUM and ANALYZE operations based on dead tuple ratio and last analyze time. Helps maintain database performance and recl...
Optimize queries, analyze indexes, and find bottlenecks. Understand query performance, identify slow queries, analyze index usage, and maintain database performance. It provides 9 tools that AI agents can use through the Model Context Protocol (MCP).
Add the MCPBundles server URL to your MCP client configuration (Claude Desktop, Cursor, VS Code, etc.). The URL format is: https://mcp.mcpbundles.com/bundle/postgres-performance. Authentication is handled automatically.
Performance Analysis provides 9 tools that can be called by AI agents, along with a SKILL.md that gives your AI agent domain knowledge about when and how to use them.
Performance Analysis uses API Key. PostgreSQL requires credentials. Connect via MCPBundles and authentication is handled automatically.
Connect Performance Analysis to any MCP client in minutes
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.
More developer tools integrations you might like
Ably is a real-time data streaming platform. Publish and subscribe to messages on channels, track pr...
This server provides AI-powered tools for creating entity-relationship diagrams, helping users visua...
Algolia is a hosted search engine as a service providing developers with tools to index and search t...
Alpic provides advanced AI-driven solutions for various applications, focusing on enhancing user exp...
Amazon Redshift is a fast, fully managed, petabyte-scale data warehouse service in the cloud. Run co...
Workflow: 'Help me ask a great Stack Overflow question'. Search for similar questions to avoid dupli...