| name | sql-query-starter |
| description | Draft a basic SQL query from a simple requirement. Use when a junior developer needs help forming SELECT queries. |
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.