What kind of indexing advice does it provide?

It suggests specific CREATE INDEX statements, covering indexes, and specialized index types like GIN or GiST based on your query structure and database engine.

Does this skill require a direct connection to my database?

No, it analyzes the SQL code and execution plan data you provide to offer optimization insights without needing direct access to your infrastructure.

Can it help resolve N+1 query problems?

Yes, the skill is designed to identify N+1 patterns in application logic and suggest more efficient join-based or batching alternatives.

Which databases does this skill support?

The SQL Query Optimizer supports all major SQL engines including PostgreSQL, MySQL, SQL Server, and SQLite, defaulting to ANSI standards when the engine is unspecified.

SQL Query Optimizer

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

byorganvm-iv-taxis

•

Database Management

Optimizes complex SQL queries by analyzing execution plans, identifying bottlenecks, and suggesting high-performance indexing strategies.

The SQL Query Optimizer skill transforms Claude into a Senior Database Administrator capable of diagnosing and resolving performance bottlenecks in database queries. It identifies common anti-patterns such as non-sargable predicates, inefficient joins, and implicit type conversions, providing specific rewrite suggestions and recommending indexing strategies for engines like PostgreSQL, MySQL, and SQL Server. This skill is essential for developers looking to reduce database latency, improve application scalability, and transition from brute-force loops to efficient set-based operations.

Key Features

01Execution plan analysis to identify performance bottlenecks

022 GitHub stars

03Database-specific optimizations tailored for PostgreSQL, MySQL, and SQL Server

04Query refactoring for set-based logic and efficient CTE usage

05Specific indexing recommendations including B-Tree, GIN, and GiST indexes

06Detection of SQL anti-patterns like leading wildcards and non-sargable predicates

Use Cases

01Reducing server load by identifying and implementing missing covering indexes

02Accelerating slow-running analytical reports and complex data aggregations

03Modernizing legacy SQL code to adhere to performant, modern database standards

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