Feature Matrix
| Lite | Enterprise | |
| General | ||
| MySQL 3.21 or later |  |  |
| PostgreSQL 7.3 or later | | |
| SQL Server 2000 or later | | |
| Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) | | |
| SQLite 2 and 3 | | |
| MariaDB 5.1 or later | | |
| MongoDB 3.0 or later | | |
| Redis 2.8 or later, Redis Cluster, Redis Sentinel, Microsoft Garnet | | |
| OceanBase 3.1.0 or later ( Enterprise Oracle Mode not available in macOS Edition ), GaussDB 3.2 or later ( Windows and Linux Edition only ), TiDB 7 or later | | |
| Amazon AWS, Microsoft Azure, Google Cloud, Oracle Cloud, MongoDB Atlas, Redis Enterprise Cloud, Alibaba Cloud, Tencent Cloud, Huawei Cloud | | |
| Connection | ||
| Secure connection: SSH, HTTP Tunnel and SSL/TLS | | |
| PAM authentication | | |
| LDAP authentication | | |
| Kerberos authentication | | |
| SQL Server Windows Authentication/Active Directory (Windows Edition only) | | |
| 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 | | |
| Synchronize aggregation pipelines | | |
| Data Viewer and Editor | ||
| Grid view | | |
| Form view | | |
| Data profiling | | |
| Text, hex, image, web or BFile viewer and editor | | |
| Foreign key data selection | | |
| Filter and sort | | |
| Table profile | | |
| Find and replace | | |
| Tree view and JSON view | | |
| Customize data type colorings | | |
| Query Processing | ||
| Query editor with syntax highlight | | |
| Code completion | | |
| Code snippet | | |
| Query builder | | |
| Find builder | | |
| Aggregate builder | | |
| Visual explain | | |
| Pin query result | | |
| SQL beautifier and minifier | | |
| Find and replace | | |
| Create parameter queries | | |
| Console | | |
| Object Designer | ||
| Database object design tools | | |
| PL/SQL and PL/PGSQL debugger | | |
| 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 | ||
| Conceptual, logical and 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) | | |
| MongoImport and MongoExport | | |
| Structure and Data Manipulation | ||
| Structure synchronization | | |
| Data transfer (Same or cross server type) | | |
| Data synchronization | | |
| Data generation | | |
| Data dictionary | | |
| Copy and paste data across databases | | |
| Backup and 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 : query, backup, data transfer, data synchronization, data generation, data dictionary, aggregation pipeline, BI, model, import, export, MongoDump, MongoImport, MongoExport, MapReduce | | |
| 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 | ||
| ER diagram view | | |
| Open object via URI | | |
| Aggregation pipeline | | |
| Schema analysis | | |
| Pub/Sub | | |
| Virtual grouping | | |
| Database wide search | | |
| Favorites list | | |
| Focus mode | | |
| Dark mode | | |
General
| MySQL 3.21 or later |
Enterprise  Lite  |
| PostgreSQL 7.3 or later |
Enterprise Lite |
| SQL Server 2000 or later |
Enterprise Lite |
| Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) |
Enterprise Lite |
| SQLite 2 and 3 |
Enterprise Lite |
| MariaDB 5.1 or later |
Enterprise Lite |
| MongoDB 3.0 or later |
Enterprise Lite |
| Redis 2.8 or later, Redis Cluster, Redis Sentinel, Microsoft Garnet |
Enterprise Lite |
| OceanBase 3.1.0 or later ( Enterprise Oracle Mode not available in macOS Edition ), GaussDB 3.2 or later ( Windows and Linux Edition only ), TiDB 7 or later |
Enterprise Lite |
| Amazon AWS, Microsoft Azure, Google Cloud, Oracle Cloud, MongoDB Atlas, Redis Enterprise Cloud, Alibaba Cloud, Tencent Cloud, Huawei Cloud |
Enterprise Lite |
Connection
| Secure connection: SSH, HTTP Tunnel and SSL/TLS |
Enterprise Lite |
| PAM authentication |
Enterprise Lite |
| LDAP authentication |
Enterprise Lite |
| Kerberos authentication |
Enterprise |
| SQL Server Windows Authentication/Active Directory (Windows Edition only) |
Enterprise Lite |
| Centralized connection management |
Enterprise Lite |
| Connection profiles |
Enterprise Lite |
| Customize connection colorings |
Enterprise Lite |
| Export/import connection settings |
Enterprise Lite |
Navicat Collaboration
| Collaboration: create projects, add members |
Enterprise Lite |
| Synchronize connection settings, queries, snippets and virtual group information |
Enterprise Lite |
| Synchronize BI workspaces and model workspaces |
Enterprise |
| Synchronize aggregation pipelines |
Enterprise |
Data Viewer and Editor
| Grid view |
Enterprise Lite |
| Form view |
Enterprise |
| Data profiling |
Enterprise |
| Text, hex, image, web or BFile viewer and editor |
Enterprise Lite |
| Foreign key data selection |
Enterprise |
| Filter and sort |
Enterprise Lite |
| Table profile |
Enterprise |
| Find and replace |
Enterprise Lite |
| Tree view and JSON view |
Enterprise Lite |
| Customize data type colorings |
Enterprise Lite |
Query Processing
| Query editor with syntax highlight |
Enterprise Lite |
| Code completion |
Enterprise Lite |
| Code snippet |
Enterprise Lite |
| Query builder |
Enterprise |
| Find builder |
Enterprise |
| Aggregate builder |
Enterprise |
| Visual explain |
Enterprise |
| Pin query result |
Enterprise |
| SQL beautifier and minifier |
Enterprise Lite |
| Find and replace |
Enterprise Lite |
| Create parameter queries |
Enterprise Lite |
| Console |
Enterprise Lite |
Object Designer
| Database object design tools |
Enterprise Lite |
| PL/SQL and PL/PGSQL debugger |
Enterprise |
| View builder |
Enterprise |
| SQL preview |
Enterprise Lite |
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
| Conceptual, logical and 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 Lite |
| Import data from ODBC, MS Excel, MS Access, DBF |
Enterprise |
| Export data to MS Excel, DBF |
Enterprise |
| Export data to MS Access (Windows Edition only) |
Enterprise |
| MongoImport and MongoExport |
Enterprise Lite |
Structure and Data Manipulation
| Structure synchronization |
Enterprise |
| Data transfer (Same or cross server type) |
Enterprise |
| Data synchronization |
Enterprise |
| Data generation |
Enterprise |
| Data dictionary |
Enterprise |
| Copy and paste data across databases |
Enterprise |
Backup and Restore
| Backup/restore MySQL/MariaDB/PostgreSQL/Redis/SQLite database |
Enterprise |
| Convert backup file into SQL script |
Enterprise |
| MongoDump and MongoRestore |
Enterprise Lite |
| Oracle Data Pump |
Enterprise |
| SQL Server Backup/Restore |
Enterprise |
| Dump/execute SQL file |
Enterprise Lite |
| Execute Redis command file |
Enterprise Lite |
Automation
| Set schedule on : query, backup, data transfer, data synchronization, data generation, data dictionary, aggregation pipeline, BI, model, import, export, MongoDump, MongoImport, MongoExport, MapReduce |
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 Lite |
| Server monitor |
Enterprise |
| Command monitor |
Enterprise |
Other Useful Features
| ER diagram view |
Enterprise |
| Open object via URI |
Enterprise Lite |
| Aggregation pipeline |
Enterprise |
| Schema analysis |
Enterprise |
| Pub/Sub |
Enterprise |
| Virtual grouping |
Enterprise Lite |
| Database wide search |
Enterprise |
| Favorites list |
Enterprise |
| Focus mode |
Enterprise |
| Dark mode |
Enterprise Lite |
