

When in table design, you can't duplicate rows. I frequently find myself typing up the SQL in a text editor like TextMate and pasting it into Navicat. The GUI for editing triggers and stored procedures is non-intuitive. Very frustrating if you have several or more query tabs open! Related to the above: You lose all your unsaved queries when it crashes. It regularly crashes whenever I use SSH tunneling on the road. Or grab the free version off their website if you are going to use it non-commercially. If you do heavy editing, you'll appreciate its versatility compared to web-based solutions.

As far as I'm concerned, it's the best MySQL editor on the Mac. Bypass ISP restrictions with HTTP Tunneling.Have been using Navicat for over two years. Strong authentication and secure encryption. Establish secure SSH/SSL sessions through SSH/SSL Tunneling. Simultaneously access Tables and Objects across different servers. View Tables and Objects in a unified workspace. Field Type Prediction predicts field types based on input. Create, modify, and design database objects. Select properties and SQL keywords from a suggestion list. Construct queries with our code completion feature. Add, modify, delete with an iOS-centric UI. Get visibility into your team activities from the Activity Log. Add members and define each member role in the project. Create projects to share connections & queries with your team members. Get real-time connections and queries anytime, anywhere. Navicat is compatible with MySQL and has sophisticated features that provide professional developers with the tools they need, but are accessible and easy-to-learn for users new to database servers. Sync your connections and queries to Navicat Cloud, or organize your work through a UI-enhanced multi-tasking workflow. Navicat has a whole new set of features aimed at making your database administration portable and at enhancing the classic Navicat experience. Whether you are working from an iPhone or an iPad, Navicat frees you from your workstation. Navicat for MySQL is the first complete database administration tool developed for iOS, giving you the power to manage your databases on the go.
