Database Performance Debugging

What it does

This skill enables AI agents to analyze database query execution plans and identify performance bottlenecks within SQL workloads. It helps diagnose slow queries by examining index usage, join strategies, and resource consumption patterns directly from the source content context.

When to use it

• Diagnosing why specific reports or dashboards are loading slower than expected.
• Identifying missing indexes that cause full table scans on large datasets.
• Optimizing complex joins that result in high CPU or memory usage.
• Troubleshooting latency spikes caused by inefficient query structures.

Key capabilities

• Analyzes raw execution plans to reveal hidden inefficiencies.
• Detects suboptimal index utilization and suggests improvements.
• Evaluates join order and strategy for better performance.
• Highlights queries with excessive resource consumption.

Example prompts

• "Analyze this EXPLAIN output and tell me why the query is scanning the full table instead of using an index."
• "Review these slow query logs and identify the top three bottlenecks based on execution time and I/O wait."
• "Suggest an optimized version of this SQL join that reduces memory usage by avoiding a hash spill."

Tips & gotchas

Ensure you provide full execution plan details (like EXPLAIN ANALYZE) for accurate diagnosis, as partial logs may miss critical resource metrics. This skill is most effective when paired with actual query performance data rather than generic descriptions of slow behavior.