Add to Chrome
Add to Edge
Add to Firefox
Add to Opera
Add to Brave
Add to SafariWhen comparing Navicat for MySQL vs DbSchema, 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 DbSchema is ranked 12th. 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.
Specs
Question 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 Graphical Diagram Editor
Includes the possibility to edit tables and data directly in the diagram without writing SQL statements.
Pro Multi-platform
Runs on Windows, Mac, and Linux.
Pro Virtual Foreign Keys
If the Database schema is missing real foreign keys, it is possible to create virtual ones to be used within the tool.
Pro Generator for Random Data
Includes the possibility to generate random numerical data or fetch random entries from a text file to populate the database.
Pro Generate schema from existing database
Includes the possibility to generate an ER diagram from an existing database.
Pro SQL editor with syntax highlighting
Includes an SQL editor with syntax highlighting and code completion feature.
Pro Graphical Query Editor
Includes a visual query editor capable of using different join types, filters as well as the 'group by' clause.
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.
