avicat for MySQL is the ideal solution for MySQL/MariaDB administration and development. It is a single application that allows you to connect to MySQL and MariaDB databases simultaneously. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Oracle Cloud and Google Cloud. This all-inclusive frontend provides an intuitive and powerful graphical interface for database management, development, and maintenance.
Ranked in these QuestionsQuestion Ranking
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.
Originally released on Windows, it has been ported to OS X and Linux.
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 User management
Navicat allows for simple user and access management.
Pro Unicode support
Navicat has full unicode support.
Pro SQL code completion
Navicat supports auto-complete for SQL queries.
Pro Data and structure synchronization
Navicat can compare and synchronize your data and structure between local and remote databases.
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.
The cost of a license ranges from $119-$299.
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.