Can it help me fix slow JOIN operations?

Yes, it analyzes JOIN structures to identify cross-joins, missing indexes on join keys, and instances where subqueries can be refactored into more efficient joins.

Does it provide the actual optimized code?

Absolutely. The skill provides a full rewrite of the SQL query along with the necessary CREATE INDEX statements to implement the performance improvements.

Which database engines are supported by this skill?

The skill supports all ANSI SQL standard databases, with specialized optimization logic for PostgreSQL, MySQL, SQL Server, SQLite, and Oracle.

What kind of performance analysis does it perform?

It mimics an execution plan analysis, looking for high-cost operations like full table scans and explaining exactly why the current query structure is causing a bottleneck.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: organvm-iv-taxis

byorganvm-iv-taxis

•

Database Management

Transforms slow and inefficient SQL queries into high-performance database code through advanced analysis and strategic refactoring.

This skill empowers Claude to act as a Senior Database Administrator, specializing in diagnosing and resolving performance bottlenecks within complex SQL queries. It identifies common anti-patterns—such as non-sargable predicates, implicit type conversions, and inefficient joins—providing optimized code rewrites along with specific indexing strategies and schema refactoring suggestions. It is an essential tool for developers looking to reduce database latency, minimize resource consumption, and ensure application scalability across major platforms including PostgreSQL, MySQL, and SQL Server.

Key Features

01Detailed execution plan analysis and bottleneck explanation

022 GitHub stars

03Automated SQL anti-pattern detection and resolution

04Database-specific indexing strategy recommendations (B-Tree, GIN, GiST)

05Query refactoring using CTEs and optimized set-based logic

06Comparative performance estimation and complexity mapping

Use Cases

01Optimizing slow-running production queries to reduce server load

02Refactoring legacy SQL code to modern, performant standards

03Designing efficient indexing strategies for high-traffic database schemas

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add organvm-iv-taxis/a-i--skills sql-query-optimizer

For use in Claude.ai and ChatGPT

Download Skill