Representative example
This example reflects the implemented transformation or analysis.
Input
select id,name from users where active=true order by name;Output
SELECT
id,
name
FROM
users
WHERE
active = true
ORDER BY
name;SQL Formatter
Format SQL with uppercase keywords and two-space indentation for six selectable database dialects.
- Free public tool
- No sign-up for this tool
- Processing clearly labeled
- Instant results
Content last reviewed
Dialect affects quoting rules and dialect-specific keywords.
96 characters · 1 lines
Keywords are uppercased and clauses aligned at 2-space indent — the layout most style guides expect for review-ready queries.
Quick Start
Add input
Paste a SQL query and select the closest database dialect.
Choose options
Standard SQL, PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server.
Review the result
Check the output or diagnostics, then use the available copy or download control where shown.
Examples
Input and output example 1
Input
select id,name from users where active=true order by name;Output
SELECT
id,
name
FROM
users
WHERE
active = true
ORDER BY
name;About the SQL Formatter
SQL Formatter addresses a focused developer workflow without requiring a command-line setup. Format SQL with uppercase keywords and two-space indentation for six selectable database dialects. Results update from the supplied input, making it useful for quick inspection, debugging, documentation, or test preparation.
In this tool, SQL Formatter: processing runs in the browser and the tool does not call an external conversion API. Input remains in page memory unless a confirmed browser feature such as file reading or local settings is described above.
How to Use SQL Formatter
Paste a SQL query and select the closest database dialect.
Configure standard sql, postgresql, mysql, mariadb, sqlite, and sql server.
Review the generated output, status, or validation message.
Copy or download the result when that control is available, and verify it in the destination where it will be used.
Key Features
Focused processing
The
sql-formatterlibrary parses the selected dialect, uppercases recognized keywords, and lays out clauses with a two-space tab width.Input guidance
SQL text for the six listed dialects.
Immediate feedback
Incomplete or dialect-incompatible syntax can produce a formatting error.
When to Use SQL Formatter
Application development
Use SQL Formatter to prepare or inspect values while implementing a feature.
Fault isolation
Run a small known input through SQL Formatter to distinguish formatting or syntax problems from surrounding application behavior.
Reviewable examples
Create a concise select for tests, documentation, or code review.
How It Works
Processing flow
The sql-formatter library parses the selected dialect, uppercases recognized keywords, and lays out clauses with a two-space tab width.
Result handling
During processing, SQL Formatter: the result is rendered directly in the tool interface. Validation failures are displayed instead of being silently treated as successful output.
Supported Formats and Options
Formats
Accepted input
SQL text for the six listed dialects
Displayed output
SELECT
Options
Available controls
Standard SQL, PostgreSQL, MySQL, MariaDB, SQLite, and SQL Server
Common Errors and Troubleshooting
Common errors
Invalid or incomplete input
Incomplete or dialect-incompatible syntax can produce a formatting error.
Unexpected result
Confirm that the selected mode or syntax matches the source and that the input is complete.
Troubleshooting guide
Resolve the reported error
Incomplete or dialect-incompatible syntax can produce a formatting error. Reduce the input to the smallest failing case and confirm the selected controls.
Check an unexpected result
Review the documented limitation for SQL Formatter, then compare a known example with the same mode or syntax before processing a larger value.
Limitations and Important Notes
Formatting does not execute, validate against a database schema, or prove that a query is safe or correct.
Privacy and Data Processing
SQL Formatter performs its implemented transformation in the browser without calling an external processing API. Input is held in the current page state, so still avoid unnecessary secrets and clear the field on a shared device.
Tips and Best Practices
Practical tips
Keep the original sql text for the six listed dialects before using SQL Formatter.
Exercise the error case described as: Incomplete or dialect-incompatible syntax can produce a formatting error.
Check the result against this limitation: Formatting does not execute, validate against a database schema, or prove that a query is safe or correct.
Best practices
Prepare a representative input
Start with a small value whose expected result you understand, then add the edge cases relevant to SQL Formatter. Preserve the original when the conversion or formatting is destructive.
Verify in context
Formatting does not execute, validate against a database schema, or prove that a query is safe or correct. Treat the displayed result as an intermediate artifact and test it in the runtime, parser, database, or document where it will actually be used.
Technical Details
Implementation note: SQL Formatter: the sql-formatter library parses the selected dialect, uppercases recognized keywords, and lays out clauses with a two-space tab width.
Who Is This For?
Developers, QA engineers, technical writers, analysts, and students who need format SQL with uppercase keywords and two-space indentation for six selectable database dialects.
Frequently Asked Questions
Does SQL Formatter send input to an API?
No external processing API is used by this tool; its implemented operation runs in the browser.
What input is supported?
SQL text for the six listed dialects.
Why did the tool show an error?
Incomplete or dialect-incompatible syntax can produce a formatting error.
What should I verify before using the result?
Formatting does not execute, validate against a database schema, or prove that a query is safe or correct.