SQL Query Builder

Generate SELECT, INSERT, UPDATE and DELETE statements without remembering the syntax.

● Your files are processed locally in your browser and are not uploaded to our servers.

How it works

Fill in the table, columns and conditions; the SQL updates as you type. Identifiers are quoted for your dialect (`backticks`, "double quotes" or [brackets]), numbers are left as-is and strings are quoted with single quotes properly escaped. UPDATE and DELETE without a WHERE clause trigger a warning.

FAQ

Should I paste user input into these queries?

Not in application code — use parameterized queries there. This builder is for writing queries by hand.