My new favorite MySQL database administrator application – Sequel Pro (Mac OS X only)

My co-worker sent me a link to a new MySQL database administrator app call Sequel Pro. It’s free for Mac OS X. I’ve been using it for about two weeks now and it has now replaced phpMyAdmin and MySQL Query Browser as my primary database application. It is a native OS X app. It’s so easy to use, very fast and the interface is great.

I’ve used the MySQL tools for about a year now and find them to be slow and buggy. This is likely due to them being written in Java.

phpMyAdmin has been a great companion for many years but depending on your hosting provider, it can take 5+ clicks to get to their version of phpMyAdmin for your website. The interface is outdated and the ease of use just isn’t there anymore.

The only downside of Sequel Pro which is the same as the MySQL tools is that you need to have external connections open to your database which is a possible security hole. (Update: See Sequel Pro Docs about creating an SSH tunnel so you don’t have to open up external connections to your database. Thanks Bruno.)

For any other Mac web developers out there give Sequel Pro a look.

[carousel keywords=”mysql” category=”Books” tag=”damnsemi01-20″ showBorder=”True”]

Continue Reading

  • Jon

    I really like this app too. The latest update is great!

  • “The only downside of Sequel Pro which is the same as the MySQL tools is that you need to have external connections open to your database which is a possible security hole.”

    If the server where your MySQL is running allows SSH connections, you don’t have to open it to the outside. You can create a tunnel from your laptop to the server and SEQUEL will communicate with MySQL using the tunnel.

    You can have a look at their documentation:
    http://www.sequelpro.com/docs/Connecting_to_a_MySQL_Server_on_a_Remote_Host#SSH_connections

    Cheers,
    Bruno

    • Skye

      Thanks for the tip Bruno. I’ve updated the article and will be switching over to an SSH tunnel soon. Cheers.