Loading skill
Install any skill in seconds. Free to start, no credit card required.
Get Started Free →ancoleman/optimizing-sql
Optimize SQL query performance through EXPLAIN analysis, indexing strategies, and query rewriting for PostgreSQL, MySQL, and SQL Server.
Passed 22 of 22 test cases with the skill, and 21 of 22 without it.
1 fixed21 passed either way0 still failing0 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.
Our REST API endpoint `/products/top` receives 5,000 requests per second. How should we configure Redis caching middleware in our application server layer to cache the HTTP response body for 60 seconds?
| Checked | Without skill | With skill |
|---|---|---|
| recommends setting a Redis key with a 60-second time-to-live expiration | Missed | Passed |
| describes checking Redis before processing the HTTP request | Passed | Passed |
The instructions your model reads when the skill loads.
Provide tactical guidance for optimizing SQL query performance across PostgreSQL, MySQL, and SQL Server through execution plan analysis, strategic indexing, and query rewriting.
Trigger this skill when encountering:
Run execution plan analysis to identify bottlenecks:
PostgreSQL:
EXPLAIN ANALYZE SELECT * FROM users WHERE email = '[email protected]';
MySQL:
EXPLAIN FORMAT=JSON SELECT * FROM products WHERE category_id = 5;
SQL Server: Use SQL Server Management Studio: Display Estimated Execution Plan (Ctrl+L)
Key Metrics to Monitor:
For detailed execution plan interpretation, see references/explain-guide.md.
test cases passed, vs 21 / 22 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.