proflead

sql-query-starter

Draft a basic SQL query from a simple requirement. Use when a junior developer needs help forming SELECT queries.

proflead 106 22 Updated 4mo ago
GitHub

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

  1. Clarify tables, filters, and desired fields.
  2. Build a minimal SELECT with WHERE and ORDER BY.
  3. 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.