Can this skill automatically apply changes to my database?

No, it provides specific optimization recommendations and rewritten queries which you can review and apply manually or via your migration tools.

How does the skill analyze database queries?

It utilizes the query-performance-analyzer plugin to interpret EXPLAIN plan output, identifying costly operations like sequential scans and nested loops.

Which databases are compatible with this skill?

The skill is designed to work with any database that provides EXPLAIN plan output, including PostgreSQL, MySQL, MariaDB, and SQL Server.

What information should I provide for the best results?

For the most accurate analysis, provide the full SQL query, the complete EXPLAIN plan, and ideally a summary of the relevant table schemas.

Query Performance Analyzer

Name: Query Performance Analyzer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Analyzes and optimizes database query performance by interpreting EXPLAIN plans and identifying execution bottlenecks.

This skill empowers Claude to act as a database performance expert, helping developers diagnose and resolve slow-running SQL queries. By processing EXPLAIN plans and query metrics, it pinpoints inefficiencies such as full table scans, missing indexes, or suboptimal join operations, and provides actionable recommendations for query rewriting or database schema adjustments to improve resource utilization and execution speed.

Key Features

01Detection of inefficient join algorithms and execution paths

02Automated EXPLAIN plan analysis and interpretation

03Targeted indexing strategy recommendations

04Query rewriting suggestions for improved execution efficiency

053 GitHub stars

06Identification of performance bottlenecks like full table scans

Use Cases

01Diagnosing slow-running production queries using database EXPLAIN plans

02Identifying missing database indexes to improve search and retrieval speed

03Optimizing complex SQL statements with multiple join and filter operations

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection query-performance-analyzer

For use in Claude.ai and ChatGPT

Download Skill