How to use the SQL Query Builder
1. Enter the table name and the columns you want to SELECT. Use * for all columns.
2. Add WHERE conditions using the + button — choose field, operator, and value.
3. Optionally set ORDER BY and LIMIT. The SQL query is generated live.
What is it?
The SQL Query Builder generates SELECT statements visually without requiring you to remember syntax. Add as many columns and WHERE conditions as you need, then copy the finished query.
Supported operators include equality, comparison, LIKE for pattern matching, IN for lists, BETWEEN for ranges, and NULL checks. Values are automatically quoted or left numeric based on their content.
Benefits
Generate INSERT and CREATE TABLE statements instantly
Convert JSON, CSV, or a field list into ready-to-run SQL in seconds — no manual quoting, no counting columns, no copy-paste errors from spreadsheet data.
Build SELECT queries without memorising syntax
The visual query builder constructs WHERE conditions, ORDER BY, LIMIT, and DISTINCT clauses interactively — useful for anyone who writes SQL occasionally rather than daily.
Migrate between MongoDB and relational databases
Convert MongoDB find, insert, update, and delete operations directly to SQL equivalents — speed up data migration planning or schema exploration.
All your data stays in the browser
No SQL query, schema definition, or database content is ever uploaded to a server. Everything runs entirely client-side, making these tools safe to use with sensitive data.
Frequently asked questions
Can I build INSERT, UPDATE, or DELETE queries?
This tool focuses on SELECT. Use the dedicated SQL Update Generator and SQL Delete Generator for those statement types.
How do I use the IN operator?
Enter comma-separated values in the value field, e.g. 1,2,3 or Alice,Bob. The tool wraps them correctly.