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.
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.
6 Comments
Comments are closed.
Great post, this is useful, thanks!
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
Hi,
What do you think about SQLeonardo (it’s an evolution of FreeQueryBuilder) ?
Website is http://sqleonardo.altervista.org
Regards,
nickyb
This was a great idea, I agree. But according to the SF Website, this project is no longer active. The succeeding project is SQLeonardo.
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.
SQLeonardo has been dicontinued too.
SQLeo (started begining 2012) is the new project. website is http://sqleo.sourceforge.net/index.html
Regards
PAscal