MySQL Formatter
Use this free online MySQL Formatter to format MySQL queries and stored procedures. It works instantly in your browser, and your data never leaves your device.
About the MySQL Formatter
Unformatted SQL is hard to review, especially long joins and subqueries. This mysql formatter uses a dialect aware parser for MySQL syntax, puts each clause on its own line, indents subqueries and lets you choose keyword case and indentation.
Also known as: mysql beautifier, format mysql query.
How to use the MySQL Formatter
- Paste your input into the box above, upload a file, or click Sample to try an example.
- Pick any options you need. The MySQL Formatter processes your input instantly as you type.
- Click Copy to copy the output or Download to save it as a file.
Features
- Free with no signup and no daily limits
- Private: runs entirely in your browser
- Works on mobile, tablet and desktop
- Upload files and download results
- Live results as you type, with clear error messages
- Clean, fast interface with no popups
Frequently asked questions
Is the MySQL Formatter free to use?
Yes. The MySQL Formatter is completely free with no signup, no limits on normal use and no watermark.
Is my data safe?
Yes. Everything is processed by JavaScript inside your own browser. Your text is never uploaded to our server or stored anywhere.
Which SQL dialects are supported?
Standard SQL, MySQL, MariaDB, PostgreSQL, SQL Server (T-SQL), Oracle PL/SQL, SQLite, BigQuery, Snowflake, Redshift, Spark SQL and DB2.
Does formatting change my query?
No. Only whitespace, line breaks and optionally keyword case change. The logic of the query stays exactly the same.
What else is this tool called?
People also search for it as mysql beautifier, format mysql query. It is the same free tool.