SQL Optimization Patterns skill: what it does and how to install it
Optimises SQL queries with execution plans, indexing strategies and database maintenance techniques to reduce latency and load.
Summary generated from the skill's documentation.
Install
$ npx skills add wshobson/agents --skill sql-optimization-patternsRun it in a terminal. If your agent is already running, start a new session so it picks the skill up.
About this skill
What it does. Analyses EXPLAIN output, query structure and index usage to identify full scans, inefficient joins and other bottlenecks. It covers PostgreSQL indexes, query rewrites, statistics, vacuuming, monitoring and common performance pitfalls.
When to use it. For debugging slow queries, designing performant schemas, reducing database load, addressing N+1 queries or improving scalability. It focuses on SQL and database performance optimisation.
History
Repo stars
40.5k+245 since 5 Oct 2026
Stars are counted for the whole repository, which holds 26 skills.
Show as a table
| Date | Repo stars |
|---|---|
| 12 Oct 2026 | 40,457 |
| 11 Oct 2026 | 40,368 |
| 10 Oct 2026 | 40,319 |
| 9 Oct 2026 | 40,307 |
| 8 Oct 2026 | 40,296 |
| 7 Oct 2026 | 40,267 |
| 6 Oct 2026 | 40,238 |
| 5 Oct 2026 | 40,212 |
Installs
19.2k
Tracking since . A chart appears once there are 7 days of data.
Installs via skills.sh
Similar skills
- SQL OptimizationOptimises SQL queries across MySQL, PostgreSQL, SQL Server and Oracle with execution-plan analysis, indexing and performance tuning guidance.
- SQL ProOptimizes SQL queries and database schemas across PostgreSQL, MySQL, SQL Server and Oracle using execution plans, indexes and set-based patterns.
- PostgreSQL OptimizationOptimises PostgreSQL queries and schemas using advanced data types, indexes, extensions and database performance monitoring.