home / Data Analysis / SQL Optimization Patterns Skill by @sickn33

SQL Optimization Patterns Skill by @sickn33

FREE

github stars★ 48,690updatedSep 2026repo@sickn33

activity (commits, last 6 months)

6mo ago0

this month0

$git clone https://github.com/sickn33/agentic-awesome-skills

The skill is the skills/sql-optimization-patterns folder inside that repository. Copy it into the folder your agent loads skills from; check your agent's documentation for where that is.

about SQL Optimization Patterns Skill by @sickn33

Diagnose slow SQL with query plans, preserve query results, and verify indexing or query changes against representative data.

our take

Diagnoses slow SQL using query plans, preserves query results while changing queries and verifies indexing or query changes against representative data.

when to use it

A query is slow and you need to know why
You are deciding whether an index will help
You want to check a rewrite returns the same results

before you install

Test against realistic data volumes, since plans change with table size
Review index changes on production systems carefully, as they affect writes

what's inside

The original SKILL.md is organised into these sections:

Use this skill when
Do not use this skill when
Instructions
Resources
Limitations
Worked example

source and license

Written and maintained by @sickn33. It is published under the MIT license, which allows reuse with attribution. SkillDirectory does not claim authorship: this page adds our own review and links back to the original, and the skill's text belongs to its author.

View the full SKILL.md on GitHub ↗

Read the opening of the original SKILL.md

# SQL Optimization Patterns

Diagnose slow SQL with query plans, preserve query results, and verify indexing or query changes against representative data.

## Use this skill when

- Debugging slow-running queries
- Designing performant database schemas
- Optimizing application response times
- Reducing database load and costs
- Improving scalability for growing datasets
- Analyzing EXPLAIN query plans
- Implementing efficient indexes
- Resolving N+1 query problems

## Do not use this skill when

- The task is unrelated to sql optimization patterns
- You need a different domain or tool outside this scope

## Instructions

- Confirm database engine/version, query parameters, expected rows, data distribution and the permitted environment. Start read-only; obtain authorization before DDL, data changes, configuration changes or maintenance.
…

Excerpt only, quoted from the author's repository. Open the repository for the complete file.

↓ download .zip