Can it help with complex multi-table joins?

Yes, it specifically analyzes join logic to suggest more efficient join orders and identify where indexes can best assist in reducing table scans.

Which database engines does this skill support?

The SQL Query Optimizer provides general SQL optimization principles and patterns applicable to most major engines including PostgreSQL, MySQL, SQL Server, and SQLite.

Is an EXPLAIN plan required for analysis?

While not strictly required, providing the output of an EXPLAIN statement allows the skill to provide much more accurate and effective performance recommendations.

Does the skill automatically apply changes to my database?

No, it generates optimized code and index recommendations. You should review and test these suggestions in a staging environment before manually applying them.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: BbgnsurfTech

byBbgnsurfTech

•

Database Management

Analyzes and optimizes SQL queries to improve performance by identifying bottlenecks and suggesting efficient indexing strategies.

The SQL Query Optimizer skill empowers developers and database administrators to enhance database efficiency by providing actionable recommendations for query performance. It meticulously reviews SQL structure, evaluates execution plans, and identifies missing or suboptimal indexes to significantly reduce latency and resource consumption. Whether you are troubleshooting a specific slow-running query or proactively tuning a production database, this skill helps transform complex, inefficient SQL statements into high-performance code ready for scaling.

Key Features

01Identifies performance bottlenecks within SQL statements

02Proposes optimized query rewrites to reduce execution time

03Analyzes database execution plans (EXPLAIN output) for deep insights

04Optimizes complex JOIN operations and filter clauses

05Provides specific recommendations for single and composite indexes

061 GitHub stars

Use Cases

01Identifying missing indexes to speed up application data retrieval

02Troubleshooting and fixing slow-running queries in production

03Refactoring legacy SQL code for better readability and performance

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add bbgnsurftech/claude-skills-collection sql-query-optimizer

For use in Claude.ai and ChatGPT

Download Skill