Can it help with complex JOIN operations?

Absolutely. The skill specifically targets complex queries involving multiple joins, subqueries, and filters to reduce latency and server resource consumption.

Should I apply recommendations directly to production?

It is always recommended to test suggested optimizations, especially index creations, in a staging environment to verify performance gains before applying them to production.

Does it support different types of SQL databases?

Yes, the skill is designed to handle standard SQL syntax and can provide optimizations for most major relational database systems including PostgreSQL, MySQL, and SQL Server.

How does the SQL Query Optimizer work?

It analyzes the structure of your SQL queries and provided execution plans to identify inefficiencies and suggest specific improvements like new indexes or structural query rewrites.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: jeremylongshore

byjeremylongshore

•

884

Database Management

Optimizes SQL queries and database performance by identifying bottlenecks, suggesting indexes, and rewriting complex queries.

About

This skill empowers Claude to act as a database performance engineer, analyzing SQL queries to identify structural inefficiencies and execution bottlenecks. By reviewing query logic and execution plans, it provides actionable recommendations for optimal index creation and proposes query rewrites to streamline data retrieval. It is an essential tool for developers needing to scale database-driven applications, troubleshoot slow-running production queries, or implement efficient indexing strategies.

Key Features

Automated identification of SQL performance bottlenecks
Intelligent index recommendations based on query filters
884 GitHub stars
Execution plan analysis and interpretation
SQL query rewriting for optimized execution logic
Support for optimizing complex JOIN and filtering operations

Use Cases

Refactoring legacy SQL code for improved performance and readability
Designing efficient indexing strategies for new application schemas
Accelerating slow-running queries in production databases

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add jeremylongshore/claude-code-plugins-plus-skills sql-query-optimizer

For use in Claude.ai and ChatGPT

Download Skill

GitHub