Draft a basic SQL query from a simple requirement. Use when a junior developer needs help forming SELECT queries.
Install
npx skillscat add proflead/codex-skills-library/sql-query-starter Install via the SkillsCat registry.
SKILL.md
SQL Query Starter
Purpose
Draft a basic SQL query from a simple requirement.
Inputs to request
- Table names and relationships.
- Desired fields and filters.
- Database flavor and limits.
Workflow
- Clarify tables, filters, and desired fields.
- Build a minimal SELECT with WHERE and ORDER BY.
- Add optional LIMIT and parameter placeholders.
Output
- SQL query with parameters.
Quality bar
- Use parameters instead of literal values.
- Keep the query minimal and readable.