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

データベース管理

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.

主な機能

Window function implementation for complex data aggregation
Query execution plan (EXPLAIN) interpretation and optimization
Strategic index recommendation and efficiency analysis
N+1 query detection and consolidation patterns
0 GitHub stars
Advanced JOIN vs. subquery performance tuning

ユースケース

Refactoring slow-running analytical queries to reduce execution time
Identifying and fixing performance bottlenecks in legacy database code
Reducing cloud database costs by optimizing scan bytes and resource usage

概要

主な機能

Window function implementation for complex data aggregation
Query execution plan (EXPLAIN) interpretation and optimization
Strategic index recommendation and efficiency analysis
N+1 query detection and consolidation patterns
0 GitHub stars
Advanced JOIN vs. subquery performance tuning

ユースケース

Refactoring slow-running analytical queries to reduce execution time
Identifying and fixing performance bottlenecks in legacy database code
Reducing cloud database costs by optimizing scan bytes and resource usage