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

Database Management

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

About

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.

Key Features

Identification of missing database indexes
Resource utilization and execution speed improvement suggestions
EXPLAIN plan interpretation and analysis
Actionable SQL query optimization recommendations
0 GitHub stars
Detection of inefficient join algorithms and table scans

Use Cases

Reviewing new SQL queries for performance before deployment
Diagnosing and fixing slow-running production database queries
Identifying indexing opportunities to reduce CPU and I/O load

About

Key Features

Identification of missing database indexes
Resource utilization and execution speed improvement suggestions
EXPLAIN plan interpretation and analysis
Actionable SQL query optimization recommendations
0 GitHub stars
Detection of inefficient join algorithms and table scans

Use Cases

Reviewing new SQL queries for performance before deployment
Diagnosing and fixing slow-running production database queries
Identifying indexing opportunities to reduce CPU and I/O load