analyzing-query-performance
Installation
SKILL.md
Overview
This skill empowers Claude to act as a database performance expert. By analyzing EXPLAIN plans and query metrics, Claude can pinpoint inefficiencies and recommend targeted improvements to database queries.
How It Works
- Receive Input: The user provides an EXPLAIN plan, a slow query, or a description of a performance problem.
- Analyze Performance: The query-performance-analyzer plugin analyzes the provided information, identifying potential bottlenecks, such as full table scans, missing indexes, or inefficient join operations.
- Provide Recommendations: The plugin generates specific optimization recommendations, including suggesting new indexes, rewriting queries, or adjusting database configuration parameters.
When to Use This Skill
This skill activates when you need to:
- Analyze the EXPLAIN plan of a slow-running query.
- Identify performance bottlenecks in a database query.
- Obtain recommendations for optimizing database query performance.