Can this skill identify N+1 query issues?

Yes, it specifically looks for patterns where queries are executed repeatedly in loops and provides refactored versions that consolidate requests into single, efficient queries.

How does this skill help with slow SQL queries?

It analyzes your SQL structure and execution plans to suggest specific optimizations such as adding selective indexes, rewriting inefficient JOINs, or applying window functions.

Will I see the difference before and after optimization?

Yes, the skill is designed to provide 'Before' and 'After' code examples along with predicted performance improvements based on execution plan metrics.

Does it support specific databases like BigQuery or MySQL?

While it follows universal SQL best practices, it includes specific optimizations for various dialects, including execution plan analysis for standard RDBMS and scan-byte reduction for BigQuery.

SQL Performance Optimizer

Name: SQL Performance Optimizer
Author: takemi-ohama

bytakemi-ohama

0•

Database Management

Optimizes SQL query performance by applying proven patterns for indexing, JOIN structures, and execution plan analysis.

The SQL Performance Optimizer skill enables Claude to diagnose and resolve database bottlenecks with expert-level precision. It leverages a comprehensive library of optimization strategies, including N+1 query elimination, strategic indexing, and advanced window function implementation. By guiding the agent through execution plan (EXPLAIN) analysis, this skill transforms slow, resource-heavy queries into efficient operations, making it an indispensable tool for data analysts and developers managing high-scale database environments.

Key Features

01Window function implementation for complex data aggregation

02Query execution plan (EXPLAIN) interpretation and optimization

03Strategic index recommendation and efficiency analysis

04N+1 query detection and consolidation patterns

050 GitHub stars

06Advanced JOIN vs. subquery performance tuning

Use Cases

01Refactoring slow-running analytical queries to reduce execution time

02Identifying and fixing performance bottlenecks in legacy database code

03Reducing cloud database costs by optimizing scan bytes and resource usage

What are Skills?·How to Install

Install with 🐟 Skill.Fish

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

For use in Claude.ai and ChatGPT

Download Skill