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.

主要功能

01Analyzes resource utilization to reduce unnecessary CPU and I/O overhead

02Interprets complex SQL EXPLAIN plans to identify execution bottlenecks

03883 GitHub stars

04Detects missing database indexes and suggests optimal indexing strategies

05Identifies inefficient patterns such as full table scans and Cartesian products

06Provides specific SQL query rewrite recommendations for better performance

使用场景

01Pre-emptive optimization of new SQL queries before deployment to production

02Analyzing database execution plans to identify resource-intensive operations

03Debugging 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

主要功能

01Analyzes resource utilization to reduce unnecessary CPU and I/O overhead

02Interprets complex SQL EXPLAIN plans to identify execution bottlenecks

03883 GitHub stars

04Detects missing database indexes and suggests optimal indexing strategies

05Identifies inefficient patterns such as full table scans and Cartesian products

06Provides specific SQL query rewrite recommendations for better performance

使用场景

01Pre-emptive optimization of new SQL queries before deployment to production

02Analyzing database execution plans to identify resource-intensive operations

03Debugging 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