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.

 

Published On: July 30, 2006Tags:

6 Comments

  1. Chris Meisenzahl August 28, 2006 at 11:45 pm - Reply

    Great post, this is useful, thanks!

  2. Yuri August 28, 2006 at 11:45 pm - Reply

    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 August 28, 2006 at 11:45 pm - Reply

    Hi,

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

    Website is http://sqleonardo.altervista.org

    Regards,
    nickyb

  4. Mark T August 28, 2006 at 11:46 pm - Reply

    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 August 28, 2006 at 11:47 pm - Reply

    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.

  6. PAscal February 23, 2015 at 6:30 am - Reply

    SQLeonardo has been dicontinued too.

    SQLeo (started begining 2012) is the new project. website is http://sqleo.sourceforge.net/index.html

    Regards
    PAscal

Leave A Comment