Feature Matrix
Standard | Enterprise | |
Connection | ||
MariaDB 5.1 or later | ||
Amazon AWS, Microsoft Azure, Tencent Cloud | ||
Secure connection: SSH, HTTP Tunnel and SSL/TLS | ||
PAM authentication | ||
Centralized connection management | ||
Connection profiles | ||
Customize connection colorings | ||
Export/import connection settings | ||
Navicat Collaboration | ||
Collaboration: create projects, add members | ||
Synchronize connection settings, queries, snippets and virtual group information | ||
Synchronize BI workspaces and model workspaces | ||
Data Viewer and Editor | ||
Grid view | ||
Form view | ||
Data profiling | ||
Text, hex, image or web viewer and editor | ||
Foreign key data selection | ||
Filter and sort | ||
Table profile | ||
Find and replace | ||
Query Processing | ||
Query editor with syntax highlight | ||
Code completion | ||
Code snippet | ||
Query builder | ||
Visual explain | ||
Pin query result | ||
SQL beautifier and minifier | ||
Find and replace | ||
Create parameter queries | ||
Console | ||
Object Designer | ||
Database object design tools | ||
View builder | ||
SQL preview | ||
BI | ||
Over 20 chart type options | ||
Visualize live data | ||
Customized fields | ||
Customize multiple pages dashboard | ||
Add interactive controls | ||
Present mode | ||
Model | ||
Physical model | ||
Reverse database to model | ||
Synchronize database to model | ||
Synchronize model to database | ||
Export model to SQL file | ||
Compare model workspaces | ||
Auto layout | ||
Add vertices, layers, images, notes, labels and shapes | ||
Print database diagrams to PDF and graphic files | ||
Import and Export | ||
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON | ||
Import data from ODBC, MS Excel, MS Access, DBF | ||
Export data to MS Excel, DBF | ||
Export data to MS Access (Windows Edition only) | ||
Structure and Data Manipulation | ||
Structure synchronization | ||
Data transfer | ||
Data synchronization | ||
Data generation | ||
Data dictionary | ||
Copy and paste data across databases | ||
Backup and Restore | ||
Backup/restore database | ||
Convert backup file into SQL script | ||
Dump/execute SQL file | ||
Automation | ||
Set schedule on : query, backup, data transfer, data synchronization, data generation, data dictionary, BI, model, import, export | ||
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 | ||
Open object via URI | ||
Virtual grouping | ||
Database wide search | ||
Favorites list | ||
Focus mode | ||
Dark mode |
Connection
MariaDB 5.1 or later |
Enterprise Standard |
Amazon AWS, Microsoft Azure, Tencent Cloud |
Enterprise Standard |
Secure connection: SSH, HTTP Tunnel and SSL/TLS |
Enterprise Standard |
PAM authentication |
Enterprise Standard |
Centralized connection management |
Enterprise Standard |
Connection profiles |
Enterprise Standard |
Customize connection colorings |
Enterprise Standard |
Export/import connection settings |
Enterprise Standard |
Navicat Collaboration
Collaboration: create projects, add members |
Enterprise Standard |
Synchronize connection settings, queries, snippets and virtual group information |
Enterprise Standard |
Synchronize BI workspaces and model workspaces | Enterprise |
Data Viewer and Editor
Grid view |
Enterprise Standard |
Form view |
Enterprise Standard |
Data profiling |
Enterprise Standard |
Text, hex, image or web viewer and editor |
Enterprise Standard |
Foreign key data selection |
Enterprise Standard |
Filter and sort |
Enterprise Standard |
Table profile |
Enterprise Standard |
Find and replace |
Enterprise Standard |
Query Processing
Query editor with syntax highlight |
Enterprise Standard |
Code completion |
Enterprise Standard |
Code snippet |
Enterprise Standard |
Query builder |
Enterprise Standard |
Visual explain |
Enterprise Standard |
Pin query result |
Enterprise Standard |
SQL beautifier and minifier |
Enterprise Standard |
Find and replace |
Enterprise Standard |
Create parameter queries |
Enterprise Standard |
Console |
Enterprise Standard |
Object Designer
Database object design tools |
Enterprise Standard |
View builder |
Enterprise Standard |
SQL preview |
Enterprise Standard |
BI
Over 20 chart type options | Enterprise |
Visualize live data | Enterprise |
Customized fields | Enterprise |
Customize multiple pages dashboard | Enterprise |
Add interactive controls | Enterprise |
Present mode | Enterprise |
Model
Physical model | Enterprise |
Reverse database to model | Enterprise |
Synchronize database to model | Enterprise |
Synchronize model to database | Enterprise |
Export model to SQL file | Enterprise |
Compare model workspaces | Enterprise |
Auto layout | Enterprise |
Add vertices, layers, images, notes, labels and shapes | Enterprise |
Print database diagrams to PDF and graphic files | Enterprise |
Import and Export
Import/export data from/to plain text file formats: TXT, CSV, XML, JSON |
Enterprise Standard |
Import data from ODBC, MS Excel, MS Access, DBF |
Enterprise Standard |
Export data to MS Excel, DBF |
Enterprise Standard |
Export data to MS Access (Windows Edition only) |
Enterprise Standard |
Structure and Data Manipulation
Structure synchronization |
Enterprise Standard |
Data transfer |
Enterprise Standard |
Data synchronization |
Enterprise Standard |
Data generation |
Enterprise Standard |
Data dictionary |
Enterprise Standard |
Copy and paste data across databases |
Enterprise Standard |
Backup and Restore
Backup/restore database |
Enterprise Standard |
Convert backup file into SQL script |
Enterprise Standard |
Dump/execute SQL file |
Enterprise Standard |
Automation
Set schedule on : query, backup, data transfer, data synchronization, data generation, data dictionary, BI, model, import, export |
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 |
Server monitor |
Enterprise Standard |
Other Useful Features
ER diagram view |
Enterprise Standard |
Open object via URI |
Enterprise Standard |
Virtual grouping |
Enterprise Standard |
Database wide search |
Enterprise Standard |
Favorites list |
Enterprise Standard |
Focus mode |
Enterprise Standard |
Dark mode |
Enterprise Standard |