Navicat Black Friday Get 30% off

Save now
More info
  Lite Enterprise

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
Save now

*Promotion ends 2 Dec, 2024 (23:59 ET)
*Valid for new Navicat perpetual licenses