SQL Formatter

How to use SQL Formatter

1. Paste your SQL query into the SQL Input area.
2. Select the SQL dialect used by your query.
3. Choose whether SQL keywords should use uppercase or lowercase.
4. Select the indentation width.
5. Click Format SQL to format the query.
6. Use Copy to copy the formatted SQL.

What is SQL formatting?

SQL formatting is the process of adding consistent indentation, line breaks and spacing to SQL statements. Proper formatting makes queries easier to read, understand, review and maintain without changing the intended SQL structure.

Supported SQL dialects

Keyword case

You can choose how SQL keywords are displayed after formatting. Uppercase formatting uses keywords such as SELECT and WHERE, while lowercase formatting uses select and where.

Indentation options

The formatter supports 2, 4 or 8 spaces for indentation. Choosing a consistent indentation width can make nested queries, subqueries and SQL expressions easier to read.

Why format SQL queries?

• Make long SQL queries easier to read
• Improve code review and maintenance
• Understand joins, conditions and nested queries
• Clean up compressed SQL copied from applications
• Keep SQL formatting consistent across projects
• Make database queries easier to troubleshoot

Does formatting change the SQL query?

The purpose of formatting is to improve the presentation of the SQL by adding structure, spacing and indentation. Always review formatted SQL before running it in a production database, especially when working with complex or dialect-specific queries.

Is my SQL uploaded to a server?

The formatting operation is performed in the browser using the SQL formatting library. The tool does not require sending your SQL query to a backend server.