Can this skill suggest specific indexing strategies?

Yes, the skill can recommend specific columns to index or suggest changes to composite indexes based on the filtering and join logic in your query.

How does Claude analyze query performance?

Claude utilizes the query-performance-analyzer plugin to interpret EXPLAIN plans and query metrics, identifying inefficiencies like missing indexes or full table scans.

What information should I provide for the best results?

For the most accurate analysis, provide both the full SQL query and the complete output of the EXPLAIN command from your database.

Does it support rewriting queries?

Absolutely. If a query is structurally inefficient, Claude can suggest more performant alternatives, such as using EXISTS instead of IN or optimizing subqueries.

Query Performance Analyzer

Name: Query Performance Analyzer
Author: jeremylongshore

byjeremylongshore

•

883

•

Database Management

Analyzes database EXPLAIN plans to pinpoint performance bottlenecks and provide actionable optimization strategies.

This skill empowers developers to act as database performance experts by automatically interpreting complex EXPLAIN plans and query metrics within Claude. It pinpoints inefficiencies like full table scans, missing indexes, or suboptimal join operations, offering specific strategies to reduce latency and improve resource utilization. Whether you are troubleshooting a legacy slow query or optimizing a new feature, this skill streamlines the path to a faster, more efficient database layer.

Key Features

01Automated EXPLAIN plan interpretation and analysis

02Actionable indexing and query rewriting recommendations

03Integration with schema exploration tools

04Bottleneck identification for full table scans and slow joins

05Database resource utilization optimization

06883 GitHub stars

Use Cases

01Identifying missing database indexes to improve read performance

02Optimizing slow-running production SQL queries

03Troubleshooting high CPU usage caused by inefficient query execution

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills query-performance-analyzer

For use in Claude.ai and ChatGPT

Download Skill

Key Features

01Automated EXPLAIN plan interpretation and analysis

02Actionable indexing and query rewriting recommendations

03Integration with schema exploration tools

04Bottleneck identification for full table scans and slow joins

05Database resource utilization optimization

06883 GitHub stars

Use Cases

01Identifying missing database indexes to improve read performance

02Optimizing slow-running production SQL queries

03Troubleshooting high CPU usage caused by inefficient query execution

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills query-performance-analyzer

For use in Claude.ai and ChatGPT

Download Skill