SQL Query Builder

Visually construct SELECT queries — joins, filters, aggregations, ordering — and get live syntax-highlighted SQL in your chosen dialect.

Dialect

Raw mode

Table name

Alias

DISTINCT

Return only unique rows

LIMIT

OFFSET

Generated SQL

Tip: toggle Raw mode to hand-edit SQL, then click Format to beautify.

The SQL Query Builder lets you construct SELECT queries visually — no SQL knowledge required. Configure your primary table, add JOINs with custom conditions, build WHERE filters with operators like LIKE, BETWEEN, and IN, then apply GROUP BY, HAVING, and ORDER BY clauses.

The live preview updates as you type, with full syntax highlighting via Prism. Switch between MySQL, PostgreSQL, SQLite, and SQL Server — identifier quoting (backticks, double-quotes, square brackets) adjusts automatically. Use Raw mode to hand-edit SQL and the Format button to beautify any query.

SQL Query Builder

Table

Columns1

Joins

Where

Group By

Having

Order / Limit

SQL Query Builder

Table

Columns1

Joins

Where

Group By

Having

Order / Limit