sql-optimization-patterns
Master SQL performance tuning through EXPLAIN plan analysis, advanced indexing strategies, and optimization patterns.
Install
npx skills add https://github.com/wshobson/agents --skill sql-optimization-patternsStats
| Total installs | 7,652 |
| Weekly installs | 7.6K |
| GitHub stars | 32.4K |
| First seen | Jan 20, 2026 |
| Source | @wshobson/agents |
Summary
- Covers EXPLAIN plan analysis with key metrics (Seq Scan, Index Scan, cost, rows, execution time) and five index types (B-Tree, Hash, GIN, GiST, BRIN) for different query patterns
- Includes five core optimization patterns: eliminating N+1 queries, cursor-based pagination, efficient aggregation, subquery transformation, and batch operations
- Provides advanced techniques like materialized views, table partitioning, and query hints for large-scale performance tuning
- Includes monitoring queries to identify slow queries, missing indexes, and unused indexes in PostgreSQL
Tags
Related skills
| Skill | Installs | vs sql-optimization-patterns |
|---|---|---|
| power-bi-model-design-review | 7,432 | -220 |
| snowflake-semanticview | 7,572 | -80 |
| convex-create-component | 8,537 | +885 |
| power-bi-performance-troubleshooting | 7,437 | -215 |
| convex-performance-audit | 8,445 | +793 |
FAQ
- How many installs does sql-optimization-patterns have?
- sql-optimization-patterns has 7,652 total installs and 7.6K installs this week.
- Where is sql-optimization-patterns hosted?
- sql-optimization-patterns is published by @wshobson/agents at https://github.com/wshobson/agents.
- How many GitHub stars does sql-optimization-patterns have?
- sql-optimization-patterns has 32.4K GitHub stars.
- When was sql-optimization-patterns first indexed?
- OrangeBot.AI first indexed sql-optimization-patterns on Jan 20, 2026.
- How do I install sql-optimization-patterns?
- Run: npx skills add https://github.com/wshobson/agents --skill sql-optimization-patterns