Sql optimize
Skill NSBen/skillfoundry/src/skillfoundry/data/starter_skills/sql-optimize
🔥 SkillFoundry (forge) — open, vendor-neutral toolchain for authoring, validating, testing & publishing AI agent skills. Works across Claude Code / Cursor / Codex / OpenCode / Cline. Ships 15 starter skills.
npx -y skills add NSBen/skillfoundry --skill sql-optimizeAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- 16 days oldThe repository was created 16 days ago. New is not bad, but a brand new repository carrying a familiar-sounding name is the shape a typosquat arrives in, and there has been no time for anyone else to find a problem with it.
- 1 stars1 stars. Stars are a popularity signal and not a quality one, but at this level it is likely that nobody has read this closely except its author, and you would be relying on your own review.
What its author says it does
Copied from the file, not written here
Use when a SQL query or migration is slow and you need to find the bottleneck and propose indexes or rewrites that make it fast.
The file declares its own license as MIT. That is the author’s claim about this one file, and it is not the same thing as the license GitHub reports for the repository, which is listed with the other numbers below.
SKILL.md
1.1 KB, 171 tokens by cl100k_base, as published. Nobody here has run it
SQL Optimize
When to use
Invoke this skill for slow queries, missing indexes, full table scans, or N+1 patterns in reports and APIs.
Steps
- Get the query plan (
EXPLAIN ANALYZE) and locate the most expensive node. - Check whether filters and joins use indexed columns.
- Propose covering indexes or a query rewrite (join order, CTEs, pagination).
- Flag N+1 loops that should become a single batched query.
- Give the before/after plan and the expected impact, with a migration.
Examples
- "Why is this JOIN so slow?"
- "Suggest indexes for this report query"
References
Always confirm with EXPLAIN on real data; an index that is never selective can hurt writes more than it helps reads.
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.