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 aggregation pipelines
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 Profiling
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
Visual Explain
Pin query result
Find and replace
Create parameter queries
Open query files in an external editor
Console
BI
Support 20 chart types
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/script file
Compare model workspace
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
Data Dictionary
Schema Analysis
ER Diagram view
Virtual grouping
Customize connection colorings
Database wide search
Favorites list
Open Object via URI
Print database/schema/table structure
Focus Mode
Dark mode
General
MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server Enterprise
MariaDB 5.1 or later Enterprise
MongoDB 3.0 or later Enterprise
Redis 2.8 or later, Redis Cluster Enterprise
Oracle 8.1 or later ( macOS Edition starts from Oracle 9i ) Enterprise
PostgreSQL 7.3 or later Enterprise
SQLite 2 and 3 Enterprise
SQL Server 2000 or later Enterprise
OceanBase Community and Enterprise 3.1.0 or later (Enterprise Oracle Mode not available in macOS Edition) Enterprise
Amazon RDS, Amazon Aurora, Amazon Redshift, Amazon ElastiCache, Microsoft Azure, Oracle Cloud, Google Cloud, Alibaba Cloud, Tencent Cloud, MongoDB Atlas, Huawei Cloud Enterprise
Connection
Secure connection: SSH/HTTP/SSL Enterprise
PAM and GSSAPI authentication Enterprise
Kerberos and LDAP authentication Enterprise
x.509 certificate authentication Enterprise
Connection profiles Enterprise
Export/import connection settings Enterprise
Navicat Collaboration
Collaboration: create projects, add members Enterprise
Synchronize connections and queries Enterprise
Synchronize aggregation pipelines Enterprise
Synchronize charts, models, snippets and virtual groups Enterprise
Data Viewer and Editor
Grid view, Tree view and JSON view Enterprise
Form view Enterprise
Foreign key data selection Enterprise
Text, Hex, Image, Web or BFile viewer/editor Enterprise
Raw mode editing Enterprise
Data Profiling Enterprise
Data Validation Enterprise
Customize data type colorings Enterprise
Find and replace Enterprise
Filter records Enterprise
SQL/Script Processing
PL/SQL and PL/PGSQL Debugger Enterprise
SQL/Script Editor Enterprise
Visual SQL/Script Builder Enterprise
Find Builder Enterprise
Aggregate Builder Enterprise
Code Snippet and Completion Enterprise
SQL/Script Beautifier and Minifier Enterprise
Visual Explain Enterprise
Pin query result Enterprise
Find and replace Enterprise
Create parameter queries Enterprise
Open query files in an external editor Enterprise
Console Enterprise
BI
Support 20 chart types 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/script file Enterprise
Compare model workspace 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
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
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
Oracle Data Pump Enterprise
SQL Server Backup/Restore Enterprise
Dump/Execute SQL file Enterprise
Execute Redis Command File Enterprise
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
Server Monitor Enterprise
Command Monitor Enterprise
Other Useful Features
Data Generation Enterprise
Data Dictionary Enterprise
Schema Analysis Enterprise
ER Diagram view Enterprise
Virtual grouping Enterprise
Customize connection colorings Enterprise
Database wide search Enterprise
Favorites list Enterprise
Open Object via URI Enterprise
Print database/schema/table structure Enterprise
Focus Mode Enterprise
Dark mode Enterprise
We use cookies to ensure its efficient functioning. Read about how we use cookies here. By continuing to use this site, you are giving us your consent to do this.