|
Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, Redis, PostgreSQL, SQL Server, Oracle, MariaDB, SQLite, and MongoDB databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, Amazon ElastiCache, Microsoft Azure, Oracle Cloud, Google Cloud, MongoDB Atlas and Redis Enterprise Cloud. Additionally, Navicat Premium is compatible with GaussDB and OceanBase databases. You can quickly and easily build, manage and maintain your databases.
|
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
|
✔
|
✔
|
|
|
System Requirements
|
Windows
Windows
7, Windows 8, Windows 8.1, Windows 10, Windows 11, Server 2012, Server 2016,
Server 2019, Server 2022
|
|
macOS
macOS
10.14 Mojave, macOS 10.15 Catalina, macOS 11 Big Sur, macOS 12 Monterey,
macOS 13 Ventura, macOS 14 Sonoma
|
|
Linux
Debian
9, Debian 10, Debian 11, Ubuntu 18.04, Ubuntu 20.04, Ubuntu 22.04, Fedora 33,
Fedora 34, Fedora 35, Linux Mint 19, Linux Mint 20, Linux Mint 21, Deepin 20,
KylinOS Desktop 10
|
|