Thursday, November 4, 2010

SQL Beautifier Eclipse Plugin

I created an eclipse plugin that will give you the ability to beautify SQL statements (give some formatting to the SQL to make it easier on the eye).

To install. Download the http://userpages.umbc.edu/~kirkley1/sqlformatter_1.0.0.201011042037.jar jar file and copy it into your 'plugins' folder of your eclipse install.

After copying, load up eclipse. You can find the sql formatter view if you goto Window|Show View then expand the SQL Formatter category folder and select "SQLFormatterView". Paste the unformatted SQL statement in the top text box and hit the 'Format' button. The 'pretty' sql should display in the bottom text box.

Enjoy!
Posted by at

7 comments:

  1. Artem KarnaukhJune 7, 2012 at 3:13 AM

    Nice plugin! Thank you

    ReplyDelete
  2. UnknownJuly 3, 2012 at 9:18 AM

    Use it quite a bit myself!

    ReplyDelete
  3. UnknownJanuary 15, 2014 at 3:25 PM

    Thanks. Do you share the source code?

    ReplyDelete
  4. Matthew KirkleyJune 6, 2014 at 3:59 PM

    @Marcelo, wish I could but I have long since lost it unfortunately. Sorry about that

    ReplyDelete
  5. UnknownFebruary 25, 2019 at 6:49 AM

    The link is unfortunately no longer containing the file.

    ReplyDelete
  6. JDFebruary 21, 2020 at 11:13 AM

    Tried in IntelliJ and gVim, didn't work in either. Can you patch this with an update pls?

    ReplyDelete

Subscribe to: Post Comments (Atom)