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

•

数据库管理

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

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.

主要功能

01Automated identification of SQL performance bottlenecks

02Intelligent index recommendations based on query filters

03884 GitHub stars

04Execution plan analysis and interpretation

05SQL query rewriting for optimized execution logic

06Support for optimizing complex JOIN and filtering operations

使用场景

01Refactoring legacy SQL code for improved performance and readability

02Designing efficient indexing strategies for new application schemas

03Accelerating 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