When comparing Navicat for MySQL vs Sequel Ace, the Slant community recommends Navicat for MySQL for most people. In the question“What are the best MySQL GUI clients for OS X?” Navicat for MySQL is ranked 2nd while Sequel Ace is ranked 13th. The most important reason people chose Navicat for MySQL is:
Navicat can easily import data from ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON etc and export to Excel, Access, DBF, TXT, CSV, XML, JSON etc.
Ranked in these QuestionsQuestion Ranking
Pros
Pro Excellent choice of import/export options
Navicat can easily import data from ODBC, Excel, Access, DBF, TXT, CSV, XML, JSON etc and export to Excel, Access, DBF, TXT, CSV, XML, JSON etc.
Pro HTTP/SSH tunnel
Navicat can upload a PHP script to enable HTTP tunneling or choose a SSH tunnel instead.
Pro Easy to use
Navicat manages an intuitive, easy to use UI without sacrificing functionality.
Pro Unicode support
Navicat has full unicode support.
Pro Data and structure synchronization
Navicat can compare and synchronize your data and structure between local and remote databases.
Pro User management
Navicat allows for simple user and access management.
Pro Light-weighted
Pro Cross-platform
Originally released on Windows, it has been ported to OS X and Linux.
Pro SQL code completion
Navicat supports auto-complete for SQL queries.
Pro Server monitoring
Allows you to monitor your server for inefficient queries, etc.
Pro Batch job scheduling
Navicat can schedule things like backups, restores, data transfers or report building.
Pro Visual query builder
Create and edit queries without writing SQL.
Pro Visual report builder
Navicat can build reports in a visual way. Once set up, the process can be scheduled.
Pro Doesn't crash like Sequel Pro
Since this as an updated version of Sequel Pro, there are fewer crashes than the dead project.
Pro Open Source and on Mac App Store
Cons
Con Buggy
Navicat tends to release builds that have some problems, but they usually release a patched version soon after. Also have had issues with import/export and tunneling.
Con Still buggy, not getting better with updates
This software is way to buggy for a premium priced product. Have done many payed upgrades but I will not do a next payed upgrade. I am done with all the crashing and me losing time with this piece of software. Looking for an alternative.
Con Cost
The cost of a license ranges from $119-$299.
Con Doesn't support multiple result tabs for multiple queries
This feature exists in other programs like Navicat, TablePlus, Querious, and MySQL WorkBench.
Con Slow/laggy query editor window
Query editor window is extremely slow/unresponsive when you have several queries in it. Same as Sequel Pro.