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
Snowflake
OceanBase 3.1.0 or later ⁽¹⁾, GaussDB 3.2 or later ⁽²⁾, TiDB 7 or later, Fujitsu Enterprise Postgres 9.5 or later, Dameng 8 or later ⁽²⁾, KingbaseES 8 or later, IvorySQL 1 or later (1) Enterprise Oracle Mode not available in macOS Edition (2) Windows and Linux Edition only
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
AI Assistant
ChatGPT, Deepseek, Google Gemini, Ollama, xAI Grok, Anthropic Claude, Alibaba Qwen
Attach database structures
Compare and contrast responses from multiple AI models
Multiple chat rooms
Ask 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
Customize multiple pages dashboard
Add interactive controls
Present mode
Model
Conceptual, logical and physical model
Relational, dimensional and data vault 2.0 model method
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
Snowflake	Enterprise Lite
OceanBase 3.1.0 or later ⁽¹⁾, GaussDB 3.2 or later ⁽²⁾, TiDB 7 or later, Fujitsu Enterprise Postgres 9.5 or later, Dameng 8 or later ⁽²⁾, KingbaseES 8 or later, IvorySQL 1 or later (1) Enterprise Oracle Mode not available in macOS Edition (2) Windows and Linux Edition only	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

AI Assistant

ChatGPT, Deepseek, Google Gemini, Ollama, xAI Grok, Anthropic Claude, Alibaba Qwen	Enterprise
Attach database structures	Enterprise
Compare and contrast responses from multiple AI models	Enterprise
Multiple chat rooms	Enterprise

Ask AI

Explain SQL queries	Enterprise
Tune and optimize SQL queries	Enterprise
Format and beautify SQL queries	Enterprise
Convert SQL queries for different databases	Enterprise
Customize and pin AI actions for quick access	Enterprise
Find and fix SQL errors	Enterprise

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
Relational, dimensional and data vault 2.0 model method	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

What's New

Products

Support
- Manuals
- Videos
- Survey
- Live Support

Account

Partners

About Us
- Company
- Our Customers
- Top 10 Reasons
- Awards
- Press
- Blog

Others