SQL Query Generator

Query setup

SQL dialect

Query type

Schema / databaseOptional.

Table name

Table alias

Keyword case

Pretty format Parameterized values Quote identifiers

Schema helper

Paste simple schemaUse one table name, followed by columns prefixed with -.

SELECT columns

DISTINCT Select *

JOIN builder

WHERE conditions

Advanced WHERE expressionAppended with AND. Useful for nested groups and subqueries.

Write limit

Maximum affected rowsGenerated only for MySQL and MariaDB UPDATE or DELETE statements.

Grouping, sorting, pagination

GROUP BY

HAVING

ORDER BY

Limit / TOP

Offset

Page numberUses limit as page size.

Advanced SELECT

CTE expression

UNION query

Union type

Window / CASE expression

INSERT values

Additional rowsPipe-separated values matching field order. One row per line.

UPDATE fields

CREATE TABLE columns

Table options

Foreign keys

ALTER TABLE

Action

Target / definition

Extra

CREATE INDEX

Index name

Columns

Unique index

Templates

Templates replace the current builder configuration.

Save current template

Saved templates

Configuration tools

Import config JSON

Editor options

Dark modeShortcuts: Ctrl/Cmd+Enter saves the current query to history. Ctrl/Cmd+Shift+C copies SQL.

SQL keyword reference

SELECTFROMWHEREJOINGROUP BYHAVINGORDER BYINSERTUPDATEDELETEWITHUNIONCASEOVER

How to use this calculator

Choose a database dialect and SQL statement type first. Enter the target table and optional schema name. Add columns joins conditions values or table definitions as needed. The SQL preview updates automatically while you edit fields. Enable parameterized mode when preparing safer application queries. Review warnings before using destructive SQL statements. Copy the result or download the generated SQL file.

Formula used

Query pattern: statement + target + selected fields + joins + conditions + grouping + sorting + pagination. Each visible builder section contributes its matching SQL clause. Database specific rules adjust quoting pagination and identity syntax automatically.

Example data

id	name	email	status
1	John	john@example.com	active
2	Sara	sara@example.com	inactive