Navicat Premium is a database development tool that allows you to simultaneously connect to MySQL, MariaDB, SQL Server, Oracle, PostgreSQL, and SQLite databases from a single application. Compatible with cloud databases like Amazon RDS, Amazon Aurora, Amazon Redshift, SQL Azure, Oracle Cloud and Google Cloud. You can quickly and easily build, manage and maintain your databases.

Windows
Mac OS X
1
2
3
4
5
6
7
8
9
10

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.

Modeling

Visualize and edit your databases using a sophisticated database design and modeling tool.

Data Synchronization

Compare and sync data between databases/schemas with a detailed analytical process.

Structure Synchronization

Deliver a full picture of database differences, and generate script to update the destination database.

Code Completion

Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.

Code Snippet

Insert a snippet into the SQL Editor for faster and error-free SQL writing.

Automation

Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.

Navicat Cloud

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

Features

Seamless Data Migration

Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.

Diversified Manipulation Tool

Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.

Easy SQL Editing

Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/SQL and PL/PGSQL coding errors using our debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.

Intelligent Database Designer

Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.

Increase your Productivity

Our powerful local backup/restore solution and intuitive GUI for Oracle Data Pump/SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Compile professional high-quality reports in minutes using an interactive design interface and efficient workflow, and set an automation for repeatable deployment process like report generation, database backup, and script execution at a specific time or day. No matter where you are, you can always get the job done.

Make Collaboration Easy

Synchronize your connection settings, models, queries and virtual groups 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
6
7
8
9
10

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.

Modeling

Visualize and edit your databases using a sophisticated database design and modeling tool.

Data Synchronization

Compare and sync data between databases/schemas with a detailed analytical process.

Structure Synchronization

Deliver a full picture of database differences, and generate script to update the destination database.

Code Completion

Construct SQL statements in the SQL Editor by picking the suggestions from the drop-down list.

Code Snippet

Insert a snippet into the SQL Editor for faster and error-free SQL writing.

Automation

Create and schedule a batch job for your daily tasks, and get notification e-mails upon tasks completion.

Navicat Cloud

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

Features

Seamless Data Migration

Data Transfer, Data Synchronization and Structure Synchronization help you migrate your data easier and faster for less overhead. Deliver detailed, step-by-step guidelines for transferring data across various DBMS. Compare and synchronize databases with Data and Structure Synchronization. Set up and deploy the comparisons in seconds, and get the detailed script to specify the changes you want to execute.

Diversified Manipulation Tool

Use Import Wizard to transfer data into a database from diverse formats, or from ODBC after setting up a data source connection. Export data from tables, views, or query results to formats like Excel, Access, CSV and more. Add, modify, and delete records with our spreadsheet-like Grid View together with an array of data editing tools to facilitate your edits. Navicat gives you the tools you need to manage your data efficiently and ensure a smooth process.

Easy SQL Editing

Visual SQL Builder will help you create, edit and run SQL statements without having to worry about syntax and proper usage of commands. Code fast with Code Completion and customizable Code Snippet by getting suggestions for keywords and stripping the repetition from coding. Quickly locate and correct PL/SQL and PL/PGSQL coding errors using our debugging component such as setting breakpoints, stepping through the program, viewing and modifying variable values, and examining the call stack.

Intelligent Database Designer

Create, modify and manage all database objects using our professional object designers. Convert your databases into graphical representations using a sophisticated database design and modeling tool so you can model, create, and understand complex databases with ease.

Increase your Productivity

Our powerful local backup/restore solution and intuitive GUI for Oracle Data Pump/SQL Server Backup Utility guides you through the backup process and reduces the potential for errors. Set an automation for repeatable deployment process like database backup and script execution at a specific time or day. No matter where you are, you can always get the job done.

Make Collaboration Easy

Synchronize your connection settings, models, queries and virtual groups 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