Standard

Enterprise

Connection

MySQL 3.21 or later, Drizzle, OurDelta, and Percona Server

✔

✔

MariaDB 5.1 or later

✔

✔

OceanBase Community and Enterprise 3.1.0 or later

✔

✔

Amazon RDS, Amazon Aurora, Oracle Cloud, Google Cloud, Microsoft Azure, Alibaba Cloud, Tencent Cloud, Huawei Cloud

✔

✔

Secure connection: SSH/HTTP/SSL

✔

✔

PAM 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

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/table structure

✔

✔

Dark mode

✔

✔