Sql
🧿 Minimal but effective AI agent skill definitions in 100 lines or less.
npx -y skills add kimtth/agent-skill-100-lines-or-less --skill sqlAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
2 things to look at
- no licenseNo license file was found in the repository. Code published without one is not open source by default, so using it at work is a question for whoever answers licensing questions where you are.
- 2 stars2 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: write or review correct, set-based SQL with safe parameters and sensible indexing.
SKILL.md
1.0 KB, 205 tokens by cl100k_base, as published. Nobody here has run it
Goal: correct, readable SQL that the planner can execute efficiently.
Use for:
- writing queries, joins, and aggregations
- reviewing query correctness and parameter safety
- replacing row-by-row logic with set-based queries
Workflow:
- Express intent as a set operation, not a loop.
- Parameterize all values; never concatenate input.
- Select only the columns you need.
- Join on indexed keys; understand the join type you want.
- Filter early; push predicates into subqueries/CTEs sensibly.
- Verify correctness on edge cases and read the query plan.
Patterns:
- explicit JOIN ... ON over comma joins
- CTEs for readability of multi-step queries
- window functions for ranking and running totals
- GROUP BY with the right aggregates and HAVING
Rules:
- always parameterize; SQL injection is unacceptable
- avoid SELECT *; name your columns
- know whether NULLs change your results
- check the plan before optimizing by guess
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.