Is this useful for complex joins?

Absolutely. It helps identify inefficient join orders and suggests more performant alternatives to reduce temporary table usage.

Does it support different database engines?

While it focuses on standard SQL performance patterns, it is highly effective for PostgreSQL, MySQL, and similar relational databases.

How does the skill analyze my queries?

It processes your SQL query and its EXPLAIN plan to map out execution steps and identify high-cost operations like full table scans.

Can it suggest specific indexes?

Yes, the skill identifies columns that would benefit from indexing based on your filtering and join conditions.

Query Performance Analyzer

Name: Query Performance Analyzer
Author: intent-solutions-io

byintent-solutions-io

0•

データベース管理

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

The Query Performance Analyzer skill transforms Claude into a database performance expert capable of diagnosing slow-running SQL queries. By processing EXPLAIN plans and execution metrics, the skill identifies critical issues like full table scans, missing indexes, and inefficient join operations. It provides actionable recommendations for query rewriting and schema adjustments, helping developers reduce resource utilization and improve application responsiveness without needing manual database profiling expertise.

主な機能

01Identification of missing database indexes

02Resource utilization and execution speed improvement suggestions

03EXPLAIN plan interpretation and analysis

04Actionable SQL query optimization recommendations

050 GitHub stars

06Detection of inefficient join algorithms and table scans

ユースケース

01Reviewing new SQL queries for performance before deployment

02Diagnosing and fixing slow-running production database queries

03Identifying indexing opportunities to reduce CPU and I/O load

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add intent-solutions-io/plugins-nixtla query-performance-analyzer

For use in Claude.ai and ChatGPT

Download Skill