SQL Formatter and Beautifier

About the SQL Formatter

Beautifies or minifies SQL queries and highlights syntax errors. It supports Standard SQL, MySQL, PostgreSQL and Transact-SQL (T-SQL), and can set keyword case (for example UPPERCASE).

How to use it

1. Paste your SQL query.
2. Choose the dialect: Standard SQL, MySQL, PostgreSQL or Transact-SQL.
3. Pick UPPERCASE or lowercase keywords and an indent of 2 or 4 spaces.
4. Click Format to beautify, or Minify to put the query on one line, then copy the result.

Good for

• Reading a long one-line query copied from logs
• Standardizing query style before a code review
• Spotting a missing comma or bracket

Tip: Pick the dialect that matches your database; functions and quoting rules differ between MySQL, PostgreSQL and SQL Server.

Frequently asked questions

Which SQL dialects are supported?

Standard SQL, MySQL, PostgreSQL and Transact-SQL (SQL Server).

Does minifying change my string values?

No. Text inside quotes is kept exactly as written, and -- comments are turned into /* */ comments so they cannot hide the rest of the query.

Does it run the query?

No. It only formats the text; nothing is sent to a database.

More free tools

• Test Data GeneratorCreate realistic fake records for testing, demos and database seeding, then export them as JSON, CSV, XML, HTML, SQL inserts, Python or JavaScript.
• Random Password and Key GeneratorGenerate strong random passwords and keys with your choice of length and character sets, using your browser’s cryptographically secure random number generator.
• CSV, TSV, JSON and XML ConverterConvert data between CSV, TSV, JSON, XML and a single column of values in any direction, with automatic format detection and file upload.
• JavaScript Minifier and ValidatorCompress JavaScript with Terser for a smaller file, or validate code and see syntax errors with their line numbers.
• JSON Formatter and ValidatorBeautify and validate JSON, find the exact line of an error, and convert JavaScript object literals into strict JSON.
• Diff Checker: Compare Two TextsCompare two blocks of text or two files and see what changed, line by line.
• Case ConverterChange text to UPPERCASE, lowercase or Title Case in one click.
• camelCase, PascalCase, snake_case and kebab-case ConverterTurn any phrase into programming naming styles as you type: camelCase, PascalCase, snake_case, kebab-case and Capitalized Case.
• YAML ValidatorCheck YAML files for syntax errors before they break a deployment, from Kubernetes manifests to GitHub Actions workflows.