Online SQL Generator
Generate SQL fast from a simple JSON spec: SELECT, INSERT, UPDATE, DELETE. Supports MySQL, PostgreSQL, SQL Server, SQLite. Client-side, no uploads.
How to use
Describe the query in JSON, then generate SQL.
- Choose a query type and SQL dialect (or keep Auto and specify them in JSON).
- Paste JSON into the input (examples are included).
- Click Generate SQL, then copy the result.
JSON keys: type (select/insert/update/delete), table, columns, where, raw_where, joins, order_by, limit, offset, set, values, quote_identifiers, use_params.
FAQ
What input format does this SQL generator use?
A simple JSON object describing the query (type, table, columns, where, values, etc.). The tool parses it locally and outputs SQL.
Does this run server-side or client-side?
Client-side only. Your JSON and generated SQL stay in your browser.
How do I add WHERE conditions?
Use where as an object (e.g., {"id":5}) or use operators like {"age":{">=":18}}. For custom SQL, use raw_where.
Can it generate parameterized SQL instead of literals?
Yes—enable Use placeholders (or set use_params:true) to output parameter markers appropriate for the dialect.
How does LIMIT work across dialects?
MySQL/PostgreSQL/SQLite use LIMIT. SQL Server uses TOP (n) (and supports OFFSET/FETCH when an ORDER BY is present).
Will it generate UPDATE/DELETE without a WHERE clause?
No. The tool blocks UPDATE/DELETE without where or raw_where to reduce accidental full-table operations.
Can I quote identifiers like column names and table names?
Yes—enable Quote identifiers to quote names using the dialect style (backticks, double quotes, or brackets).
Continue your workflow
Browse related tools by task. Use the improved core tools for a consistent workspace with file import, downloads and clear validation errors.