Our online MySQL formatter is designed as a simpler showcase of the more advanced formatting capabilities available in dbForge Studio for MySQL, our high-end IDE that covers the absolute majority of common database development, management, and administration tasks. Here is a brief list of its formatting capabilities.
The online formatter above showcases just a tiny part of the much more expansive capabilities that you'll find in dbForge Studio for MySQL. And when it's time to write and beautify your code on a regular basis, what is it that awaits you in the Studio? Well, to find it out, all you need to do is open a new SQL document via New SQL on the Studio's toolbar and start writing your query. After you do that, it will take just a couple of clicks to format your entire query or a selected part of it. All the available settings, including the highly customizable formatting profiles, are conveniently handled in Tools > Options. You can even automate code formatting from the command line.
Besides formatting, there is quite a lot that dbForge Studio can offer to augment your daily SQL coding.
You can drastically increase the speed and accuracy of your SQL coding with the Studio's integrated code completion capabilities. All of them, taken together, will make your routine coding a breeze and a fast one at that.
Another highly useful tool is the built-in MySQL syntax checker, which easily spots syntax mistakes and helps you validate queries on the fly.
The checker scans your code as you type; whenever a possible mistake is detected, the checker highlights it with a red squiggly underline so you can fix it immediately.
That said, all you need to do is keep writing your code with nothing to worry about. The syntax checker will always help you keep an eye on every possible mistake or typo.
You can easily view object information in an object definition tooltip. Just point to the schema object in your script and the said tooltip will pop up.
Another option worth mentioning is Go to Definition, which provides you with even more detailed information about tables, views, procedures, functions, and events.
