How do I trigger the SQL optimization?

You can trigger the skill by asking Claude to 'optimize SQL', 'improve performance', or by mentioning a 'slow query' while providing your code.

How does this skill help with slow queries?

It analyzes the SQL structure and execution patterns to suggest specific optimizations like better indexing, early filtering, and query restructuring to reduce load.

Can it handle complex analytical queries?

Yes, it specializes in transforming heavy subqueries into efficient window functions and optimizing large JOIN operations for data analysis.

Does it support multiple database types?

The optimization patterns provided are generally applicable across major SQL dialects including PostgreSQL, MySQL, and SQL Server.

SQL Query Optimizer

Name: SQL Query Optimizer
Author: takemi-ohama

bytakemi-ohama

0•

Database Management

Optimizes SQL query performance by applying proven patterns like index strategies, JOIN restructuring, and window function implementations.

The SQL Query Optimizer skill empowers Claude to function as a senior data analyst, identifying bottlenecks in database queries and providing actionable improvements. It offers a comprehensive library of optimization patterns, ranging from eliminating N+1 query issues to replacing complex subqueries with efficient window functions. By analyzing execution plans and applying best practices like early filtering and selective indexing, this skill helps developers and analysts significantly reduce query latency and improve overall database scalability.

Key Features

01N+1 query detection and elimination patterns

02JOIN vs. subquery performance restructuring

03Advanced window function patterns for complex aggregations

040 GitHub stars

05Query rewriting for improved execution (e.g., EXISTS vs. IN)

06Index optimization strategies and EXPLAIN plan analysis

Use Cases

01Refactoring legacy SQL code to follow modern performance best practices

02Identifying and fixing slow-running reports or analytical queries

03Analyzing database execution plans to pinpoint and resolve bottlenecks

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add takemi-ohama/ai-plugins data-analyst-sql-optimization

For use in Claude.ai and ChatGPT

Download Skill