SQL Formatter

Key concepts

The SQL formatter is a readability tool, not a parser that understands every dialect. It uppercases common keywords and wraps lines before clauses. Targets include select, conditions, joins, grouping, ordering, limits, insert/update/delete, and aggregate names. It also wraps before logical keywords such as AND and OR so long WHERE clauses read vertically. Formatting a one-line query from a log saves review time. Consecutive spaces are first collapsed to one, then keywords are found and lines split, so uneven drafts become easier to read.

It does not check syntax, bind variables, or explain plans. A word inside a string literal that matches a keyword may be uppercased, so important scripts are safer in a dedicated formatter or editor plugin. This SQL formatter does not send queries to a server; it only substitutes in the browser. It does not run against a database, so use it as read-only cleanup. Formatting empty input leaves the result empty; check that output is filled before copying.

Example

Paste select * from users where id=1; and press Format: SELECT becomes uppercase, FROM and WHERE start new lines, and the result reads vertically. A select list of comma-separated columns puts each name on the next line indented two spaces. Copy the result and paste it into a database client to run.

Related: JSON formatter · JS/CSS formatter · Cron generator