Skills
.Work. You
Rest

reviewing-sql-performance

Community

Tune SQL queries for faster, cheaper DB plans.

Data & Analytics#performance#indexing#sql#mysql#query-optimization#postgres#execution-plan
Authorsomachak
Version1.0.0
Installs0

System Documentation

What problem does it solve?

Slow SQL queries degrade API responsiveness, dashboards latency, and analytics throughput. This skill helps identify inefficient plans, missing indexes, and costly scans, enabling targeted rewrites and indexing strategies.

Core Features & Use Cases

  • Analyze EXPLAIN ANALYZE output to assess plan quality and identify sequential scans, high-cost operations, and poor join order.
  • Recommend indexing and query rewrites to reduce execution time and resource usage.
  • Suitable for API backends, data pipelines, reporting jobs, and analytics workloads experiencing latency or high CPU/disk I/O.

Quick Start

Run EXPLAIN ANALYZE on a slow query and apply the recommended indexing strategy.

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: reviewing-sql-performance
Download link: https://github.com/somachak/claude-code-skills-db/archive/main.zip#reviewing-sql-performance

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

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 471,000+ vetted skills library on demand.