Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing DBeaver vs Navicat for MySQL, the Slant community recommends DBeaver for most people. In the question“What are the best MySQL GUI clients for OS X?” DBeaver is ranked 1st while Navicat for MySQL is ranked 2nd. The most important reason people chose DBeaver is:
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Specs
Question Ranking
Pros
Pro Cross-platform
Supported on Windows (2000/XP/2003/Vista/7/8/10), Linux, Mac OS and Solaris (x86).
Pro Free
It is licensed under GPL v2.
Pro Works for many types of databases
MySQL, Oracle, PostgreSQL, IBM DB2, Microsoft SQL Server, Microsoft Access, Sybase, Java DB (Derby), Firebird (Interbase), Derby (JavaDB), SQLite, Mimer, HSQLDB, H2, IBM Informix, Teradata, SAP MAX DB, Cache, Ingres, Linter, Vertica, MongoDB, Cassandra, ODBC, Any JDBC compliant data source.
Pro Follow foreign key to their primary key
If you have a table with a foreign key you can click on it to see the table row where this key references to.
Pro Formatted text view
It has the classic grid view and a well-organized text view that you can quick-select with CTRL-A.
Pro Easy to use, clean neat inteface
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.
Cons
Con Never-ending function errors
Like, 'Communications link failure', 'Connection refused' (Community Edition 6.2.1).
Con Cannot view function
Con Trigger edition
Until version 3.5.8 you can not edit triggers, only view (since 3.5.6).
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.
