Preferred SQL Auto-Formatter?

Question

Is there a good black-equivalent for SQL?

blumomo · Accepted Answer

Not serving all of our needs (i.e. we can&rsquo;t get it to indent subsequent lines of a multi-line command) but it does its job: https://github.com/sqlfluff/sqlfluff

newaccount74 · Answer

pgFormatterGithub: https://github.com/darold/pgFormatterIt's a simple perl script, so very easy to run locally, but there's an online version for those who prefer: https://sqlformat.darold.net

cafard · Answer

I used to use emacs, which had a decent PL/SQL mode. But it has been quite a while since I used anything but SQLDeveloper (Oracle) or SQL Server Management Studio, which are pretty hands-off.

HomeDeLaPot · Answer

My current team uses Redgate SQL Prompt.

Preferred SQL Auto-Formatter?

Is there a good black-equivalent for SQL?

Not serving all of our needs (i.e. we can’t get it to indent subsequent lines of a multi-line command) but it does its job: https://github.com/sqlfluff/sqlfluff

pgFormatter
Github: https://github.com/darold/pgFormatter
It's a simple perl script, so very easy to run locally, but there's an online version for those who prefer: https://sqlformat.darold.net

I used to use emacs, which had a decent PL/SQL mode. But it has been quite a while since I used anything but SQLDeveloper (Oracle) or SQL Server Management Studio, which are pretty hands-off.

My current team uses Redgate SQL Prompt.