analyzing-query-performance
CommunityPinpoint & fix slow database queries.
Authorjeremylongshore
Version1.0.0
Installs0
System Documentation
What problem does it solve?
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, improving execution speed and resource utilization.
Core Features & Use Cases
- EXPLAIN Plan Interpretation: Automatically interpret complex EXPLAIN plans to identify bottlenecks.
- Bottleneck Identification: Detect full table scans, missing indexes, and inefficient joins.
- Optimization Recommendations: Suggest new indexes, query rewrites, or configuration adjustments.
- Use Case: Provide an EXPLAIN plan for a slow query and receive specific recommendations to make it run faster.
Quick Start
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:
- Analyze the provided EXPLAIN plan using the
query-performance-analyzerplugin. - Identify potential issues, such as a missing index on
customer_idororder_date, and suggest creating appropriate indexes.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: analyzing-query-performance Download link: https://github.com/jeremylongshore/claude-code-plugins-plus/archive/main.zip#analyzing-query-performance Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.