What should I provide to get the best optimization results?

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

Can it suggest specific database indexes?

Yes, it analyzes the WHERE and JOIN clauses within your query to identify missing indexes and suggests the most effective columns to index for better performance.

Does it work with different SQL dialects?

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

How does this skill analyze database queries?

The skill interprets EXPLAIN plans and query metrics provided by the user to pinpoint specific inefficiencies like full table scans, temporary files, or costly nested loops.

Can it help rewrite my SQL code?

Absolutely. Beyond indexing, it provides recommendations for restructuring queries, such as replacing subqueries with joins or optimizing filter logic.

Query Performance Analyzer

Name: Query Performance Analyzer
Author: jeremylongshore

byjeremylongshore

•

883

•

Database Management

Analyzes database EXPLAIN plans to identify performance bottlenecks and provides actionable optimization recommendations.

This skill transforms Claude into a virtual database administrator capable of diagnosing slow-running queries and inefficient data access patterns. By processing EXPLAIN plans and query metrics, it pinpoint issues such as full table scans, missing indexes, and suboptimal join operations, offering specific guidance on query rewriting and indexing strategies to improve execution speed and resource efficiency across various SQL databases.

Key Features

01Performance verification by comparing query plans post-optimization

02Identification of performance bottlenecks like full table scans and high-cost joins

03Expert interpretation of database EXPLAIN and EXPLAIN ANALYZE outputs

04883 GitHub stars

05Query refactoring suggestions to reduce resource consumption

06Automated recommendations for missing indexes based on query filters

Use Cases

01Translating complex query execution plans into human-readable insights

02Identifying missing database indexes during the development phase

03Optimizing slow-running production database queries to reduce latency

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

01Performance verification by comparing query plans post-optimization

02Identification of performance bottlenecks like full table scans and high-cost joins

03Expert interpretation of database EXPLAIN and EXPLAIN ANALYZE outputs

04883 GitHub stars

05Query refactoring suggestions to reduce resource consumption

06Automated recommendations for missing indexes based on query filters

Use Cases

01Translating complex query execution plans into human-readable insights

02Identifying missing database indexes during the development phase

03Optimizing slow-running production database queries to reduce latency

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