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.

Feature Matrix

Platforms	Windows Enterprise Edition	Windows Standard Edition	Windows Lite Edition	Mac OS X Standard Edition	Mac OS X Lite Edition	Linux Standard Edition	Linux Lite Edition
MySQL Objects Management
Support MySQL servers 3.21 or above
Create / drop databases
Support all MySQL objects: tables, views, stored procedures/functions and events
Support all subobjects: fields, indices, foreign keys and triggers
Support of character set and unicode
Connection Management and Navigation
Multiple local/remote MySQL server connections
Connection to MySQL Server through SSH
Connection to MySQL Server through HTTP
Support SSL secure connection
Keep connection alive
Backup connection informations
Customize selected databases to work with
Data Viewer and Editor
Grid view
Form view
Text, Hex and BLOB viewer/editor
Copying and pasting selected records
Customize display formats
Incremental search, sorting and formatting table grid
Support of raw mode edit: apply MySQL built-in function
Support of foreign key data selection: locate the available values from the reference table
Filtering Records
Ability to set number of records showing on each page
SQL Processing
Visual query/view builder to facilitate the process of building complicated queries
Ability to create parameter queries
Multiple SQL editors with syntax highlighted feature
Code completion for SQL editors
Ability to preview SQL before execution
SQL console
Diversified Import and Export Competence
Importing data from ODBC: MSSQL, Oracle etc
Importing data from MS Excel
Importing data from MS Access
Importing data from other file formats : TXT, CSV, XML, DBF etc
Exporting data to MS Excel
Exporting data to MS Access
Exporting data to HTML and PDF
Exporting data to most popular formats: TXT, CSV, XML, DBF etc
Other Data Manipulation Tools
Data transfer
Transfering data to SQL script as INSERT statement
Data synchronization
Structure synchronization
Backup/Restore
Backing up/restoring database
Restoring database with chosen database objects
Converting backup file into SQL script
Backing up database/table to SQL script
Executing SQL script
Schedule for Batch Job
Ability to set schedule on backup, query execution, import/export, data transfer and data synchronization
Schedule report printing
Schedule to print report to files: PDF, Excel, HTML etc
Sending notification e-mail for schedule task
Server Security and Maintenance Services
Visual user manager to administer users and privileges
Ability to duplicate user
Analyzing, checking, optimizing and repairing tables
Server Monitor to view and change system variables, to view server status information
Report Management Tools
Report Builder
Report Viewer
Other Useful Features
Duplicate/empty/ truncate tables
Create table/view shortcut on desktop
Print database/table Structure
Support of docking/tab windows
Support of virtual grouping: provide logical organization over connections and objects
Ability to run profile from command line
Log files: keep track on the actions have been performed in Navicat