Developer Tools / SQL Query Generator
Guide
How to use the SQL Query Generator
- 1
Describe the question.
- 2
Paste your schema for accurate column names.
- 3
Run it on a test database first.
Expert tip
What you should know
Always filter as early as possible, select only the columns you need and check the execution plan for large tables. Window functions are usually clearer and faster than self-joins for rankings and running totals.
FAQ
Frequently asked questions
Is my schema stored?+
No. It is used for this request only.
You might also like
More Developer Tools tools →Regex Generator & Explainer
Describe the pattern in words; get a tested regular expression.
JSON Formatter & Validator
Pretty-print, minify and validate JSON in your browser.
Code Explainer
Paste code; get a plain-English walkthrough of what it does.
Code Debugger
Paste the error and the code; get the cause and a fix.
Cron Expression Generator
Describe a schedule; get the cron expression and next run times.
Base64 Encode / Decode
Encode text to Base64 or decode it back, UTF-8 safe.
URL Encode / Decode
Percent-encode text for URLs, or decode it back.
UUID Generator
Random v4 UUIDs, one or a thousand.