---
title: "SQL Optimization Patterns - Air Market"
description: "A page in your app is slow, and it turns out the database is the reason. This helps you look at what the database is actually doing with your query, work out which indexes would help, and lay out you…"
canonical: "https://airmarket.ai/app/sql-optimization-patterns"
---

[Air Market](/) / [Data & Analytics](/category/data) / SQL Optimization Patterns

Skill by [Seth Hobson](/@wshobson)

# SQL Optimization Patterns

Turn the query everyone waits on into one nobody notices

## What this does

A page in your app is slow, and it turns out the database is the reason. This helps you look at what the database is actually doing with your query, work out which indexes would help, and lay out your tables so the problem does not come back. Reach for it when something is slow and the database is where you suspect the time is going.

### Top 3 things it does for you

- Track down why a query is slow
- Decide which indexes are worth adding
- Read a query plan and know what to change

## Information

**SQL Optimization Patterns at a glance**

|  |  |
| --- | --- |
| Kind | Skill |
| Publisher | [Seth Hobson](/@wshobson) |
| Category | [Data & Analytics](/category/data) |
| Works with | Agent Skills - an open standard supported by 40+ agents |
| Size | 13 KB |
| Licence | MIT |
| Repository | [wshobson/agents](https://github.com/wshobson/agents/tree/be57c0b2e3c05c528ca6132b87410b385718775f/plugins/developer-essentials/skills/sql-optimization-patterns) |
| GitHub stars | 39,077 (as of Nov 2026) |
| Installs | 20,486, counted by skills.sh (Nov 2026) |

## Security report

**Verified.** AIR scanned this exact version of SQL Optimization Patterns and flagged nothing. AIR's verdict: **safe**.

**What SQL Optimization Patterns's check was run against**

|  |  |
| --- | --- |
| Commit | be57c0b2e3c05c528ca6132b87410b385718775f |
| Content hash | cc84a9ae0e40a2fab348c1778c1c9bb59cfbb0c38ed5121924b58edad2e467a2 |
| Files read | [Browse the files at this exact commit](https://github.com/wshobson/agents/blob/be57c0b2e3c05c528ca6132b87410b385718775f/plugins/developer-essentials/skills/sql-optimization-patterns/SKILL.md) |

A scan is named by the exact content it read, not by a version number. A different version is a different artifact, and nothing here applies to a version AIR has not scanned.

[Read the full security report for SQL Optimization Patterns](/security/sql-optimization-patterns)

## About SQL Optimization Patterns

This is about SQL query optimization: indexing strategies, and reading EXPLAIN output to understand what the database is doing with your query.

Use it when you are debugging slow queries, when you are designing database schemas, or when database time is what is holding your application back.

## What's inside

- SKILL.md - instructions
- references/details.md - reference

## Questions

### Is SQL Optimization Patterns safe to install?

AIR scanned this exact version of SQL Optimization Patterns and flagged nothing. AIR's verdict: safe. The verdict is named by the content that was read, at commit be57c0b2e3c0, so it cannot drift onto a version nobody scanned. The full report is at https://airmarket.ai/security/sql-optimization-patterns.

### How do I install SQL Optimization Patterns?

Open https://airmarket.ai/app/sql-optimization-patterns on Air Market and use the install action: Air Market hands Claude a prompt naming this exact skill, and Claude sets it up. Source, pinned to the exact commit this listing describes: https://github.com/wshobson/agents/tree/be57c0b2e3c05c528ca6132b87410b385718775f/plugins/developer-essentials/skills/sql-optimization-patterns. Install from that link, not the branch.

## Related on Air Market

- [More Data & Analytics listings](/category/data)
- [Everything by Seth Hobson](/@wshobson)

---

Canonical URL: <https://airmarket.ai/app/sql-optimization-patterns>