Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks.
This skill transforms Claude into a database performance expert capable of interpreting complex EXPLAIN plans and query metrics to boost application speed. By identifying inefficiencies such as full table scans or suboptimal join operations, it provides actionable recommendations for indexing, query rewriting, and configuration adjustments to ensure database resource utilization is maximized and latency is minimized.
主な機能
01Interprets complex EXPLAIN plans to identify hidden performance bottlenecks.
02Provides specific SQL query rewriting recommendations for better execution paths.
03Identifies missing indexes and suggests optimal indexing strategies for specific queries.
040 GitHub stars
05Detects inefficient join operations and unnecessary full table scans.
06Analyzes query metrics to improve overall database resource utilization and speed.
ユースケース
01Troubleshooting high database CPU usage and resource contention issues.
02Optimizing slow-running production SQL queries with high latency.
03Interpreting and visualizing EXPLAIN plans for complex database schemas.
