SQL query builder

Visually build a SELECT statement with columns, WHERE conditions, sorting and a limit, then copy the generated SQL.

Table

Columns (comma separated, or *)

WHERE conditions

Field

Operator

Value

Order by

Direction

Limit

SELECT id, name, email
FROM users
WHERE status = 'active'
ORDER BY created_at DESC
LIMIT 50;

Frequently asked questions

Does this run against a real database?

No, this only generates the SQL text for you to copy and run in your own database tool.

Related tools

See all 28 free developers tools

Text Diff Checker

Compare two texts and see exactly what was added or removed.

Use Text Diff Checker

Markdown Previewer

Write Markdown and see a live rendered preview side by side.

Use Markdown Previewer

Markdown to HTML

Convert Markdown source into raw HTML markup to copy anywhere.

Use Markdown to HTML

HTML to Markdown

Convert HTML markup into clean Markdown source.

Use HTML to Markdown

SQL query builder

Visually build a SELECT statement with columns, WHERE conditions, sorting and a limit, then copy the generated SQL.

Table

Columns (comma separated, or *)

WHERE conditions

Field

Operator

Value

Order by

Direction

Limit

SELECT id, name, email
FROM users
WHERE status = 'active'
ORDER BY created_at DESC
LIMIT 50;

Frequently asked questions

Does this run against a real database?

No, this only generates the SQL text for you to copy and run in your own database tool.

Related tools

See all 28 free developers tools

Text Diff Checker

Compare two texts and see exactly what was added or removed.

Use Text Diff Checker

Markdown Previewer

Write Markdown and see a live rendered preview side by side.

Use Markdown Previewer

Markdown to HTML

Convert Markdown source into raw HTML markup to copy anywhere.

Use Markdown to HTML

HTML to Markdown

Convert HTML markup into clean Markdown source.

Use HTML to Markdown