SQL Formatter & Beautifier

Format, indent, and beautify complex SQL queries in your browser.

MODE

DIALECT

KEYWORD CASE

INDENT

SQL Input Query

Formatted SQL

$ cat tips.txt

sql-formatter

How to Use

1Paste messy or minified SQL query into the editor
2Choose SQL dialect and keyword casing (UPPERCASE / lowercase)
3Copy formatted query or download formatted SQL script

Stats

Lines

—

Dialect

sql

Tips

•UPPERCASE keywords make complex JOINs and subqueries much easier to read
•Formatting queries before code reviews helps spot missing WHERE clauses
•Supports standard SQL, PostgreSQL, MySQL, and SQLite dialects

Example

Input

select id,name from users where active=1 and role='admin'

Output

SELECT id, name FROM users WHERE active = 1 AND role = 'admin';

$ cat tips.txt

sql-formatter

How to Use

1Paste messy or minified SQL query into the editor
2Choose SQL dialect and keyword casing (UPPERCASE / lowercase)
3Copy formatted query or download formatted SQL script

Stats

Lines

—

Dialect

sql

Tips

•UPPERCASE keywords make complex JOINs and subqueries much easier to read
•Formatting queries before code reviews helps spot missing WHERE clauses
•Supports standard SQL, PostgreSQL, MySQL, and SQLite dialects

Example

Input

select id,name from users where active=1 and role='admin'

Output

SELECT id, name FROM users WHERE active = 1 AND role = 'admin';

$ megatools --free --fast --private ▊

No data leaves your browser.

About Us·Privacy Policy·Terms of Service

Support the project

BTCbc1q3aej7x9wlvl54syt4qm48xcdn6zqa64cm6dwj6

ETH0xae69f5bcf7762bb5fe34d3832fd7d1954054674b

SOL6Et2XmHSdAD4QBR9Apdt9AVeJ77ktr1piV49q7RD4SLk