sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries.
What it does
- 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
Requirements & configuration
- Good: Fetch only what you need
Configuration: LIKE
Derived from the skill's own SKILL.md documentation · extracted 2026-07-23
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to eliminate slow queries.
Source
Repository: https://github.com/wshobson/agents
sql-optimization-patterns FAQ
What does the sql-optimization-patterns skill do?
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance. Debugging slow-running queries Designing performant database schemas
What does sql-optimization-patterns require?
Good: Fetch only what you need Configuration keys: LIKE.
How do I install sql-optimization-patterns?
Run: npx -y skills add https://github.com/wshobson/agents --skill sql-optimization-patterns --agent claude-code — the source lives at github.com/wshobson/agents.
Maintain sql-optimization-patterns?
Let people know it's listed here — add the badge (live metrics, light/dark aware) or a plain link to your README or docs.
[](https://getagentictools.com/skills/wshobson-agents-sql-optimization-patterns?ref=badge) npx agentictools info skills/wshobson-agents-sql-optimization-patterns The second line is the CLI lookup for this page — handy in READMEs and docs.
Related skills
database-migration Execute database migrations across ORMs with zero-downtime strategies and rollback procedures.
neon Agent skill from neondatabase/agent-skills.
rag-implementation Build knowledge-grounded LLM applications with vector databases, semantic search, and retrieval strategies.
flutter-working-with-databases SQLite and offline-first data layer architecture for Flutter apps with structured local persistence.
postgresql-table-design PostgreSQL schema design covering best practices, data types, indexing, constraints, and performance patterns.
prisma-compute Agent skill from prisma/skills.