Feature Matrix
| Essentials | Standard | Enterprise | |
| Connection | |||
| MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server |  |
|
 |
| MariaDB 5.1 or later | |
|
|
| Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud, Microsoft Azure, Alibaba Cloud, Tencent Cloud, Huawei Cloud | |
|
|
| Secure connection: SSH/HTTP/SSL | |
|
|
| PAM authentication | |
|
|
| Export/import connection settings | |
|
|
| Navicat Cloud | |||
| Collaboration: create projects, add members | |
|
|
| Synchronize connections and queries | |
|
|
| Synchronize models | |
||
| Synchronize virtual groups | |
|
|
| Data Viewer and Editor | |||
| Grid view | |
|
|
| Form view | |
|
|
| Foreign key data selection | |
|
|
| Text, Hex, Image or Web viewer/editor | |
|
|
| Raw mode editing | |
|
|
| Find and replace | |
|
|
| Filter records | |
|
|
| SQL Processing | |||
| SQL Editor | |
|
|
| Visual SQL Builder | |
|
|
| Code Snippet and Completion | |
|
|
| SQL Code Beautifier/Minifier | |
|
|
| Find and replace | |
|
|
| Create parameter queries | |
|
|
| Open query files in an external editor | |
|
|
| Console | |
|
|
| Data Visualization | |||
| Support 20 chart types | |
||
| Visualize live data | |
||
| Customize multiple pages dashboard | |
||
| Add interactive controls | |
||
| Data Modeling | |||
| Physical model | |
||
| Reverse/forward engineering | |
||
| Auto layout | |
||
| Add vertices, layers, images, notes, labels and shapes | |
||
| Print database diagrams to PDF and graphic files | |
||
| Import/Export | |||
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON | |
|
|
| Import/export data from/to most popular formats: DBF etc | |
|
|
| Import data from ODBC, MS Excel, MS Access | |
|
|
| Export data to MS Excel, HTML | |
|
|
| Export data to MS Access (Windows Edition only) | |
|
|
| Data Manipulation | |||
| Data Transfer | |
|
|
| Data/Structure Synchronization | |
|
|
| Backup/Restore | |||
| Backup/restore database | |
|
|
| Convert backup file into SQL script | |
|
|
| Dump/Execute SQL file | |
|
|
| Automation | |||
| Set schedule on backup, query execution, import/export, data transfer and data synchronization | |
|
|
| Run profiles from different servers in a single batch job | |
|
|
| Include attachment for export file in notification email | |
|
|
| Server Security | |||
| Manage user | |
|
|
| Server Monitor | |
|
|
| Other Useful Features | |||
| ER Diagram view | |
|
|
| Virtual grouping | |
|
|
| Customize connection colorings | |
|
|
| Database wide search | |
|
|
| Favorites list | |
|
|
| Print database/table structure | |
|
|
| Dark mode | |
|
|
Connection
| MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server |
Enterprise 
Standard 
Essentials
|
| MariaDB 5.1 or later |
Enterprise
Standard
Essentials
|
| Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud, Microsoft Azure, Alibaba Cloud, Tencent Cloud, Huawei Cloud |
Enterprise
Standard
Essentials
|
| Secure connection: SSH/HTTP/SSL |
Enterprise
Standard
Essentials
|
| PAM authentication |
Enterprise
Standard
Essentials
|
| Export/import connection settings |
Enterprise
Standard
Essentials
|
Navicat Cloud
| Collaboration: create projects, add members |
Enterprise
Standard
Essentials
|
| Synchronize connections and queries |
Enterprise
Standard
Essentials
|
| Synchronize models |
Enterprise
|
| Synchronize virtual groups |
Enterprise
Standard
|
Data Viewer and Editor
| Grid view |
Enterprise
Standard
Essentials
|
| Form view |
Enterprise
Standard
|
| Foreign key data selection |
Enterprise
Standard
|
| Text, Hex, Image or Web viewer/editor |
Enterprise
Standard
Essentials
|
| Raw mode editing |
Enterprise
Standard
Essentials
|
| Find and replace |
Enterprise
Standard
Essentials
|
| Filter records |
Enterprise
Standard
Essentials
|
SQL Processing
| SQL Editor |
Enterprise
Standard
Essentials
|
| Visual SQL Builder |
Enterprise
Standard
|
| Code Snippet and Completion |
Enterprise
Standard
|
| SQL Code Beautifier/Minifier |
Enterprise
Standard
|
| Find and replace |
Enterprise
Standard
Essentials
|
| Create parameter queries |
Enterprise
Standard
Essentials
|
| Open query files in an external editor |
Enterprise
Standard
Essentials
|
| Console |
Enterprise
Standard
Essentials
|
Data Visualization
| Support 20 chart types |
Enterprise
|
| Visualize live data |
Enterprise
|
| Customize multiple pages dashboard |
Enterprise
|
| Add interactive controls |
Enterprise
|
Data Modeling
| Physical model |
Enterprise
|
| Reverse/forward engineering |
Enterprise
|
| Auto layout |
Enterprise
|
| Add vertices, layers, images, notes, labels and shapes |
Enterprise
|
| Print database diagrams to PDF and graphic files |
Enterprise
|
Import/Export
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON |
Enterprise
Standard
Essentials
|
| Import/export data from/to most popular formats: DBF etc |
Enterprise
Standard
|
| Import data from ODBC, MS Excel, MS Access |
Enterprise
Standard
|
| Export data to MS Excel, HTML |
Enterprise
Standard
|
| Export data to MS Access (Windows Edition only) |
Enterprise
Standard
|
Data Manipulation
| Data Transfer |
Enterprise
Standard
|
| Data/Structure Synchronization |
Enterprise
Standard
|
Backup/Restore
| Backup/restore database |
Enterprise
Standard
|
| Convert backup file into SQL script |
Enterprise
Standard
|
| Dump/Execute SQL file |
Enterprise
Standard
Essentials
|
Automation
| Set schedule on backup, query execution, import/export, data transfer and data synchronization |
Enterprise
Standard
|
| Run profiles from different servers in a single batch job |
Enterprise
Standard
|
| Include attachment for export file in notification email |
Enterprise
Standard
|
Server Security
| Manage user |
Enterprise
Standard
Essentials
|
| Server Monitor |
Enterprise
Standard
|
Other Useful Features
| ER Diagram view |
Enterprise
Standard
|
| Virtual grouping |
Enterprise
Standard
|
| Customize connection colorings |
Enterprise
Standard
Essentials
|
| Database wide search |
Enterprise
Standard
|
| Favorites list |
Enterprise
Standard
|
| Print database/table structure |
Enterprise
Standard
|
| Dark mode |
Enterprise
Standard
Essentials
|
