Essentials Standard Enterprise

Feature Matrix

  Essentials Standard Enterprise
Connection
PostgreSQL 7.3 or later
Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud, Microsoft Azure, Alibaba Cloud, Tencent Cloud, Huawei Cloud
Secure connection: SSH/HTTP/SSL
GSSAPI authentication
Connection profiles
Export/import connection settings
Navicat Collaboration
Collaboration: create projects, add members
Synchronize connections and queries
Synchronize charts and models
Synchronize snippets and virtual groups
Data Viewer and Editor
Grid view
Form view
Foreign key data selection
Text, Hex, Image or Web viewer/editor
Raw mode editing
Find and replace
Filter records
SQL Processing
PL/PGSQL Debugger
SQL Editor
Visual SQL Builder
Code Snippet and Completion
SQL Code Beautifier/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
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)
Data Manipulation
Data Transfer
Data/Structure Synchronization
Backup/Restore
Backup/restore database
Convert backup file into SQL script
Dump/Execute SQL file
Automation
Set schedule on backup, 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
Other Useful Features
Data Generation
ER Diagram view
Virtual grouping
Customize connection colorings
Database wide search
Favorites list
Print database/schema/table structure
Dark mode
Connection
PostgreSQL 7.3 or later Enterprise
Standard
Essentials
Amazon Redshift, Amazon Aurora, Amazon RDS, Google Cloud, Microsoft Azure, Alibaba Cloud, Tencent Cloud, Huawei Cloud Enterprise
Standard
Essentials
Secure connection: SSH/HTTP/SSL Enterprise
Standard
Essentials
GSSAPI authentication Enterprise
Standard
Essentials
Connection profiles Enterprise
Standard
Essentials
Export/import connection settings Enterprise
Standard
Essentials
Navicat Collaboration
Collaboration: create projects, add members Enterprise
Standard
Essentials
Synchronize connections and queries Enterprise
Standard
Essentials
Synchronize charts and models Enterprise
Synchronize snippets and virtual groups Enterprise
Standard
Data Viewer and Editor
Grid view Enterprise
Standard
Essentials
Form view Enterprise
Standard
Foreign key data selection Enterprise
Standard
Text, Hex, Image or Web viewer/editor Enterprise
Standard
Essentials
Raw mode editing Enterprise
Standard
Essentials
Find and replace Enterprise
Standard
Essentials
Filter records Enterprise
Standard
Essentials
SQL Processing
PL/PGSQL Debugger Enterprise
Standard
SQL Editor Enterprise
Standard
Essentials
Visual SQL Builder Enterprise
Standard
Code Snippet and Completion Enterprise
Standard
SQL Code Beautifier/Minifier Enterprise
Standard
Find and replace Enterprise
Standard
Essentials
Create parameter queries Enterprise
Standard
Essentials
Open query files in an external editor Enterprise
Standard
Essentials
Console Enterprise
Standard
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
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
Standard
Essentials
Import/export data from/to most popular formats: DBF etc Enterprise
Standard
Import data from ODBC, MS Excel, MS Access Enterprise
Standard
Export data to MS Excel, HTML Enterprise
Standard
Export data to MS Access (Windows Edition only) Enterprise
Standard
Data Manipulation
Data Transfer Enterprise
Standard
Data/Structure Synchronization Enterprise
Standard
Backup/Restore
Backup/restore database Enterprise
Standard
Convert backup file into SQL script Enterprise
Standard
Dump/Execute SQL file Enterprise
Standard
Essentials
Automation
Set schedule on backup, query execution, import/export, data transfer and data synchronization 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
Essentials
Server Monitor Enterprise
Standard
Other Useful Features
Data Generation Enterprise
Standard
ER Diagram view Enterprise
Standard
Virtual grouping Enterprise
Standard
Customize connection colorings Enterprise
Standard
Essentials
Database wide search Enterprise
Standard
Favorites list Enterprise
Standard
Print database/schema/table structure Enterprise
Standard
Dark mode Enterprise
Standard
Essentials