Navicat for the Mac
I like desktop GUI interfaces for database administration. When I developed for MS SQL Server, I used to use the query tool that came bundled. Then I switched to working mostly with MySQL and have bounced around various apps including the query browser and migration tools provided by MySQL. Eventually I had settled on SQLYog as it had provided one key feature: the ability to edit a query result. It's been a very handy feature and much of the maintenance for Snook.ca happens via my GUI app.
After my switch to the Mac, I discovered that SQLYog wasn't able to come along for the ride. I quickly went on the search for something to fill the void. The first app that came to mind, and that others recommended, was Sequel Pro. Unfortunately, it didn't quite fit the bill. It lacked the editable query result.
Next up was Navicat. Navicat does support editable query results and, as a result, I've switched to using it full-time. It's easy to use and has all the features I'd expect. You can do user management, edit views and stored procedures, save custom queries, and the table browser supports pagination, filtering and multi-column sorting.
My only major complaint about the edit mode is the default entry mode which doesn't allow for MySQL functions. You can quickly turn on raw mode by hitting Command-Enter but it feels awkward. I'd rather an option for it to default to raw mode or allow Command-Enter to execute the change in raw mode. In the grand scheme of things, this is a minor niggle and only because it's differen than the workflow that I've become accustomed to.
For those that have to bounce from platform to platform, Navicat is available on Windows, Mac and Linux and has versions that support MySQL, PostgreSQL and Oracle.
The Mac version lags behind the Windows version when it comes to supported features but I'm told that version 8 will be out next year supporting features its counterpart has such as the Form View and code completion.
For now, I'm happy with Navicat and will likely continue to use it as my default MySQL admin tool.