Essentials

Enterprise

Connection

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

✔

✔