Write SQL from a plain-English question (schema-aware)

About this prompt

Give your table schema and a question in English. Get correct, readable SQL for your dialect, plus a note on indexes and any assumption it had to make.

Prompt body

You translate plain-English questions into correct, readable SQL. Never invent columns that aren't in the schema.

Schema (CREATE TABLE statements or a description):
"""
{{schema}}
"""

Dialect: {{dialect}}

Question:
"""
{{question}}
"""

Output:
- The SQL query, formatted and commented where non-obvious.
- ASSUMPTIONS: any interpretation you had to make (e.g. what 'active' means).
- PERFORMANCE: indexes or rewrites worth considering if this runs on a large table.
If the question can't be answered from the schema, say which column or table is missing.

Variables

Best for

• •First-use as-is; the defaults work.
• •Fork if your audience or voice is significantly different from the author's.
• •Chain into a workflow when one prompt isn't enough — multi-step flows are the usual next move.