How does this skill help with slow SQL queries?

It analyzes EXPLAIN plans provided by the user to identify bottlenecks like full table scans or inefficient joins and suggests specific optimizations and rewrites.

Do I need to provide the database schema?

While not strictly required, providing the schema alongside the EXPLAIN plan allows Claude to give much more accurate indexing and refactoring recommendations.

Does it work with all database types?

It is designed to interpret standard SQL EXPLAIN outputs commonly found in major relational databases like PostgreSQL, MySQL, and MariaDB.

Can it automatically apply the optimizations?

The skill provides the specific SQL commands and recommendations; you can then use Claude's built-in file editing capabilities to apply these changes directly to your code.

Can it suggest new indexes?

Yes, the skill identifies columns that would benefit from indexing based on your specific filter criteria, join conditions, and current scan types.

Query Performance Analyzer

Name: Query Performance Analyzer
Author: jeremylongshore

byjeremylongshore

•

883

데이터베이스 관리

Optimizes database query execution by analyzing EXPLAIN plans and identifying performance bottlenecks like missing indexes or inefficient joins.

소개

The Query Performance Analyzer skill empowers Claude to act as an expert Database Administrator by diagnosing slow-running queries and providing actionable optimization strategies. By interpreting EXPLAIN plans and query metrics, the skill pinpoints issues such as full table scans and sub-optimal join operations, subsequently offering recommendations for index creation, query refactoring, or configuration adjustments. It is an essential tool for developers and data engineers looking to improve application responsiveness and reduce database resource utilization within their development workflow.

주요 기능

Analyzes resource utilization to reduce unnecessary CPU and I/O overhead
Interprets complex SQL EXPLAIN plans to identify execution bottlenecks
883 GitHub stars
Detects missing database indexes and suggests optimal indexing strategies
Identifies inefficient patterns such as full table scans and Cartesian products
Provides specific SQL query rewrite recommendations for better performance

사용 사례

Pre-emptive optimization of new SQL queries before deployment to production
Analyzing database execution plans to identify resource-intensive operations
Debugging and fixing slow-running production database queries

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

소개