Essentials Enterprise

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