SQL Formatter for MySQL

Your data never leaves your browser

Format MySQL queries with backtick identifiers and GROUP_CONCAT.

Example

SELECT `u`.`name`, GROUP_CONCAT(DISTINCT `r`.`name`) as roles FROM `users` `u` JOIN `user_roles` `ur` ON `u`.`id` = `ur`.`user_id` WHERE `u`.`active` = 1 LIMIT 50;

Try Sql Formatter Now

Tips

1Select MySQL for backticks.
2LIMIT without OFFSET.
3Consistent backtick quoting.

Frequently Asked Questions

Backticks?

Yes. Select MySQL dialect.

Stored procs?

Query formats. Bodies: basic support.

Safe?

Yes. Browser only.