Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →dokhacgiakhoa/sql-optimization-patterns
Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries.
Passed 8 of 23 test cases with the skill, and 15 of 23 without it.
1 fixed16 passed either way4 still failing2 broke
Tokens, turns and time describe resource use, not a dollar price.
A test case the skill fixed. Same model, same prompt, with and without the skill.
An analytics dashboard displays total row count for an events table containing 200 million rows using 'SELECT COUNT(*) FROM events;'. The query takes 12 seconds and locks resources. The team wants an instant estimate for display. How should this be handled?
| Checked | Without skill | With skill |
|---|---|---|
| Recommends reading system catalog metadata statistics for approximate row counts. | Passed | Passed |
| Explains that exact COUNT(*) requires scanning all rows or index pages in MVCC database engines. | Missed | Passed |
The instructions your model reads when the skill loads.
Transform slow database queries into lightning-fast operations through systematic optimization, proper indexing, and query plan analysis.
resources/implementation-playbook.md.resources/implementation-playbook.md for detailed patterns and examples.test cases passed, vs 15 / 23 without
Published skills whose descriptions closely match this one, with their headline benchmark lift.
More skills from the same source and nearby in the registry, with their headline benchmark lift.