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

데이터베이스 관리

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.

주요 기능

Automated EXPLAIN plan interpretation and analysis
Actionable indexing and query rewriting recommendations
Integration with schema exploration tools
Bottleneck identification for full table scans and slow joins
Database resource utilization optimization
883 GitHub stars

사용 사례

Identifying missing database indexes to improve read performance
Optimizing slow-running production SQL queries
Troubleshooting 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

GitHub

소개