SQL Formatter

Overview

• Formats hard-to-read single-line SQL, or SQL with inconsistent indentation, by uppercasing keywords and applying readable line breaks and indentation.
• Supports major SQL statements such as SELECT, INSERT, UPDATE, and DELETE, and can also format queries with complex JOINs or subqueries.
• Useful when you want to share SQL in a human-readable form during code review or while writing documentation.

Usage

1. Enter the SQL you want to format into the text area.
2. Click the "Format" button.
3. The result is displayed with keywords uppercased and readable line breaks and indentation.

Example

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

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

Use Cases

• Formatting a single-line SQL query output by logs or a tool into a readable form for review
• Unifying the indentation of SQL you wrote yourself to match your team's coding conventions
• Formatting a query with complex JOINs or subqueries to make its structure easier to grasp

FAQ

Notes

• Standard SQL syntax is supported (via the sql-formatter library). Database-specific dialect syntax may not format exactly as intended.
• No syntax validity check is performed. Even if the SQL contains errors, it may still be formatted as-is where possible.
• Formatting a very long SQL statement may make browser processing slow.