SQL Optimization skill: what it does and how to install it
Optimises SQL queries across MySQL, PostgreSQL, SQL Server and Oracle with execution-plan analysis, indexing and performance tuning guidance.
Summary generated from the skill's documentation.
Install
$ npx skills add github/awesome-copilot --skill sql-optimizationRun 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 slow SQL through query structure and execution plans, then suggests rewrites, indexes, pagination and batch operations. It covers joins, subqueries, aggregations, filtering and monitoring, with examples for MySQL, PostgreSQL, SQL Server and Oracle.
When to use it. For tuning queries, designing indexes, investigating database bottlenecks and setting up performance checks. It emphasises testing changes with realistic data volumes and query patterns.
History
Repo stars
40k+229 since 5 Oct 2026
Stars are counted for the whole repository, which holds 30 skills.
Show as a table
| Date | Repo stars |
|---|---|
| 12 Oct 2026 | 39,948 |
| 11 Oct 2026 | 39,904 |
| 10 Oct 2026 | 39,881 |
| 9 Oct 2026 | 39,845 |
| 8 Oct 2026 | 39,804 |
| 7 Oct 2026 | 39,761 |
| 6 Oct 2026 | 39,731 |
| 5 Oct 2026 | 39,719 |
Installs
15.1k
Tracking since . A chart appears once there are 7 days of data.
Installs via skills.sh
Similar skills
- SQL ProOptimizes SQL queries and database schemas across PostgreSQL, MySQL, SQL Server and Oracle using execution plans, indexes and set-based patterns.
- SQL Optimization PatternsOptimises SQL queries with execution plans, indexing strategies and database maintenance techniques to reduce latency and load.
- PostgreSQL OptimizationOptimises PostgreSQL queries and schemas using advanced data types, indexes, extensions and database performance monitoring.