SQL Formatter
Add predictable whitespace and line breaks around common SQL clauses while preserving quoted strings and comments. Select a lexical profile for vendor-specific quoting; formatting does not validate SQL.
Format SQL Lexically
Dialect-Sensitive Token Handling
| Profile | Additional lexical handling |
|---|---|
| Portable | Single-quoted strings, double-quoted identifiers, standard comments |
| PostgreSQL | Dollar-quoted strings |
| MySQL | Backtick identifiers, # comments, backslash traversal in quoted text |
| SQLite | Backtick and bracketed identifiers |
Formatting Is Not Parsing Or Validation
The formatter recognizes strings, quoted identifiers, comments, words, numbers, operators, punctuation, and common clause keywords. It then applies deterministic line breaks without executing the query.
Vendor grammar, procedural blocks, custom operators, and unusual extensions may require a dedicated formatter. Successful output does not prove syntax, safety, performance, permissions, parameterization, or portability.
Review Before Running A Query
- Use parameterized queries for untrusted values.
- Check the chosen database dialect and server version.
- Review transaction boundaries, data-changing statements, and query plans independently.
Questions About This Tool
No. It performs lexical formatting and does not parse a complete vendor grammar or execute the statement.
Quoting and comment syntax differ. The selected profile helps the tokenizer preserve those constructs without claiming full dialect coverage.
No. Injection prevention depends on parameterization, trusted APIs, validation, permissions, and application design.