FreeQueryBuilder - a better SQL tool

Frequently moving between companies means that I sometimes find myself jumping from using Toad one week to Microsoft Query (yuck!) the next.

Now that I have had the chance to use it on a couple of different projects, I think that FreeQueryBuilder is a pretty good replacement for most of the SQL tools that I have had to use; and it certainly saves the effort of learning a new interface every time I move projects.

The best part of it is that it is shipped as a jar file, so you don’t have to install anything to use it - allowing you to bypass the week-long delay you are likely to experience at large companies waiting for the desktop support team to install software you need to do your job with.

FreeQueryBuilder/SQLeonado screenshot

Off the top of my head, the other things that make it a neat tool are:

  • It works with all the popular databases
  • Shows relationships between tables
  • Makes it easy to search through the data dictionary for table or field names
  • Allows you to write queries by clicking buttons instead of typing, but gives you a text editor option too

Give it a go!

Update: The FreeQueryBuilder project has been discontinued. The software is now known as SQLeonado, and has some additional features.

[Slashdot] [Digg] [Reddit] [del.icio.us] [Facebook] [Technorati] [Google] [StumbleUpon]

5 Responses to “FreeQueryBuilder - a better SQL tool”

  1. Chris Meisenzahl Says:

    Great post, this is useful, thanks!

  2. Yuri Says:

    Does FreeQueryBuilder support MS SQL Server?

    MS SQL Server is not listed as supported datrabase on http://sourceforge.net/projects/querybuilder/:

    “FreeQueryBuilder a java tool that allow you to create SQL queries without directly writing SQL. Works with any JDBC compliant database (ORACLE,MySQL,HSQLDB,Firebird). ”

    Yury

  3. nickyb Says:

    Hi,

    What do you think about SQLeonardo (it’s an evolution of FreeQueryBuilder) ?

    Website is http://sqleonardo.altervista.org

    Regards,
    nickyb

  4. Mark T Says:

    This was a great idea, I agree. But according to the SF Website, this project is no longer active. The succeeding project is SQLeonardo.

  5. Stuart Moncrieff Says:

    It’s funny that the day after I decide to write about a piece of software, the project stops being developed. :)

    Yury, FreeQueryBuilder should support MS SQL. SQLeonado (the new version of this software) will also support MS SQL.

    NickyB, it’s great to receive a comment from the creator of a piece of software I have enjoyed using. SQLeonado looks like it has a few more features than FreeQueryBuilder. I will update my post to point to the new software.

    Cheers,
    Stuart.

Leave a Reply