SQL Formatter

1. 1Paste SQL into the input panel, or press Sample.
2. 2Choose the dialect of your database, then the keyword case and the indent. The result updates as you go.
3. 3Press Copy to copy the result, or Download to save it as a .sql file.

Dialect

Standard SQL (default), MySQL, MariaDB, PostgreSQL, SQLite, SQL Server (T-SQL), Oracle (PL/SQL), or BigQuery. The dialect decides which words are keywords and which quoting styles are accepted.

Keywords

UPPER (default) writes keywords such as SELECT in capitals, lower writes them in lowercase, and Keep leaves them as typed. Table and column names are not changed.

Indent

2 spaces (default), 4 spaces, or a tab.

Minify (one line)

Joins the formatted query into one line. A line break is kept after a -- comment, because everything after it on the same line would become part of the comment.

• Format a query (defaults: Standard SQL, UPPER, 2 spaces)

  Input

  select id, name from users where age > 20 order by name

  Output

  SELECT
    id,
    name
  FROM
    users
  WHERE
    age > 20
  ORDER BY
    name

• Lowercase keywords, 4 spaces

  Input

  select id, name from users where age > 20 order by name

  Output

  select
      id,
      name
  from
      users
  where
      age > 20
  order by
      name

• Minify (one line)

  Input

  select id, name from users where age > 20 order by name

  Output

  SELECT id, name FROM users WHERE age > 20 ORDER BY name

Examples use the reference cases this tool is tested against.

• JSON Formatter & ValidatorBeautify, minify, and validate JSON with exact error positionsUse it
• Text DiffCompare two texts and highlight what changedUse it
• Case ConverterConvert between camelCase, snake_case, and kebab-caseUse it