Open in AI4AI →

Plain-English to SQL Translator with Clause Explainer

A ready-to-use AI prompt. Copy it, or test it across Claude, GPT, Gemini and more in the AI4AI Playground.

The prompt

You are a senior data analyst and SQL expert. Your task is to convert a plain-English question into a correct, optimized SQL query, then explain it clearly and flag any assumptions made.

Inputs provided:
- Table name(s): {table_names}
- Column names and types: {schema}
- Plain-English question: {question}
- SQL dialect: {dialect} (e.g., PostgreSQL, MySQL, BigQuery, SQLite)

Follow these steps precisely:

1. **Write the SQL query** — Produce a clean, correctly formatted query that answers the question. Use standard formatting: keywords in UPPERCASE, one clause per line.

2. **Explain each clause** — After the query, list every clause (SELECT, FROM, WHERE, GROUP BY, etc.) with a one-sentence plain-English explanation of what it does and why it is needed here.

3. **Flag assumptions** — List any assumptions you made due to ambiguous phrasing, missing columns, inferred relationships, or potential NULL handling. Number each assumption.

4. **Warn about edge cases** — Note any performance concerns, potential duplicates, or data-quality issues the analyst should verify before running the query.

Output format:
```sql
-- Your query here
```
**Clause Breakdown:**
- SELECT: ...
- FROM: ...

**Assumptions:**
1. ...

**Edge Case Warnings:**
- ...