Navicat Premium allows you to perform multiple server administration to MySQL, Oracle and PostgreSQL databases from a single interface. It combines the functions of other Navicat members and supports most of the features in MySQL, Oracle and PostgreSQL including Function/Procedure, Event, Trigger, View, etc. This is a time saver, and beneficial to any administrator managing multiple servers.

Latest MySQL Versions Support

• Support of MySQL versions from 3.21 or above
• Support all MySQL objects: tables, views, stored procedures/functions and events
• Support all subobjects: fields, indices, foreign keys and triggers
• Support of partitioning
• Support of Unicode / Character Set

• Supports Oracle Servers 8.1 or above
• Support all Oracle objects: tables (Normal, External and Index Organized), views, procedures/functions
• Support all subobjects: fields, indices, foreign keys, uniques, checks and triggers
• Managing directories, tablespaces, public database links and public synonyms
• Managing database links, indices, java, materialized views, materialized view logs, packages, sequences, synonyms, triggers, types, XML Schema and Recycle Bin
• Support of physical attributes
• Support of Unicode/Character Set

• Supports PostgreSQL Servers 7.3 or above
• Support all PostgreSQL objects: tables, views and functions
• Support all subobjects: fields, indices, foreign keys, uniques, checks, rules and triggers
• Managing tablespace, cast and languages
• Managing aggregates, conversions, domains, trigger functions, operators and classes, sequences and types
• Support of character set and Unicode

Cross-servers Data Manipulation Tools

Support of transferring data between servers
Data Transfer allows you to effortlessly transfer data across various database systems. This feature will drastically simplify the process for migrating data.

Additional Connection Options

Support of SSH Tunnel
Establish a secure SSH session through SSH Tunneling in Navicat. Enjoy a strong authentication and secure encrypted communications between two hosts. The authentication method can use a password or public / private key pair.

Instant Navigation Over Database

Show MySQL and PostgreSQL databases as an open state once connection starts
Have your preferable databases opened right after the connection is made. Save your time and work more efficiently!

Dump object definition as sql file
Backup object definition and data with ease by dumping as sql file.

Print Database / Table Structure
Present the database / table definition by printing their structures in Navicat. Understand the respective object structure fully at a glance.

Diversified Import and Export Competence

Import data from TXT, DBF, XML, etc
Import Wizard allows you to import data into a table from diverse format. On top of that, you can save your settings as an import profile for setting schedule.

Powerful Security Management

Visual User Manager
Navicat provides users a visual tool for user management. You can easily add, duplicate, delete users, and edit global user privileges, and grant privileges on the selected databases and objects.

Well-Designed Visual Builder / Editor

Visual Query / View Builder
Visual Query / View Builder - which is divided into two portions: the upper Graphical View, and the lower Syntax View, allows you to create and edit queries / views visually without knowledge of SQL.

Support of Parameter Query
Set query parameters to add variable values to a query each time you run it.

Code-Completion for Query, View, Function/Procedure and Event
Experience a quick way in constructing SQL statements in SQL Editor with the Code-completion feature. Whether you want to select available properties of database objects or SQL keywords, all it takes is a pick from the drop-down list.

Server Monitor
Select the servers that you want to monitor by checking them in the checklist box of the Server Monitor Window. Click on either Process List, Variables or Status Tab to show and/or modify the properties of servers.

Text / Blob View
Navicat provides Text / Blob Viewer and Editor to view and edit TEXT / BLOB fields content. The editor allows you to view, update, insert or delete data in a table.