What is the best free SQL GUI for Linux for various DBMS systems


Sql Problem Overview

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).

Sql Solutions

Solution 1 - Sql

I can highly recommend Squirrel SQL.

Also see this similar question:

Developer tools to directly access databases

Solution 2 - Sql

I'm sticking with DbVisualizer Free until something better comes along.

EDIT/UPDATE: been using https://dbeaver.io/ lately, really enjoying this

Solution 3 - Sql

I use SQLite Database Browser for SQLite3 currently and it's pretty useful. Works across Windows/OS X/Linux and is lightweight and fast. Slightly unstable with executing SQL on the DB if it's incorrectly formatted.

Edit: I have recently discovered SQLite Manager, a plugin for Firefox. Obviously you need to run Firefox, but you can close all windows and just run it "standalone". It's very feature complete, amazingly stable and it remembers your databases! It has tonnes of features so I've moved away from SQLite Database Browser as the instability and lack of features is too much to bear.

Solution 4 - Sql

For Oracle, I highly recommend the free Oracle SQL Developer


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

Solution 5 - Sql

I tried many GUI's, and the best for me continue being "SQLyog-comunity" by using wine. Is complete, is nice, and is intuitive. (and in wine work perfect)


All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionPhill PaffordView Question on Stackoverflow
Solution 1 - SqlsleskeView Answer on Stackoverflow
Solution 2 - SqlPhill PaffordView Answer on Stackoverflow
Solution 3 - SqlTomassinoView Answer on Stackoverflow
Solution 4 - SqlChiView Answer on Stackoverflow
Solution 5 - SqlFrancisco AlbertView Answer on Stackoverflow