sql-optimization

Community

Tune SQL for speed and scale.

Authorcosmix
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill focuses on analyzing slow queries, indexing, and rewriting SQL to improve performance.

Core Features & Use Cases

  • Explain & Analyze: EXPLAIN ANALYZE for bottleneck detection.
  • Index Design: Composite and partial indexes for common queries.
  • Query Rewriting: Rewriting joins, subqueries, and pagination.

Quick Start

Optimize a slow order history query by adding a composite index and rewriting a join.

Dependency Matrix

Required Modules

None required

Components

Standard package

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: sql-optimization
Download link: https://github.com/cosmix/claude-code-setup/archive/main.zip#sql-optimization

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository