SQL Formatter

How it works

Formatting uses sql-formatter: each clause (SELECT, FROM, WHERE, GROUP BY) starts a line and its items are indented. Pick the dialect so its specific syntax parses: :: casts and $1 parameters in PostgreSQL, backtick identifiers in MySQL, TOP and [brackets] in SQL Server.

The formatter only changes whitespace and keyword case, never the query’s meaning. If it reports an error, the query probably uses syntax from another dialect.

References

• sql-formatter supported dialects