What does the SQL Formatter and Minifier do?
Use this tool when you need a browser utility that formats SQL for review or removes optional whitespace for compact transport. It accepts SQL for Standard SQL, MySQL, PostgreSQL, SQLite, SQL Server, or BigQuery and returns formatted or compact SQL text. Results are deterministic for the same input except where cryptographic randomness, current time, or a live provider response is part of the task.
Format for review; minify for compact transport
Formatted SQL emphasizes clauses and indentation for human review. Minified SQL is shorter but harder to audit, and comment removal can discard optimizer hints in dialects that encode hints as comments.
How do you use it?
- Choose Format SQL or Minify SQL and select the database dialect that matches the query.
- Paste SQL into Input and select Convert.
- Review the output against the target database; formatting does not execute or validate the query.
Worked example
Minify a simple query
Input
SELECT id, name
FROM users
WHERE active = true;Output
SELECT id,name FROM users WHERE active=true;Minify removes comments and optional whitespace; it does not change identifiers or verify semantics.
Common errors and fixes
| Symptom | Likely cause | Fix |
|---|---|---|
| Formatting fails near a vendor-specific clause. | The selected dialect does not recognize syntax used by the query. | Choose the matching MySQL, PostgreSQL, SQLite, SQL Server, BigQuery, or Standard SQL dialect. |
| Formatted SQL still fails in the database. | A formatter does not know the schema, permissions, parameter values, or runtime types. | Run the query through the database parser or a safe test environment after formatting. |
Important behavior of SQL Formatter
Formatting does not validate database schema, permissions, or query semantics.
Standards and implementation references
- sql-formatter official repository (opens in a new tab)Documents the supported dialects and formatter behavior used by this page.
Frequently asked questions about SQL Formatter
Does the SQL Formatter upload my input?
No. Processing runs in the current browser tab, and the page does not send tool input to a KitLumi processing endpoint.
What input does the SQL Formatter accept?
It accepts SQL for Standard SQL, MySQL, PostgreSQL, SQLite, SQL Server, or BigQuery. The workspace checks the input and reports malformed or unsupported values before it produces a result.
What does the SQL Formatter produce?
It produces formatted or compact SQL text. Copy and download controls appear when the output format supports them.
What limitation should I know?
Formatting does not validate database schema, permissions, or query semantics.
What changed?
Added Multiple SQL dialects, Keyword casing, Two-space formatting, SQL minification, responsive controls, explicit runtime disclosure, and tested browser output.