SQL formatting, compression, syntax checking tool
As a SQL Formatter, formats SQL for readability while preserving database-specific quotes and comments.
SQL input and conversion
Supports SQL and . file selection and drop.
Input SQL
Processing results
syntax error
Errors and Warnings
Processing results
You can check the number of sentences, comments, parameters and input/output size of SQL.
- SQL statement
- 0
- Comments
- 0
- 0
- Maximum braces depth
- 0
- Input Line
- 0
- Output Line
- 0
- Input
- 0 B
- Output size
- 0 B
About this tool
It does not execute SQL and forms it according to the depth of the phrase and parentheses while string, comment, and quotation identifiers.
Features
- ANSI SQL, Oracle, PostgreSQL, MySQL／MariaDB, SQL Server, SQLite
- Checking simple syntax for formatting, single-line compression, parentheses, quotes, and comments
- Keyword capitalization, comma placement, AND/OR line breaks, and indentation
- PostgreSQL Dollar Quotes, Or Alternative Quotes, Back Quart, Square Curly Identifier
- Line number, syntax color, copy, SQL file storage
How to use
- SQL or open the . file.
- Set database, indent, reserved words, commas, etc.
- Performs either formatting, compression, and syntax checks.
- Copy or save the result as SQL file as needed.
Limitations
- We do not execute SQL, verify the validity of table name, column name, and data type without connecting to the database.
- Stored procedure, proprietary extension, and complex dynamic SQL require visualization of the formatting result.
- Simple syntax checks are not equivalent to DB engines.
- In very large SQL, syntax color classification is omitted, but formatting and validation continue.
Privacy: Input and results are processed in your browser and are neither sent to nor stored on the Develop Tools server.