

TablePlus has a modern, native GUI client for MySQL that enables developers & DBAs to develop, manage, and maintain MySQL database in a fast and easy way. 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.įor now, I'm happy with Navicat and will likely continue to use it as my default MySQL admin tool.If you don’t like when Navicat for MySQL keeps hanging on your computer, or it normally takes too much RAM to run, then you should try TablePlus. 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.įor 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. I'd rather an option for it to default to raw mode or allow Command-Enter to execute the change in raw mode. You can quickly turn on raw mode by hitting Command-Enter but it feels awkward. My only major complaint about the edit mode is the default entry mode which doesn't allow for MySQL functions.

You can do user management, edit views and stored procedures, save custom queries, and the table browser supports pagination, filtering and multi-column sorting. It's easy to use and has all the features I'd expect.

Navicat does support editable query results and, as a result, I've switched to using it full-time. Unfortunately, it didn't quite fit the bill. The first app that came to mind, and that others recommended, was Sequel Pro. I quickly went on the search for something to fill the void. It's been a very handy feature and much of the maintenance for Snook.ca happens via my GUI app.Īfter my switch to the Mac, I discovered that SQLYog wasn't able to come along for the ride. Eventually I had settled on SQLYog as it had provided one key feature: the ability to edit a query result. Then I switched to working mostly with MySQL and have bounced around various apps including the query browser and migration tools provided by MySQL. When I developed for MS SQL Server, I used to use the query tool that came bundled. I like desktop GUI interfaces for database administration.
