Feature Matrix
Essentials | Enterprise | |
General | ||
MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server | ||
MariaDB 5.1 or later | ||
MongoDB 3.0 or later | ||
Redis 2.8 or later, Redis Cluster | ||
Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) | ||
PostgreSQL 7.3 or later | ||
SQLite 2 and 3 | ||
SQL Server 2000 or later | ||
OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode not available in macOS Edition) | ||
Amazon RDS, Amazon Aurora, Amazon Redshift, Amazon ElastiCache, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas, Huawei Cloud | ||
Connection | ||
Secure connection: SSH/HTTP/SSL | ||
PAM and GSSAPI authentication | ||
Kerberos and LDAP authentication | ||
x.509 certificate authentication | ||
Connection profiles | ||
Export/import connection settings | ||
Navicat Collaboration | ||
Collaboration: create projects, add members | ||
Synchronize connections and queries | ||
Synchronize charts, models, snippets and virtual groups | ||
Data Viewer and Editor | ||
Grid view, Tree view and JSON view | ||
Form view | ||
Foreign key data selection | ||
Text, Hex, Image, Web or BFile viewer/editor | ||
Raw mode editing | ||
Data Validation | ||
Customize data type colorings | ||
Find and replace | ||
Filter records | ||
SQL/Script Processing | ||
PL/SQL and PL/PGSQL Debugger | ||
SQL/Script Editor | ||
Visual SQL/Script Builder | ||
Find Builder | ||
Aggregate Builder | ||
Code Snippet and Completion | ||
SQL/Script Beautifier and Minifier | ||
Find and replace | ||
Create parameter queries | ||
Open query files in an external editor | ||
Console | ||
Data Visualization | ||
Support 20 chart types | ||
Visualize live data | ||
Customized fields | ||
Customize multiple pages dashboard | ||
Add interactive controls | ||
Data Modeling | ||
Conceptual, Logical and 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) | ||
MongoImport and MongoExport | ||
Data Manipulation | ||
Data Transfer (Same or cross server type) | ||
Data/Structure Synchronization | ||
Pub/Sub | ||
Subscribe/unsubscribe channels | ||
Customize channel colorings | ||
Save as profile | ||
Archive messages | ||
Backup/Restore | ||
Backup/restore MySQL/MariaDB/PostgreSQL/Redis/SQLite database | ||
Convert backup file into SQL script | ||
MongoDump and MongoRestore | ||
Oracle Data Pump | ||
SQL Server Backup/Restore | ||
Dump/Execute SQL file | ||
Execute Redis Command File | ||
Automation | ||
Set schedule on backup, MongoDump, MongoImport, MongoExport, MapReduce, 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 | ||
Command Monitor | ||
Other Useful Features | ||
Data Generation | ||
Schema Analysis | ||
ER Diagram view | ||
Virtual grouping | ||
Customize connection colorings | ||
Database wide search | ||
Favorites list | ||
Print database/schema/table structure | ||
Dark mode |
General
MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server |
Enterprise Essentials |
MariaDB 5.1 or later |
Enterprise Essentials |
MongoDB 3.0 or later |
Enterprise Essentials |
Redis 2.8 or later, Redis Cluster |
Enterprise Essentials |
Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) |
Enterprise Essentials |
PostgreSQL 7.3 or later |
Enterprise Essentials |
SQLite 2 and 3 |
Enterprise Essentials |
SQL Server 2000 or later |
Enterprise Essentials |
OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode not available in macOS Edition) |
Enterprise Essentials |
Amazon RDS, Amazon Aurora, Amazon Redshift, Amazon ElastiCache, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas, Huawei Cloud |
Enterprise Essentials |
Connection
Secure connection: SSH/HTTP/SSL |
Enterprise Essentials |
PAM and GSSAPI authentication |
Enterprise Essentials |
Kerberos and LDAP authentication |
Enterprise Essentials |
x.509 certificate authentication |
Enterprise Essentials |
Connection profiles |
Enterprise Essentials |
Export/import connection settings |
Enterprise Essentials |
Navicat Collaboration
Collaboration: create projects, add members |
Enterprise Essentials |
Synchronize connections and queries |
Enterprise Essentials |
Synchronize charts, models, snippets and virtual groups |
Enterprise |
Data Viewer and Editor
Grid view, Tree view and JSON view |
Enterprise Essentials |
Form view |
Enterprise |
Foreign key data selection |
Enterprise |
Text, Hex, Image, Web or BFile viewer/editor |
Enterprise Essentials |
Raw mode editing |
Enterprise Essentials |
Data Validation |
Enterprise Essentials |
Customize data type colorings |
Enterprise Essentials |
Find and replace |
Enterprise Essentials |
Filter records |
Enterprise Essentials |
SQL/Script Processing
PL/SQL and PL/PGSQL Debugger |
Enterprise |
SQL/Script Editor |
Enterprise Essentials |
Visual SQL/Script Builder |
Enterprise |
Find Builder |
Enterprise |
Aggregate Builder |
Enterprise |
Code Snippet and Completion |
Enterprise |
SQL/Script Beautifier and Minifier |
Enterprise |
Find and replace |
Enterprise Essentials |
Create parameter queries |
Enterprise Essentials |
Open query files in an external editor |
Enterprise Essentials |
Console |
Enterprise Essentials |
Data Visualization
Support 20 chart types |
Enterprise |
Visualize live data |
Enterprise |
Customized fields |
Enterprise |
Customize multiple pages dashboard |
Enterprise |
Add interactive controls |
Enterprise |
Data Modeling
Conceptual, Logical and 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 Essentials |
Import/export data from/to most popular formats: DBF etc |
Enterprise |
Import data from ODBC, MS Excel, MS Access |
Enterprise |
Export data to MS Excel, HTML |
Enterprise |
Export data to MS Access (Windows Edition only) |
Enterprise |
MongoImport and MongoExport |
Enterprise Essentials |
Data Manipulation
Data Transfer (Same or cross server type) |
Enterprise |
Data/Structure Synchronization |
Enterprise |
Pub/Sub
Subscribe/unsubscribe channels |
Enterprise |
Customize channel colorings |
Enterprise |
Save as profile |
Enterprise |
Archive messages |
Enterprise |
Backup/Restore
Backup/restore MySQL/MariaDB/PostgreSQL/Redis/SQLite database |
Enterprise |
Convert backup file into SQL script |
Enterprise |
MongoDump and MongoRestore |
Enterprise Essentials |
Oracle Data Pump |
Enterprise |
SQL Server Backup/Restore |
Enterprise |
Dump/Execute SQL file |
Enterprise Essentials |
Execute Redis Command File |
Enterprise Essentials |
Automation
Set schedule on backup, MongoDump, MongoImport, MongoExport, MapReduce, query execution, import/export, data transfer and data synchronization |
Enterprise |
Run profiles from different servers in a single batch job |
Enterprise |
Include attachment for export file in notification email |
Enterprise |
Server Security
Manage user |
Enterprise Essentials |
Server Monitor |
Enterprise |
Command Monitor |
Enterprise |
Other Useful Features
Data Generation |
Enterprise |
Schema Analysis |
Enterprise |
ER Diagram view |
Enterprise |
Virtual grouping |
Enterprise |
Customize connection colorings |
Enterprise Essentials |
Database wide search |
Enterprise |
Favorites list |
Enterprise |
Print database/schema/table structure |
Enterprise |
Dark mode |
Enterprise Essentials |