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, 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.

Windows
Mac OS X
1
2
3
4
5

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

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

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, SQL Azure, Oracle Cloud, and Google Cloud. 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 spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. 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, and GSSAPI authentication for PostgreSQL. Navicat 12 provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

1
2
3
4
5

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

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

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, SQL Azure, Oracle Cloud, and Google Cloud. 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 spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. 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, and GSSAPI authentication for PostgreSQL. Navicat 12 provides more authentication mechanisms and high-performance environments so you never have to worry about connecting over an insecure network.

System Requirements

Windows

Microsoft Windows 7, Windows 8, Windows 8.1, Windows 10, Server 2008 R2, Server 2012, Server 2016

Mac OS X

Mac OS X 10.10 or later

Linux

Ubuntu 12.04, Ubuntu 14.04, CentOS 6.7, CentOS 7, Fedora 22, Fedora 23, Linux Mint 13, Linux Mint 17.3, openSUSE 13.2, openSUSE 42.1

Our Customers

Jeff Gellner

CISSP JPMorgan
Chase & Co.

“Very professional product. Easy to use. Nice GUI. We use Navicat to produce custom reports based on complex queries.”

Karl Hogerl

Internet & Database Service Engineer TOSHIBA Europe GmbH

“Navicat is strong in that function and it has a good query handling. Especially the query builder helps me to save time.

Navicat has a good user interface and it has perfect multitasking usability.

It helps very much for our department to generate new reports.”

Jan Theodore Galkowski

MIT (Massachusetts Institute of Technology)

“Navicat is fabulous, fast, easy to use. It makes working with databases fun.

It's much better than TOAD.

My favourite features of Navicat are Backup, import/export, basic database functionality, including browsing tables, connections management, toolbar, subdivision of functions, user management, queries, performance.”

Awards