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.

主要功能

01Detects missing indexes on frequently filtered or joined columns

02Analyzes and interprets SQL EXPLAIN execution plans

03Suggests optimal single-column and composite indexes

04Identifies performance bottlenecks in complex SQL queries

05Provides efficient query rewrites to reduce execution overhead

06884 GitHub stars

使用场景

01Designing indexing strategies for new database schemas and tables

02Accelerating slow-running queries in production or development environments

03Refactoring legacy SQL code for improved database efficiency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills skill-adapter

For use in Claude.ai and ChatGPT

Download Skill