Standard

Enterprise

Connection

Oracle 8.1 or later ( macOS Edition starts from Oracle 9i )

✔

✔

OceanBase Community and Enterprise 3.1.0 or later

✔

✔

Amazon RDS, Oracle Cloud

✔

✔

Secure connection: SSH

✔

✔

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, BFile or Web viewer/editor

✔

✔

Find and replace

✔

✔

Filter records

✔

✔

SQL Processing

PL/SQL 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

✔

✔

SQL*Plus

✔

✔

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

Oracle Data Pump

✔

✔

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 schema structure

✔

✔

Dark mode

✔

✔