Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

What MySql client are you using for Linux. I currently use PhpMyAdmin and the Mysql Query Browser but I would like something similar to Toad or HeidiSql that I use on windows. One with SQL code completion.

share|improve this question
is code completion the only additional requirement you're looking for? – quack quixote Apr 8 '10 at 19:46
The more I can get, the better. Basically looking for the best MySql client on linux. I'm a developer, so writing losts of SQL scripts and my databases are getting big. Writing Stored Procedures often also, so anything that will make my life easier. Thanks – Hannes de Jager Apr 8 '10 at 19:51
up vote 5 down vote accepted

I use SqlYog running under Wine. This is because quite simply no linux tools that I've found come close to matching the raw power and flexability of SqlYog. This is one of the few non open-source software tools that I use for open source development. Below screenshot shows SQLyog running under Gnome evnironment

share|improve this answer
Really looks like a good one. I see Google is also using it. Pity they don't have a native one for Linux, but Wine should do I suppose. – Hannes de Jager Apr 12 '10 at 18:09
Oh I fonrgot to mention that the code completion in SqlYog will also complete the object (tables,columns) names within your database. – Josiah Apr 13 '10 at 10:40

Tora (Qt client) and Mysql-Workbench (official MySQL client, in GTK) are another alternatives for Linux.

share|improve this answer
+1 for mySQL-Workbench. Even Oracle SQL developer works with 3rd party add-on, this official program works perfectly under linux (RHEL 6 in my case). – ruffp Jun 13 '12 at 6:30

I have always prefered Squirrel SQL . Its a universal sql client - so you can use the app to connect to mysql , msSql , Oracle , etc etc.

share|improve this answer

You might find crunchyfrog useful, should you ever have to work with databases other than MySQL.

share|improve this answer

Take a look at this list for Toad from I'm pretty sure Oracle SQL Developer will do what you want on linux.

share|improve this answer
I'm pretty sure Oracle SQL Developer won't work with MySQL – Doug Harris Apr 9 '10 at 0:58
heheh. I totally missed that. – jweede Apr 9 '10 at 2:11
In fact there is a third party driver which can be instelled through the SQL Developer Update menu which supports mySQL. I did used it and it was also working – ruffp Jun 13 '12 at 6:24

I like runsqlrun ->

This is fork the CrunchyFrog with python3 and gtk3.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .