Generate SQL from plain English

Describe the query you want, get working SQL and an explanation.

Ssara.buildsIntermediate⏱ ≈2h/weekChatGPT
385 views
Your free community read · unlock the rest with membershipUnlock all →

I know what data I need, I just do not want to hand-write every join. This closes the gap.

Generate SQL from plain English

The workflow

  1. Describe your tables and the question
  2. Ask ChatGPT for the SQL plus a one line explanation
  3. Run it on a read replica first
  4. Save the good ones as snippets

Result: Correct SQL for most day-to-day questions, with the reasoning shown.

The prompt

Here is my schema: [PASTE]. Write a SQL query that answers: [QUESTION]. Explain the joins in one line and flag any assumption.
ForEngineering

Want to share your own workflows?

AI Academy members publish workflows, vote, and get featured in Techpresso.

Become a member

Discussion

Loading…