Skills
.Work. You
Rest

query-optimizer

Community

Optimize SQL queries for peak performance.

Software Engineering#performance#indexing#database#optimization#sql#query tuning
AuthorCuriousLearner
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This Skill addresses slow-performing SQL queries that lead to application slowdowns and increased infrastructure costs by analyzing and optimizing their execution plans.

Core Features & Use Cases

  • Performance Analysis: Identifies bottlenecks like full table scans, missing indexes, and inefficient joins using EXPLAIN and other tools.
  • Query Optimization: Provides actionable recommendations for index creation, query rewriting, and caching strategies.
  • Use Case: A web application's user dashboard is loading slowly. The @query-optimizer skill can analyze the SELECT statements responsible for fetching user data and suggest adding an index to the users table on the created_at column, significantly speeding up load times.

Quick Start

Use the query-optimizer skill to analyze the performance of the following SQL query: SELECT * FROM orders WHERE user_id = 123.

Dependency Matrix

Required Modules

None required

Components

references

💻 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: query-optimizer
Download link: https://github.com/CuriousLearner/devkit/archive/main.zip#query-optimizer

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 223,000+ vetted skills library on demand.