Can it help with complex multi-table joins?

Yes, the skill is specifically designed to analyze join logic and suggest better join orders or indexing strategies for complex queries.

How does the SQL Query Optimizer identify bottlenecks?

The skill analyzes the query's logical structure, join conditions, and filter clauses to determine how a database engine likely processes the request.

Should I provide the EXPLAIN output?

While not mandatory, providing the output of the EXPLAIN command allows the skill to give much more precise and effective performance recommendations.

Is it safe to apply the suggested changes immediately?

We recommend testing all suggested indexes and query rewrites in a staging or development environment before applying them to a production database.

Does this skill work with all SQL databases?

Yes, it provides general optimization principles applicable to relational databases like PostgreSQL, MySQL, SQL Server, and SQLite.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: jeremylongshore

byjeremylongshore

•

884

データベース管理

Optimizes SQL queries by identifying performance bottlenecks and providing actionable recommendations for indexing and query rewrites.

概要

The SQL Query Optimizer skill empowers Claude to act as an automated database performance engineer. By analyzing the structure of SQL queries and interpreting execution plans, the skill identifies inefficiencies that lead to slow response times. It provides specific recommendations for creating optimal indexes, proposes more efficient query rewrites, and helps developers resolve database performance issues during the development lifecycle, ensuring applications remain scalable and responsive.

主な機能

Detects missing indexes on frequently filtered or joined columns
Analyzes and interprets SQL EXPLAIN execution plans
Suggests optimal single-column and composite indexes
Identifies performance bottlenecks in complex SQL queries
Provides efficient query rewrites to reduce execution overhead
884 GitHub stars

ユースケース

Designing indexing strategies for new database schemas and tables
Accelerating slow-running queries in production or development environments
Refactoring legacy SQL code for improved database efficiency

概要

主な機能

Detects missing indexes on frequently filtered or joined columns
Analyzes and interprets SQL EXPLAIN execution plans
Suggests optimal single-column and composite indexes
Identifies performance bottlenecks in complex SQL queries
Provides efficient query rewrites to reduce execution overhead
884 GitHub stars

ユースケース

Designing indexing strategies for new database schemas and tables
Accelerating slow-running queries in production or development environments
Refactoring legacy SQL code for improved database efficiency