What MySQL client application would you recommend for Mac OS X?

Question

My colleagues and I are looking for alternative client tools for Mac OS X.

I tend to prefer the text-based interface and we have PHPMyAdmin installed on our development servers (Linux).

What are your recommendations?

(One recommendation per answer please, so people can up-mod individual recommendations).

Answer 1

YourSQL (free) is pretty good.

Answer 2

The MySql GUI (free) from the same people who put out the database are pretty good too :)

Answer 3

There is also Sequel Pro (free, open source, formerly called "CocoaMySql")

Answer 4

I've been pretty pleased with SQL Editor. It supports ERD diagrams, and creating diagrams from live database schemas. You can also generate your schema directly from the tool also. From the web site:

Key Features

• Visual editing, including drag and drop
  • Live source view - the SQL source changes as you edit the diagram
  • Ruby On Rails Migrations - SQLEditor can export them and now (in v1.4) import them too!
  • With SQLEditor's reverse engineering you can import existing databases to diagram and SQLEditor will create an ER diagram for you.
  • Once you've created your diagram you can export it directly via JDBC to one of several supported database systems including Postgresql, Oracle® and MySQL®.
  • You can save your database to an SQL instruction (DDL) file for immediate use on remote servers or with other tools.
  • Import existing DDL files directly into SQLEditor
  • Copy and paste to import and export supported SQL to and from SQLEditor
  • You can print out designs so that you can see your database up on the wall.1 SQLEditor also supports PDF output for easy sharing.

Answer 5

If you prefer PHPMyAdmin, why not install it on OS X? It's a piece of piss to install PHP on OS X, and OS X comes bundled with Apache

Answer 6

We've found RazorSQL to be useful also.

Answer 7

I would say Navicat is second to none.

This one costs money... but it is the best that I have ever used for MySQL in OS X (the price is not bad at all). I have used all of the others mentioned on this page (MySQL GUI, CocoaMySQL, YourSQL, SQL Editor and PHPMyAdmin).

It gives you almost everything that Microsoft gives in their "Management Studio" product.

If I were to choose a second place holder, it would be PHPMyAdmin. Please let me know if you need more details.

Answer 8

[Aqua Data Studio][1] is a powerful SQL client, supporting several databases, not only MySQL. It is cross-platform, and has a nice look-and-feel on Windows, Linux, Mac.

It is a commercial product, with a free license for FOSS developers.

[1]: http://aquafold.com/"Aqua Data Studio"

Answer 9

SQuirreL SQL has a Mac client that works fairly well. It is especially good if you need to connect to more databases than just MySQL.

http://www.squirrelsql.org/

Answer 10

/usr/local/bin/mysql of course! What else do you need? :-)

Answer 11

Since I cannot comment, CocoaMySQL is now known as Sequel Pro.

Answer 12

Sequel Pro isn't bad, and its free. Right now I'm using Querious though. It's definitely the best looking client out of any of the ones I've seen, and although it's still in beta it hasn't caused me any problems yet.

Answer 13

If you're running Parallels or VMWare, SQLyog is a terrific GUI. It's almost worth using those apps just to run SQLyog, and when I was going full-time heavy database development, it's what I used. Nothing on the Mac platform comes close, at least for the way I work.

Answer 14

The official contribution from MySQL themselves "MySQL WorkBench" is most certainly getting better! Version 5.2.17 is the current as of writing, and it got everything from design and visualization to support for executing SQL and viewing results.

Cross platform, so pick your poison :)

Answer 15

I've tried Navicat - it was so unstable! And to be honest, so have the other ones I've tried, MySQL Workbench and Querious. The only one that hasn't given me issues has been Sequel Pro, but it simply doesn't have much of a feature set.