What is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc...)

tags:

linux
sql

views:

2005

answers:

+3 Q:

What is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc...)

Hello All, As I make the full switch from Windows to Linux (CentOS 5) I'm in search of the best free GUI SQL Client tool for MSSQL, MySQL, Oracle, etc... any suggestions?

I've tried DBVisualizer (The best bet so far but still limited by the free version, not all functionality is there), MySQL GUI Tools (Good but only for MySQL, need other DB's as well) and Aqua Data Studio (Same as DBVis, it's good but a lot of the functionality is missing in the free version).

Thanks, --Phill

I don't use gui, but I would install phpmyadmin.

Cross-platform.
GNU license

Macarse 2009-06-16 14:10:31

Phill Pafford 2009-06-16 15:58:47

+1 A:

For Oracle, I highly recommend the free Oracle SQL Developer

http://www.oracle.com/technology/products/database/sql_developer/index.html

The doucmentation states it also works with non-oracle databases - i've never tried that feature myself, but I do know that it works really well with Oracle

Chi 2009-06-16 14:12:01

I find the auto-complete on Oracle SQL Developer a bit spastic, but all in all it's a good product.

quillbreaker 2009-06-16 14:27:32

Phill Pafford 2009-06-16 16:01:45

+2 A:

I can highly recommend Squirrel SQL.

Also see this similar question:

Developer tools to directly access databases

sleske 2009-06-16 14:16:25

Phill Pafford 2009-06-16 16:03:12

Squirrel SQL has some graphing capabilities, you can open multiple query windows to work concurrently, and it supports just about any database (I use it on Oracle, MySQL, PostgreSQL and Informix). Yes, you can add any JDBC driver (unless it's buggy). Haven't used triggers, but apparently this is also possible.

sleske 2009-06-16 23:19:07

SQuirreL looks to have a steep learning curve for using the GUI and Configuring all the Drivers. Stumbling through this any thoughts/suggestions?

Phill Pafford 2009-06-17 14:50:42

I don't quite understand where your problem is :-). Yes, you need to set up the drivers, but that's about it. There's a tutorial on Squirrel's homepage. If you have more trouble, consider making it a new question, here or on serverfault.com.

sleske 2009-06-17 16:00:34

Not really a big fan of SquirrelSQL, looks dated and a pain in the ars to use, thanks but I will pass on this one.

Phill Pafford 2009-06-29 15:20:16

Hm, would be interesting to know where you found Squirrel SQL lacking (and why it's "dated"). Maybe you could explain a bit?

sleske 2009-06-29 15:51:31

Sticking with DBVisulizer till something better comes along

Phill Pafford 2009-07-20 17:25:27

ansaurus

tags:

views:

answers:

What is the best free SQL GUI for Linux (MSSQL, MySQL, Oracle, Etc...)

related questions