Smashing Magazine - we smash you with the information that will make your life easier. really.

YourSQL (Mac) is a handy little freeware program that does some nice things. Easy to use, Mac-oriented interface. http://yoursql.ludit.it/

You’ve got SQL Buddy listed as (WIN) … its a web app…

When MySQL-Front went silent a couple of years ago, the developer pulled it for personal reasons, I came across a MySQL GUI client tool called SQLyog:

“SQLyog MySQL GUI is the most powerful MySQL manager and admin tool, combining the features of MySQL Query Browser, Administrator, phpMyAdmin and various other MySQL Front Ends and MySQL clients in a single intuitive interface. “

A strange name, still don’t know what it means, but the tool has been great for the past 4 years. They also have a MySQL Monitor and Advisor tool called MONyog:

“MONyog MySQL Monitor and Advisor is a “MySQL DBA in a box” that helps MySQL DBAs manage more MySQL servers, tune their current MySQL servers and fix problems with their MySQL database applications before they can become serious problems.”

Mysql Query Browser? Kit download with MySQL Tools

@Timothy
The MySQL Administration Tool kit from Mysql works great.

Yes, definitely a killer article ! Quite a few apps I didn’t know !

One rather unpleasant detail is that MySQL Workbench is available only for Mac OSX Leopard, while I have Tiger and I am stuck with MySQL Query Browser which is not really polished and not to mention crashes rather often …

I am surprised that MySQL Control Center was not discussed. For whatever reason, I can’t get phpMyAdmin up and configured on my system, and when someone suggested MySQLCC, I was able to get it up and running in no time.

It’s really worth a look.

Good article SM people!

I think SQLyog (free & commercial versions) are excellent alternatives not mentioned in this article.
You can get it here: .

Good list, but I think maybe you’ve got too many things on it. Why not try out all the tools and pick and handful of your favourite and explain why they’re good, it would be a lot more informative.

For example, MySQL Query Browser is available on Win/Mac/Linux but has different bugs in each version. The windows version has issues showing the table info for tables with title-case names, the linux version doesn’t let you delete multiple rows through the UI and the mac version is just unpolished and fiddly to use.

I find Querious (http://www.araelium.com/querious/) for the Mac pretty good, don’t know if its that much betetr than Sequel Pro though, and its $25.

The stock applications are nice but are very limited in functionality.
I have since purchased Navicat Standard and have not looked back. Primary reason for this move is dealing with legacy databases and migration/enhancements.

Great article!

Hi, nice article.

I would like to know what is the best (and simplest if possible) tool to [[ graphically ]] show database schemas in an existing mysql database, links and cardinalities between tables, primary keys, etc…
Any idea in the above list or another tools?

Ex:

| Table 1 | 0,1 ————> 1,n | Table 2 |

PhpMyAdmin & Xampp FTW!

It seems you’re forgeting MicroOLAP. It’s not free (and not cheap at all), but I think it worth the money! …and it’s Windows only, but I’m ok with that! >:D

I was a long-time MySQL-Front user, but when I found SQLyog, I simply could not go back. Highly recommended, and worth buying a license!

Good list but useless without some kind of conclusion about which is the best of the bunch. I could have gotten this list from google.

I would say Querious from Araelium is worth looking at. The UI is “the best” (much better than even Sequel Pro), and includes a really useful csv/tab file viewer/editor. It’s still in beta (but it’s very stable), and every release adds more refinement and useful features. It’s not yet the “do everything” tool that Navicat et al are, but for creating/editing tables, working with raw data, and managing reusable queries it’s a very fluid tool.

Ahem, mysql isn’t necessarily the best open source db platform. Lay off the hyperbole.

I agree with the other comments that you should do a ranking system. I think you could rank them on the following:

- Ease of use (Graphically)
- License type (Open Source = 5, highest $ = 1)
- Moving data between databases on same server / and different servers
- Finding data when you don’t know what you are looking for (like navicat you just double click the table it opens with the data and you can sort from there, no query needed)
- Updating information ease of use
- Multiple instances running (Yes = 5, No = 1)
- Connection types allowed (SSH, SSL, ect)

Also I would break up this article to be Web Only, and Application only. Since phpMyAdmin a lot of people use because it’s on the server. Where what if you want to use something not on the server?

For Mac OSX, Querious +1, better than Sequel Pro, still in beta, but developers very active. Product has great potential, and it very, very usable in the beta form.

Querious!!!!!

If you liked Toad for MySQL then you should also check out Spotlight on MySQL from Quest. It is a freeware product to make problem diagnosis much easier. You can get the information and download link here:

http://www.quest.com/spotlight-on-mysql/

Some of Quest’s other products for MySQL are also available in freeware form. You can find a list of products here:

http://www.quest.com/mysql/

Useless.

No Conclusive remark!

At the end, we stay where we are!

Great list! I started using navicat for mysql (not the lite version) about 3 months ago and it has changed my life. I still have phpMyAdmin installed in case I need to work on the databases while not at my normal mac, but for everyday use navicat does it for me!

I’m surprised MySQL Maestro wasn’t on this list. Pretty nice tool.

Great article but ..
I am nit-picking at this “The most popular and best open source database is MySQL”.

Most popular – yes, but not best.
I prefer PostgreSQL (power, speed, etc)

Great article, I love Sequel Pro! I use MAMP for local development on my Mac, and thusly use phpMyAdmin on occasion.

Nice Article!
I used Navicat, but not the Lite Version, they have a commercial version which contains more features like data/structure sync, import/export, report building, scheduler, etc.
But if you are just looking for normal data editing features, the Lite version will do, and it’s free.

I’ve always use phpMyAdmin. I may give some of the others mentioned in this article a go. I particularly like the look of MySQL-Front.

I am highly recommend Navicat , fast and stable.
and he provides fully support, especially online live support! its really helpful.

+1 of SQLYog. I also use phpMyAdmin when appropriate.

Navicat comes to a distant 2nd. The advantage with Navicat is that it is platform independent.
The problem with Navicat is that it is very buggy and crashes very often. I dumped it when it crashed with unsaved queries!

A couple people have mentioned the official MySQL GUI tools. I find they work great, and not only are they are already in the Ubuntu repo’s for an easy installation, but they work on Win and OS X as well. Oh…yeah…. they are free.

MySQL GUI Tools

MySQL Administrator
MySQL Query Browser

Many Thanks.
My all time favorite is Navicat.

I just tired Navicat for MySQL and purchased it. It does cost some money but you can try it for free to see if you like it (it also supports PostgreSQL and Oracle). I personally think it is the cat’s pajamas.

I used to use free MySQL admin tool such as phpmyadmin and sqlyog but both are very buggy especially when handling large amount of data.

Good article.

Have to add my voice of approval for SQLyog, absolutely brilliant piece of software.

Not much of a fan of phpMyAdmin anymore though, far too limiting.

Using heidy sql, after trying alot of free software i found this the more complete (not web-based) solution for mysql database creation.

Lita … nice AIR SQL Application …

Dbvis ( dbvis ) should be added to your list.

Works great with MySQL (and anything else that provides a JDBC driver). Versions available for Mac/Windows/Linux.

Being able to work on Oracle, MySQL and sqlite tables, concurrently, all within one application instance is a huge time-saver for me.

I got navicat, because I was building a database to manage wide range of data for a research project. I had about 10 different excel spreadsheets that I was tracking various bits of data, which was confusing enough, but I need to get the information out to more people. So I decided to convert to MySQL database, and Navicat really helped easily get my excel data into mysql, and Navicat makes it easy to maintain using a GUI, rather than the line commands, or tedium of phpMyAdmin for multiple edits.

No offense, I think Navicat is much better than Heidisql or Sqlyog. They are nice and very cheap. However, Sqlyog or Heidisql are very unstable especially I tried them to handle large data transfer and they crashed. We did different tests and Navicat’s speed is really fast!!

My favourite features of Navicat are Backup, import/export, basic database functionality, including browsing tables, connections management, toolbar, subdivision of functions, user management, queries, performance. I’d like to see being able to search backwards in the text of query results.

Didn’t really need the documentation. Navicat was so well designed and user-friendly that it’s self-explained. Thanks.

Wow, these Navicat guys have started spamming again. Take their comments with a pinch of salt. These guys are so lazy that they won’t even change their names while spamming!

Check this:
http://www.orafaq.com/forum/index.php?t=rview&th=123464
http://forums.tutorialized.com/oracle-112/is-navicat-oracle-database-admin-tool-a-oracle-product-82825.html

The last comment as “Klin” is from Ken Lin – the product manager of Navicat. He is a big spammer himself. Find out yourself: http://www.google.com/search?q=ken+lin+navicat

In a nutshell, don’t believe these comments. Download the trial of each software in the list and judge yourself. Just my 2 cents.

SQLyog is an easy to use GUI tool that has helped our team to work smarter and deliver the project faster. Its features and functions can be learned quickly. My teammates highly recommended this tool. I tried many software. All other MySQL GUIs are not stable and will crash sometimes. Sqlyog will not crash. I would persuade my boss to get a copy.

SQLYog is the way to go. It’s the best MySQL GUI out there. It can even run well on a Mac if you have Crossover or Wine.

Yes, SQLyog is very cheap and I was attracted by the very cheap price of SQLyog. However, it crashed few times when transferred large database between my development DB and my production DB. I lost some important data of daily sales. Anyway, I will keep using its free version. Also, it’s terrible suggestion for using SQLyog on Mac platform. I will never do that on my Mac!! Sorry.

The cool thing about Navicat is that it also supports other databases like Oracle and PostgreSQL

Nice article! I would like to see more of this ;)
I’m using ModelRight for designing, deploying resp. reverse engineering MySQL databases. I was wandering not seeing it in this article. They even have a free community edition. Great tool! Don’t want to miss it.

I would like to recommend 1 more tool :

MySQL DB compare tool – http://nobhillsoft.com/NHDBCompare.aspx
(The tools here are good for SQL or MySQL)

Jing Dan Yo!
Amazing

I was searching for a list of all MySql Tools available and this article is great!!!

I might also suggest a free, open source web based MySql Manager.
It’s called AeroSQL.

There is a demo, video and screenshots.

AeroSQL is a free web based tool for managing MySql servers written in PHP. The key feature of the product is an intuitive management of the database content. The result of SELECTs is displayed in a grid as in traditional desktop applications.

Regards.

Anybody else use Oracle’s SQL Developer for accessing MySql (and plenty of other DBMS’, including Oracle, of course)?

I’ve used Navicat (not lite) on Windows for a while and have been pleased. After going through the comments and seeing the obvious self promotion, I’ve decided I need to investigate these other tools and see what is best.

I’m trying to move to using my MacBook Pro more and came across this article to find out what tools are out there.

I’m hoping that Sequel Pro will meet my needs. I did not see many other OS X apps that do the same. If there are others that are similar to Navicat and Sequel Pro, let me know. I’d love to try them out.

Navicat and phpmyadmin are very fine.

Thanking you,
B.V.Krishna Kumar.

I used to use MySQL GUI tools for windows but since shifting to development on my mac I found the tools to be somewhat poor crashing ever 5 minutes numerous bug requests over the past year have all ended with Mac is not supported so I have now switched to Sequel Pro Awesome and pretty, I even donated!!!

Don’t forget “Database Workbench”, a Pro edition is available and a FREE Lite Edition for MySQL as well.

http://www.upscene.com