analyzing-query-performance

## 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 1. **Receive Input**: The user provides an EXPLAIN plan, a slow query, or a description of a performance problem. 2. **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. 3. **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. ## Examples ### Example 1: Analyzing a Slow Query User request: "Here's the EXPLAIN plan for my slow query. Can you help me optimize it? ```EXPLAIN SELECT * FROM orders WHERE customer_id = 123 AND order_date > '2023-01-01';```" The skill will: 1. Analyze the provided EXPLAIN plan using the query-performance-analyzer plugin. 2. Identify potential issues, such as a missing index on `customer_id` or `order_date`, and suggest creating appropriate indexes. ### Example 2: Identifying a Bottleneck ...