SQL Query Formatter

SQL query formatter standardizes SQL statements to a predictable style, reducing time spent on manual formatting. It is used by developers, DBAs, data engineers, and data analysts who review, refactor, or share queries across repositories. The tool emphasizes consistent indentation, uppercase keywords, aligned SELECT lists, and safe wrapping of long lines, improving readability and reducing misinterpretation during code reviews. It handles clauses such as SELECT, FROM, WHERE, GROUP BY, ORDER BY, and joins, while preserving comments and string literals, including nested subqueries and CTEs. It can format single statements or multi-statement inputs, returning a clean, standard output suitable for reviews and documentation.
Core logic & features: The formatter parses SQL into a structured representation and applies style rules to produce readable output. Required features include dialect-aware formatting, correct whitespace around operators, and preservation of comments and literals. Optional features include configurable indentation (spaces or tabs), wrap margins, keyword casing (uppercase or mixed), and a compact mode. It processes multi-statement inputs by formatting each statement independently and preserving semicolon boundaries; per-project profiles enable consistent team-wide standards.
Inputs & outputs: Input: sql_text (string, required), dialect (ANSI, PostgreSQL, MySQL, T-SQL, Oracle, optional), options (indent_size, wrap_columns, keyword_case). Output: formatted_sql (string), diagnostics (list of strings). Diagnostics report ambiguous patterns or syntax hints; the tool returns the final SQL with uniform layout and optional diagnostics for integration into CI, editors, and documentation workflows.