SQL Query Generator
Build one statement for PostgreSQL or SQLite using quoted identifiers and scalar values. Review the draft before use.
Up to 30 fields, 63 characters per identifier and 1,000 characters per string. JSON numbers must be finite and within the safe numeric range. Strings use doubled apostrophes; SQL NULL uses JSON null.
Ready to draft a query.
One table, one WHERE predicate and one optional order column. No joins, grouping, schema inspection or SQL execution. Quoted identifiers preserve case. Other database dialects need manual adaptation.
Everything stays in this browser. No database connection, upload or storage.
A QUICK WALKTHROUGH
How to use this tool
- Choose an operation and table.
- Enter columns or a JSON object of field values, then set a WHERE condition.
- Generate and review the SQL; UPDATE and DELETE require a WHERE condition.
SQL draft
One table, one WHERE predicate and one optional order column. No joins, grouping, schema inspection or SQL execution. Quoted identifiers preserve case. Other database dialects need manual adaptation.
INSERT / UPDATE values (JSON object)
Up to 30 fields, 63 characters per identifier and 1,000 characters per string. JSON numbers must be finite and within the safe numeric range. Strings use doubled apostrophes; SQL NULL uses JSON null.
GOOD TO KNOW
Common questions
Can this execute a query?
Everything stays in this browser. No database connection, upload or storage.