Does it provide guidance on index types?

Yes, it covers general B-tree indexes as well as database-specific types like PostgreSQL GIN/GiST and SQL Server Clustered/Non-clustered indexes.

Can it help fix N+1 query problems?

Yes, it identifies common anti-patterns like N+1 and provides implementation patterns for rewriting them into efficient JOINs or Common Table Expressions (CTEs).

How does this skill help with slow queries?

It guides you through interpreting execution plans (EXPLAIN), identifying performance red flags like sequential scans, and recommending specific index additions or query rewrites.

Which databases are supported by this skill?

This skill provides specialized optimization strategies and syntax for PostgreSQL, MySQL, and SQL Server.

What are SARGable queries?

SARGable (Search ARGumentable) queries are written in a way that allows the database engine to use an index effectively, which this skill helps you achieve by avoiding functions on indexed columns.

SQL Performance Optimizer

Name: SQL Performance Optimizer
Author: ancoleman

byancoleman

•

158

•

データベース管理

Optimizes SQL query performance across PostgreSQL, MySQL, and SQL Server through execution plan analysis and strategic indexing.

This skill provides comprehensive tactical guidance for identifying and resolving database bottlenecks within Claude Code. It enables developers to analyze complex execution plans, implement efficient indexing strategies—including composite and partial indexes—and refactor inefficient query patterns like N+1 queries or non-sargable functions. By leveraging database-specific optimizations for PostgreSQL, MySQL, and SQL Server, this skill ensures high-performance data access layers and significantly reduced server latency for AI-assisted development.

主な機能

01Database-specific performance tuning for GIN, B-tree, and Clustered indexes

02Strategic index selection and composite index design patterns

03SARGable query rewriting to maximize index utilization and reduce scan times

04158 GitHub stars

05Execution plan analysis for PostgreSQL, MySQL, and SQL Server

06Identification and refactoring of query anti-patterns like N+1 and SELECT *

ユースケース

01Debugging slow API endpoints caused by inefficient or unindexed database queries

02Designing optimal index structures for new schemas during the development phase

03Refactoring legacy SQL queries to improve application scalability and resource usage

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add ancoleman/ai-design-components optimizing-sql

For use in Claude.ai and ChatGPT

Download Skill