SQL Query Builder
Build SQL SELECT and INSERT statements without writing them by hand: add WHERE conditions, sorting and limits on the SELECT tab, or enter column values on the INSERT tab. The live preview updates as you type.
WHERE conditions
Columns and values
Text values are quoted automatically. Leave the quotes off.
Live SQL preview
-- enter a table name to build a query
SQL copied to clipboard.
Frequently asked questions
It helps you build SELECT and INSERT statements visually: type a table name, choose columns, add WHERE conditions, ORDER BY and LIMIT, and it generates the SQL for you.
On the SELECT tab, click Add condition, then type the column, pick an operator such as = or LIKE, and type the value. You can add as many conditions as you need.
Yes, single quotes inside string values are escaped automatically so the generated SQL stays valid.
Yes, the builder is completely free to use online with no signup.