Navicat Premium

Perform cross database management and migration on MySQL, Oracle and PostgreSQL. Includes Import/ Export Wizard, Query Builder, Report Builder, Data Synchronization, Backup, Job Scheduler.

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. Also, Supports MongoDB. 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.

Navicat comes with numerous improvements and features to address your database development needs. With over 100 enhancements and a brand new interface Navicat gives you new ways to build, manage and maintain your databases.

Key Features:

• Seamless Data Migration: Data Transfer, Data Synchronisation and Structure Synchronisation 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 synchronise databases with Data and Structure Synchronisation. 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 customisable 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: Synchronise 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 maximise your productivity.
  
• 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.

Navicat Premium - Features

Features in Navicat are sophisticated enough to provide professional developers for all their specific needs, yet easy to learn for users who are new to database server.

Navicat Premium is available for two platforms - Microsoft Windows and Mac OS X. It can connect users to local/remote server, providing several utilities such as Data/Structure Synchronization, Import/Export, Backup/restore and Report to facilitate the process of maintaining data.

For Windows

Multi-connections Database Administration tool

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 Stored Procedure, Event, Trigger, Function, 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

Latest Oracle Versions Support

• 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

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.

• Export data and create records as INSERT statements in sql file
  During Data Transfer, you can choose to export data as sql file with designated SQL format and encoding.

• Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization from different kind of servers
  Profiles from different kind of databases can be created in a single batch job, so that you can set schedule and run at a specific time. Batch job can be created for Report Printing, Backup, Query, Data Transfer, Data Synchronization, Import and Export.

• Send notification e-mail and attachment for schedule task
  Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule. Also, exported file or printed report can be added to the batch job as mail attachment so that you can share your data easily.

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.

• Support of HTTP Tunnel for MySQL and PostgreSQL servers
  Navicat comes with HTTP Tunneling while your ISPs do not allow direct connections to their servers but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a webserver does.

• Export Registry Record(.reg) via Navicat Premium
  You can easily transfer your connection settings while migrating Navicat from one computer to another new machine. Simply export a registry file via Navicat and restore it on the new machine.

Comprehensive Management of database objects

• Create, edit and drop database subobjects
  With Table Designer - the basic Navicat Premium tool for working with tables, you can create, edit and drop table's fields, indexes, foreign keys, checks, triggers, privileges and much more.

• SQL Preview
  The SQL Preview area shows you SQL representation of the database objects you are creating. This ability allows you to preview SQL before execution.

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

• Print Schema / Table Structure
  Present the schema / 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 ODBC
  You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.

• Import data from up to 11 most popular formats including MS Access, MS Excel, XML, HTML, TXT and CVS
  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.

• Export Data to different file formats: TXT, CSV, DBF and XML
  Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.

Powerful Data Manipulation Tools

• Form View
  Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.

• Support of Foreign Key Data Selection
  With the GUI tool - Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!

• Data and Structure Synchronization
  You can transfer data from one database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source or on another server.

• Support of Backup and Restore MySQL/PostgreSQL databases
  Regular backup on database is important to users. Backup/restore all tables and records, views, functions, etc for your databases using Navicat. You can also schedule backups between databases.

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.

• Query Editor
  It allows you to create and edit SQL text for a query, prepare and execute selected queries.

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

• Code-Completion for Query, View, Stored Procedure and oracle objects
  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.

Easy-to-use Report Builder *only available in Windows Enterprise Version

• Create reports with visual Report Builder
  Create different types of reports with our user-friendly GUI Report Builder. Design reports for Invoice, Statistics, Mailing Labels and more.

• Export report to multiple formats, PDF, Excel, HTML etc.
  Enjoy more output formats for report export - text, pdf, Lotus, Excel, Graphic, Html and more. Check out the feature in Report Builder included in Navicat Enterprise Version.

• View and share reports with others by using Report Viewer
  Navicat Report Viewer allows you to navigate reports designed by Navicat Report Builder. The coolest thing about it is that you can share reports with someone who does not have Navicat running on his computer but has Navicat Report Viewer installed.

• Backup your report as archive file (.raf)
  Navicat allows you to save reports as an archive file (.raf) for backup and increased portability.

More great features

• Virtual Grouping
  Have a better organization over connection and objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature.

• 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 your servers.

• SQL Console
  To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.

• Docking
  You can customize your window behaviour style into Docking Windows or Floating Windows. Choose either dock the opened windows to the main window/dock windows or inherit the last docking style.

• Profile System
  For most of the tasks, Navicat allows you to save / load profiles to increase convenience. Profile can be applied on Data Transfer, Data / Structure Synchronization, Batch Job, Import / Export etc.

• Desktop Shortcut
  This feature can save you a lot of time to access your most used table/view, reducing the number of steps to reach them.

Back to top

For Mac OS X

Multi-connections Database Administration tool

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 Stored Procedure, Event, Trigger, Function, 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

Latest Oracle Versions Support

• 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

Latest PostgreSQL Versions Support

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

• Export data and create records as INSERT statements in SQL file
  Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their PostgreSQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a PostgreSQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.

• Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization from different servers
  Profiles from different kind of databases can be created in a single batch job, so that you can set schedule and run at a specific time. Batch job can be created for Report Printing, Backup, Query, Data Transfer, Data Synchronization, Import and Export.

• Send notification e-mail and attachment for schedule task
  Generate notification e-mails to recipients you specify, connecting them to the latest schedule information. Read directly through your email account on the results returned from a schedule. Also, exported file or printed report can be added to the batch job as mail attachment so that you can share your data easily.

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.

• Support of HTTP Tunnel for MySQL and PostgreSQL Server
  Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a server that uses the same protocol (http://) and the same port (port 80) as a webserver does.

• Provide auto-reconnection for MySQL and PostgreSQL server
  With the option "Keepalive Interval", you can keep connection alive with the server by pinging it.

Comprehensive Management of Database Objects

• Create, edit and drop table's fields, indices, foreign keys and triggers
  With Table Designer - the basic Navicat Premium tool for working with tables, you can create, edit and drop table's fields, indices, foreign keys, and much more.

• SQL Preview
  The SQL Preview area shows you SQL representation of the oracle objects you are creating. This ability allows you to preview SQL before execution.

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

• View Database / Schema / Table Structure
  Present the database / schema / 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 ODBC
  You can import data from ODBC after setting up a data source connection. All available tables will be included if connection success. Just simply choose the tables you wish to import or specify a query using Add Query button.

• Import data from different file formats: XLS, CSV, TXT, DBF and XML
  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.

• Export data to different file formats: XLS, TXT, CSV, DBF and XML
  Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.

Powerful Data Manipulation Tools

• Form View
  Manipulate the current record with Form View. Enjoy a clear display of field name and its value with focus on current record.

• Support of Foreign Key Data Selection
  With the GUI tool - Foreign Key Data Selection, you can locate the foreign key values from the reference table. Stop shifting the view to a master table to look for the available values!

• Data and Structure Synchronization
  Navicat Premium allows you to transfer data from one database to another with detailed analytical process. Likewise, you can compare and modify the table structures. For both Data and Structure Synchronization, the target database can be on the same server as the source database or on another server.

• Support of Backup and Restore MySQL/PostgreSQL databases
  Regular backup on database is important to users. Backup/restore tables and records, views, functions, etc for your database using Navicat. You can also schedule backups between databases.

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

• Query Editor
  It allows you to create and edit SQL text for a query, prepare and execute selected queries.

• 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 and other database objects
  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.

More great features

• Virtual Grouping
  Have a better organization over connection and objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature.

• 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 your servers.

• SQL Console
  To use a command-line interface, you can open SQL Console in Navicat. It provides you an interactive text-based screen to query input and result output from database.

• Tabbed Windows
  Customize your window behaviour style. Navicat supports you of dragging windows in and out of the tabbed windows.

• Profile System
  For most of the tasks, Navicat allows you to save / load profiles to increase convenience. Profile can be applied on Data Transfer, Data / Structure Synchronization, Batch Job, Import / Export etc.

• Shortcut
  Navicat premium allows you to drag and drop tables/views to create shortcuts. This feature can save you a lot of time to access your most used table/view, reducing the number of steps to reach them.

Back to top

Navicat Premium - System Requirements

For Windows

System Requirements

• Microsoft Windows 2000, XP, Vista or 2003
• Pentium II processor or above
• 64 megabytes (MB) of RAM
• Hard-disk space vary depending on installation. Full installation requires 10 MB of available hard-disk space

For Mac OS X

System Requirements

• Mac OS X 10.4 Tiger or 10.5 Leopard