Feature Matrix
| Lite | Standard | 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 | | | |
| Snowflake | | | |
| Amazon AWS, Microsoft Azure, Google Cloud, Oracle Cloud, MongoDB Atlas, Redis Enterprise Cloud, Alibaba Cloud ApsaraDB, Alibaba Cloud PolarDB for MySQL/PostgreSQL, Tencent Cloud, Huawei Cloud | | | |
| OceanBase 3.1.0 or later (1), TiDB 7 or later, Fujitsu Enterprise Postgres 9.5 or later, Dameng 8 or later (2), KingbaseES V8R6 or later, IvorySQL 1 or later, Microsoft Garnet, openGauss, Alibaba Cloud ApsaraDB for OceanBase, Alibaba Cloud PolarDB for Xscale, Huawei Cloud GaussDB (2) (1) Enterprise Oracle Mode not available in macOS Edition (2) Windows and Linux Edition only | | ||
| 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 | | | |
| Synchronize personal profile | | | |
| 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 | | | |
| Session history | | | |
| Query Processing | |||
| Query editor with syntax highlight, SQL beautifier and minifier | | | |
| Refactoring | | | |
| Code intelligence (code completion, live error checking, hover tooltips, usage tracking, and declaration lookups) | | | |
| Code snippet | | | |
| Query builder | | | |
| Find builder | | | |
| Aggregate builder | | | |
| Visual explain | | | |
| Pin query result | | | |
| Find and replace | | | |
| Create parameter queries | | | |
| Console | | | |
| Object Designer | |||
| Database object design tools | | | |
| PL/SQL and PL/PGSQL debugger | | | |
| View builder | | | |
| SQL preview | | | |
| AI Chat | |||
| Attach database structures | | | |
| Compare and contrast responses from multiple AI models | | | |
| Send AI code to query editor | | | |
| Multiple chat rooms | | | |
| Chat forking | | | |
| Ask AI | |||
| Design table schemas and model | | | |
| Generate table comments (Fill with AI) | | | |
| Fill data contextually (Fill with AI) | | | |
| Explain SQL queries | | | |
| Tune and optimize SQL queries | | | |
| Format and beautify SQL queries | | | |
| Convert SQL queries for different databases | | | |
| Customize and pin AI actions for quick access | | | |
| Find and fix SQL errors | | | |
| BI | |||
| Over 20 chart type options | | ||
| Visualize live data | | ||
| Customized fields | | ||
| Dashboard layout (auto-tile, alignment guides) | | ||
| Customize multiple pages dashboard | | ||
| Interactive controls and global parameters | | ||
| Auto refresh & present mode | | ||
| Model | |||
| Hybrid, conceptual, logical and physical model | | ||
| Relational, dimensional and data vault 2.0 model method | | ||
| Naming standards & glossary | | ||
| Bulk schema editing | | ||
| Diagramming & graphic tools | | ||
| Reverse engineering (reverse database to model, synchronize database to model, import SQL file to model) | | ||
| Forward engineering (synchronize model to database, export model to SQL/script file) | | ||
| Compare model workspaces | | ||
| Convert model | | ||
| 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, Parquet | | | |
| Export data to MS Excel, DBF, Parquet | | | |
| 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 masking | | | |
| 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 masking, 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  Standard  Lite |
| PostgreSQL 7.3 or later | Enterprise Standard Lite |
| SQL Server 2000 or later | Enterprise Standard Lite |
| Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) | Enterprise Standard Lite |
| SQLite 2 and 3 | Enterprise Standard Lite |
| MariaDB 5.1 or later | Enterprise Standard Lite |
| MongoDB 3.0 or later | Enterprise Standard Lite |
| Redis 2.8 or later, Redis Cluster, Redis Sentinel | Enterprise Standard Lite |
| Snowflake | Enterprise Standard Lite |
| Amazon AWS, Microsoft Azure, Google Cloud, Oracle Cloud, MongoDB Atlas, Redis Enterprise Cloud, Alibaba Cloud ApsaraDB, Alibaba Cloud PolarDB for MySQL/PostgreSQL, Tencent Cloud, Huawei Cloud | Enterprise Standard Lite |
| OceanBase 3.1.0 or later (1), TiDB 7 or later, Fujitsu Enterprise Postgres 9.5 or later, Dameng 8 or later (2), KingbaseES V8R6 or later, IvorySQL 1 or later, Microsoft Garnet, openGauss, Alibaba Cloud ApsaraDB for OceanBase, Alibaba Cloud PolarDB for Xscale, Huawei Cloud GaussDB (2) (1) Enterprise Oracle Mode not available in macOS Edition (2) Windows and Linux Edition only |
Enterprise Standard |
Connection
| Secure connection: SSH, HTTP Tunnel and SSL/TLS | Enterprise Standard Lite |
| PAM authentication | Enterprise Standard Lite |
| LDAP authentication | Enterprise Standard Lite |
| Kerberos authentication | Enterprise Standard |
| SQL Server Windows Authentication/Active Directory (Windows Edition only) | Enterprise Standard Lite |
| Centralized connection management | Enterprise Standard Lite |
| Connection profiles | Enterprise Standard Lite |
| Customize connection colorings | Enterprise Standard Lite |
| Export/import connection settings | Enterprise Standard Lite |
Navicat Collaboration
| Collaboration: create projects, add members | Enterprise Standard Lite |
| Synchronize connection settings, queries, snippets and virtual group information | Enterprise Standard Lite |
| Synchronize BI workspaces and model workspaces | Enterprise Standard |
| Synchronize aggregation pipelines | Enterprise Standard |
| Synchronize personal profile | Enterprise Standard Lite |
Data Viewer and Editor
| Grid view | Enterprise Standard Lite |
| Form view | Enterprise Standard |
| Data profiling | Enterprise Standard |
| Text, hex, image, web or BFile viewer and editor | Enterprise Standard Lite |
| Foreign key data selection | Enterprise Standard |
| Filter and sort | Enterprise Standard Lite |
| Table profile | Enterprise Standard |
| Find and replace | Enterprise Standard Lite |
| Tree view and JSON view | Enterprise Standard Lite |
| Customize data type colorings | Enterprise Standard Lite |
| Session history | Enterprise Standard Lite |
Query Processing
| Query editor with syntax highlight, SQL beautifier and minifier | Enterprise Standard Lite |
| Refactoring | Enterprise Standard |
| Code intelligence (code completion, live error checking, hover tooltips, usage tracking, and declaration lookups) | Enterprise Standard Lite |
| Code snippet | Enterprise Standard Lite |
| Query builder | Enterprise Standard |
| Find builder | Enterprise Standard |
| Aggregate builder | Enterprise Standard |
| Visual explain | Enterprise Standard |
| Pin query result | Enterprise Standard |
| Find and replace | Enterprise Standard Lite |
| Create parameter queries | Enterprise Standard Lite |
| Console | Enterprise Standard Lite |
Object Designer
| Database object design tools | Enterprise Standard Lite |
| PL/SQL and PL/PGSQL debugger | Enterprise Standard |
| View builder | Enterprise Standard |
| SQL preview | Enterprise Standard Lite |
AI Chat
| Attach database structures | Enterprise Standard |
| Compare and contrast responses from multiple AI models | Enterprise Standard |
| Send AI code to query editor | Enterprise Standard |
| Multiple chat rooms | Enterprise Standard |
| Chat forking | Enterprise Standard |
Ask AI
| Design table schemas and model | Enterprise Standard |
| Generate table comments (Fill with AI) | Enterprise Standard |
| Fill data contextually (Fill with AI) | Enterprise Standard |
| Explain SQL queries | Enterprise Standard |
| Tune and optimize SQL queries | Enterprise Standard |
| Format and beautify SQL queries | Enterprise Standard |
| Convert SQL queries for different databases | Enterprise Standard |
| Customize and pin AI actions for quick access | Enterprise Standard |
| Find and fix SQL errors | Enterprise Standard |
BI
| Over 20 chart type options | Enterprise Standard |
| Visualize live data | Enterprise Standard |
| Customized fields | Enterprise Standard |
| Dashboard layout (auto-tile, alignment guides) | Enterprise Standard |
| Customize multiple pages dashboard | Enterprise Standard |
| Interactive controls and global parameters | Enterprise Standard |
| Auto refresh & present mode | Enterprise Standard |
Model
| Hybrid, conceptual, logical and physical model | Enterprise Standard |
| Relational, dimensional and data vault 2.0 model method | Enterprise Standard |
| Naming standards & glossary | Enterprise Standard |
| Bulk schema editing | Enterprise Standard |
| Diagramming & graphic tools | Enterprise Standard |
| Reverse engineering (reverse database to model, synchronize database to model, import SQL file to model) | Enterprise Standard |
| Forward engineering (synchronize model to database, export model to SQL/script file) | Enterprise Standard |
| Compare model workspaces | Enterprise Standard |
| Convert model | Enterprise Standard |
| Print database diagrams to PDF and graphic files | Enterprise Standard |
Import and Export
| Import/export data from/to plain text file formats: TXT, CSV, XML, JSON | Enterprise Standard Lite |
| Import data from ODBC, MS Excel, MS Access, DBF, Parquet | Enterprise Standard |
| Export data to MS Excel, DBF, Parquet | Enterprise Standard |
| Export data to MS Access (Windows Edition only) | Enterprise Standard |
| MongoImport and MongoExport | Enterprise Standard Lite |
Structure and Data Manipulation
| Structure synchronization | Enterprise Standard |
| Data transfer (Same or cross server type) | Enterprise Standard |
| Data synchronization | Enterprise Standard |
| Data generation | Enterprise Standard |
| Data masking | Enterprise Standard |
| Data dictionary | Enterprise Standard |
| Copy and paste data across databases | Enterprise Standard |
Backup and Restore
| Backup/restore MySQL/MariaDB/PostgreSQL/Redis/SQLite database | Enterprise Standard |
| Convert backup file into SQL script | Enterprise Standard |
| MongoDump and MongoRestore | Enterprise Standard Lite |
| Oracle Data Pump | Enterprise Standard |
| SQL Server Backup/Restore | Enterprise Standard |
| Dump/execute SQL file | Enterprise Standard Lite |
| Execute Redis command file | Enterprise Standard Lite |
Automation
| Set schedule on : query, backup, data transfer, data synchronization, data generation, data masking, data dictionary, aggregation pipeline, BI, model, import, export, MongoDump, MongoImport, MongoExport, MapReduce | 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 Lite |
| Server monitor | Enterprise Standard |
| Command monitor | Enterprise Standard |
Other Useful Features
| ER diagram view | Enterprise Standard |
| Open object via URI | Enterprise Standard Lite |
| Aggregation pipeline | Enterprise Standard |
| Schema analysis | Enterprise Standard |
| Pub/Sub | Enterprise Standard |
| Virtual grouping | Enterprise Standard Lite |
| Database wide search | Enterprise Standard |
| Favorites list | Enterprise Standard |
| Focus mode | Enterprise Standard |
| Dark mode | Enterprise Standard Lite |
