1. Navicat Premium Essentials Plus
2. Navicat Premium Essentials Pro

Navicat Essentials Premium Navicat Essentials is a compact version of Navicat which provides the basic and necessary features you will need to perform simple database development. Navicat Essentials is for commercial use and is available for MySQL, MariaDB, MongoDB, SQL Server, PostgreSQL, Oracle, and SQLite databases. Buy Navicat Essentials in Navicat online store. The Navicat Site License Program (SLP) allows corporations or institutions the right to use a specific number of Navicat licenses concurrently in one physical location.

Navicat Essentials is a compact version of Navicat which provides the basic and necessary features you will need to perform simple database development. Navicat Essentials is for commercial use and is available for MySQL, MariaDB, MongoDB, SQL Server, PostgreSQL, Oracle, and SQLite databases. If you need to administer all aforementioned database servers at the same time, there is also Navicat Premium Essentials which allows you to access multiple servers from a single application.

Main Screen

Intuitive and well-designed GUI simplifies your database administration and development.

Object Designer

Manage all the database objects with smart object designer.

Data Manipulation for RDBMS

Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.

Data Manipulation for MongoDB

Insert, edit, or delete data using our various data editors.

Import/Export

Navicat Premium Essentials Plus

Import/export data from/to plain text file formats.

Navicat Cloud

Store your files in cloud to start collaboration with your team members.

Features

The All-New Engine

We focus strongly on improving responsiveness, usability, and performance. We engineered an entirely new mechanism and applied multithreading, so you can run certain tasks in parallel to increase the overall efficiency of your database development.

Cloud Database Navigation

Manage both on-premises and cloud databases such as Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. Just simply establish connection using the pertinent information that your cloud databases provide.

Effortless Deployment Toolkit

Add your favorite tabs to On Startup and have them open automatically when Navicat launches, and use MacBook Pro Touch Bar to easily access Navicat features and controls.

Diversified Manipulation Tool

Use Import/Export Wizard to have data conversion from plain text formats such as TXT, CSV, XML and JSON. Add, modify, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat Essentials gives you the tools you need to manage your data efficiently and ensure a smooth process.

Make Collaboration Easy

Synchronize your connection settings and queries to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >

Advanced Secure Connection

Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.

Dark Mode

Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.

Main Screen

Intuitive and well-designed GUI simplifies your database administration and development.

Object Designer

Manage all the database objects with smart object designer.

Data Manipulation for RDBMS

Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.

Data Manipulation for MongoDB

Insert, edit, or delete data using our various data editors.

Import/Export

Import/export data from/to plain text file formats.

Navicat Cloud

Store your files in cloud to start collaboration with your team members.

Features

We focus strongly on improving responsiveness, usability, and performance. We engineered an entirely new mechanism and applied multithreading, so you can run certain tasks in parallel to increase the overall efficiency of your database development.

Manage both on-premises and cloud databases such as Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. Just simply establish connection using the pertinent information that your cloud databases provide.

Add your favorite tabs to On Startup and have them open automatically when Navicat launches, and use MacBook Pro Touch Bar to easily access Navicat features and controls.

Use Import/Export Wizard to have data conversion from plain text formats such as TXT, CSV, XML and JSON. Add, modify, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat Essentials gives you the tools you need to manage your data efficiently and ensure a smooth process.

Synchronize your connection settings and queries to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >

Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

Navicat Premium Essentials Pro

Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.

Dark Mode

Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.

Main Screen

Intuitive and well-designed GUI simplifies your database administration and development.

Object Designer

Manage all the database objects with smart object designer.

Data Manipulation for RDBMS

Insert, edit, delete or copy/paste a data entry into our spreadsheet-like data editor.

Data Manipulation for MongoDB

Insert, edit, or delete data using our various data editors.

Import/Export

Import/export data from/to plain text file formats.

Navicat Cloud

Store your files in cloud to start collaboration with your team members.

Features

The All-New Engine

We focus strongly on improving responsiveness, usability, and performance. We engineered an entirely new mechanism and applied multithreading, so you can run certain tasks in parallel to increase the overall efficiency of your database development.

Cloud Database Navigation

Manage both on-premises and cloud databases such as Amazon RDS, Amazon Aurora, Amazon Redshift, Microsoft Azure, Oracle Cloud, Google Cloud and MongoDB Atlas. Just simply establish connection using the pertinent information that your cloud databases provide.

Effortless Deployment Toolkit

Add your favorite tabs to On Startup and have them open automatically when Navicat launches, and use MacBook Pro Touch Bar to easily access Navicat features and controls.

Diversified Manipulation Tool

Use Import/Export Wizard to have data conversion from plain text formats such as TXT, CSV, XML and JSON. Add, modify, and delete records with our built-in editors, you can facilitate your edits in Tree View, JSON View, and the classic spreadsheet-like Grid View. Navicat Essentials gives you the tools you need to manage your data efficiently and ensure a smooth process.

Make Collaboration Easy

Synchronize your connection settings and queries to our Navicat Cloud service so you can get real-time access to them, and share them with your coworkers anytime and anywhere. With Navicat Cloud, you can leverage every minute of your day to maximize your productivity. Learn more >

Advanced Secure Connection

Establish secure connections through SSH Tunneling and SSL ensure every connection is secure, stable, and reliable. Support different authentication methods of database servers such as PAM authentication for MySQL and MariaDB, Kerberos and X.509 authentication for MongoDB, and GSSAPI authentication for PostgreSQL. Navicat provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

Cross-platform licensing is now available. Whether you’re operating on Windows, macOS, or Linux, you can purchase once and select a platform to activate and later on transfer your license.

Dark Mode

Set dark theme to protect your eyes from the traditionally blinding whiteness of computer. No behavior changes with how pages look when you are in dark mode.

Download/CD Version

ORACLE_HOME
Location of ORACLE_HOME for full client only. Instant client should leave it blank.

DYLD_LIBRARY_PATH
Location of the path which contains Oracle libraries for instant client and SQL*Plus (e.g. ORACLE_HOME/lib). Always required.

Use bundled instant client
Oracle Instant Client has already included in Navicat installation folder. Check this option to use the included one in Navicat installation folder, e.g. /Applications/Navicat Premium.app/Contents/OCI.

Oracle Instant Client is the simplest way to deploy a full Oracle Client application built with OCI, OCCI, JDBC-OCI, or ODBC drivers. It provides the necessary Oracle Client libraries in a small set of files. It provides the necessary Oracle Client libraries in a small set of files. You can also download Oracle Instant Client through -

Oracle Instant Client
http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html

Download the appropriate Instant Client packages for your platform and the CPU. All installations REQUIRE the Basic or Basic Lite package. Unzip the packages and set the path points to it.

TNS_ADMIN
Location of the tnsnames.ora file (e.g. ORACLE_HOME/network/admin). It is optional. Required when using TNS connection.

Note: To change the path settings, you need to click the lock and enter your OS username and password to unlock the control. If you lock it back after changes, a dialog will be prompted to ask whether you want to save the settings. If you click OK after changes, it will just save without prompting any dialogs. If you wait until the lock timeout (300 seconds) after changes, your changes will be reverted.

Note: Available only for Oracle.

Hint: Restart Navicat to take effect.

App Store Version

This tab is removed from the App Store's version. To change the paths in App Store's version, please launch the application through Terminal and type the environment variables.

Before running the command, you need to copy the tnsnames.ora file and instant client to: