Navicat for MySQL Overview

Navicat MySQL GUI

Navicat for MySQL is a powerful Database administration and development tool for MySQL. It works with any MySQL Database Server from version 3.21 or above, and supports most of the latest MySQL features including Trigger, Stored Procedure, Function, Event, View, and Manage User, etc. Download Navicat Documentation

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

With Navicat well-designed Graphical User Interface (GUI), Navicat for MySQL lets you quickly and easily create, organize, access and share information in a secure and easy way, taking MySQL administration.

Navicat for MySQL is available for three platforms – Microsoft Windows, Mac OS X and Linux. It connects users to any local/remote MySQL Server, providing several database utilities such as Data/Structure Synchronization, Import/Export, Backup and Report, to facilitate the process of maintaining data.

For Windows

	Latest MySQL Versions Support
	Additional Connection Options
	Instant Navigation Over Database
	Comprehensive Management of MySQL objects
	Diversified Import and Export Competence
	Powerful Data Manipulation Tools
	Powerful Security Management
	Well-Designed Visual Builder / Editor
	Easy-to-use Report Builder

System Requirements

Microsoft Windows 2000, XP, Vista, Server 2003, Server 2008, Windows 7

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

Latest MySQL Versions Support

Navicat for MySQL - a powerful MySQL Database Server administration and development tool. Highlights of supported features:
- Support of MySQL versions from 3.21 or above
- Support of Unicode / Character Set
- Support of MySQL Events, Views and Stored Procedures creation
- Support of Triggers
- Support of Foreign Keys

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
Navicat comes with you HTTP Tunneling while your ISPs do not allow direct connections to their MySQL server but allows establishing HTTP connections. HTTP Tunneling is a method for connecting to a MySQL server that uses the same protocol (http://) and the same port (port 80) as a webserver does.

Provide auto-reconnection for MySQL server
With the option "Timeout reconnection", you can keep connection alive with the server by pinging it.

Export Registry Record(.reg) via Navicat for MySQL
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.

Instant Navigation Over Database

Show 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!

Comprehensive Management of MySQL objects

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

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 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 18 most popular formats including MS Access, MS Excel, XML, PDF and TXT
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 MS Access, MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc
Likewise, Export Wizard allows you to export data into various format. Save your settings as an export profile for setting schedule.

Export data and create records as INSERT statements in sql file
During Data Transfer, you can choose to export data as sql file with record options like complete insert statements / extended insert statements etc.

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 for MySQL allows you to transfer data from one MySQL 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 MySQL server.

Support of Data Transfer between local / remote MySQL databases
Transfer tables/views/stored procedures/events from one MySQL database to another MySQL database, or to a plain text file.

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

Create Schedule for Backup, Import / Export, Data Transfer, Saved Queries and Data Synchronization
Create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time. Batch job can be created for Query, Report printing, Backup, Data Transfer, Data Synchronization, Import and Export.

Send notification e-mail 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.

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, tables/views, fields and stored procedures/functions.

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 and Event
Experience a quick way in constructing SQL statements in Query Editor, View and Event 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 for MySQL's 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.

More great features

Virtual Grouping
Have a better organization over objects in Navicat. You can categorize objects into groups with the Virtual Grouping feature. Virtual Grouping can be applied on Connection, Table, View, Stored Procedure, Event, Query, Report, Backup and Schedule.

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 MySQL 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 or dock windows or inherit the last docking style.