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.

About

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

Performance verification by comparing query plans post-optimization
Identification of performance bottlenecks like full table scans and high-cost joins
Expert interpretation of database EXPLAIN and EXPLAIN ANALYZE outputs
883 GitHub stars
Query refactoring suggestions to reduce resource consumption
Automated recommendations for missing indexes based on query filters

Use Cases

Translating complex query execution plans into human-readable insights
Identifying missing database indexes during the development phase
Optimizing 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

GitHub