Navicat for MySQL overview

Navicat for MySQL Client from PremiumSoft, is an integrated GUI tool let you perform MySQL administration and database development in an easier way. Advanced features allow you to create data models, import/export data, backup, transfer databases, create queries, and manage your local or remote MySQL server. It also includes a full-featured graphical manager for setting the users and access privileges and more.

Navicat is sophisticated enough for professional developers, yet easy to learn for new users. It is also available for Windows and Linux and translated into 7 major languages.

What's new in version 18.0.3

AI Integration in Table Designer & Data Editor

Fill with AI : Update, generate, or summarize column data directly within the grid.
Ask AI : Construct entire schema structures using natural language prompts.
Fill Comment with AI : Generate table summary based on field definitions.

Code Insight in Query Editing

Refactoring : Rename symbols, aliases, and identifiers uniformly across scripts.
Hover Info : Quick-access metadata previews when hovering over SQL elements.
Real-Time Error Detection : Real-time syntax flaw and invalid schema object detection.
Highlight Usages : One-click symbol usage tracing within the editor.
Go to Declaration : Direct navigation to underlying object definitions.

Data Masking

Secure sensitive production records and generate test datasets
Support Masking Technique - Substitution, Variance, Shuffling, Hashing, and Nulling.

Data Modeling

Hybrid Model : Bridge logical entities and physical structures within a single model.
Naming Standards & Glossary : Support centralized glossaries and standardized naming rules across schemas.
Bulk Editor : View and edit fields across multiple tables simultaneously.
Import SQL to Model : Generate data models directly from SQL scripts.
Diagram Add-ons : Move Fields Between Tables, Create New Table & Alignment Guide.

Interactive BI

Auto Tile Layer : Automatic dynamic chart alignment and resizing for dashboard layouts.
Parameters : Dynamic workspace-wide parameters for cross-visual data filtering.
Dashboard Add-ons : Auto Refresh, Page Navigation links & Alignment Guide.

Usability & Workspace Improvements

Reimagined Import Wizard : Redesigned into a single-step workflow with live preview panes.
Parquet Support : Native support for importing Apache Parquet files.
Batch Editing : Batch record modifications with a manual Apply/Discard bar.
Session History : Track and audit for SQL queries executed during data editing sessions.
Side-panel Record Navigation : Quick-jump navigation panel in Form View.
Personal Profile Sync : Synchronize connection profiles, table preferences, starred settings, and coloring info across Navicat Cloud and Navicat On-Prem Server.
And More.

View older Navicat for MySQL versions

4.3

(69 Reviews of Navicat for MySQL)

Comments
User Ratings

MarkRobinson1897

Apr 7, 2013

10.1.3

0.0

Version: 10.1.3

You can check one more tool - Valentina Studio http://www.valentina-db.com/en/valentina-studio-overview 14 Feb 2013 in the 5.0 version added support of mySQL/mariaDB , as well as, SQLite, PostgreSQL. It is FREE. Works on Mac, Win and Linux. Includes not only db management but powerfull reports that work again on 3 OS.

Colin-☕

Nov 29, 2012

10.1.1

5.0

Version: 10.1.1

A while back I wrote a review for v9 that mentioned it was buggy, so I thought I should follow-up to say that I have found v10 to be rock solid. HUGE improvement in reliability in this release. Since I didn't mention it before I should point out one of Navicat's features that if you use it once will make the app worth the price: If you open a connection to two databases at the same time, you can migrate your tables (and views, procedures, etc) just by drag & dropping them from one db to the other. Boom. Done. No exporting & import. It's barely more difficult that moving a file across a network. Amazing. The other parts of the app continue to be refined, making editing tables, and stored procedures just a *little* bit nicer. And I know it's been there for a while, but the SSH tunnelling feature is enormously handy when trying to access a database behind a firewall. Thanks Navicat devs!

Jan 8, 2011

9.1.3

Version: 9.1.3

There are a number of decent and *free* database management programs out there but I found Navicat to be well worth the money. (You might think it seems like a lot but if you're spending even a few hours/week managing a DB I think Navicat is good value.) Unfortunately I'm stuck on version 8 because while the interface on 9 is much nicer, I find it crashes pretty much every time I use it. Sometimes it's because of a timeout on the server, sometimes it's just seems random. There seem to be a few buggy interface elements that pop up from time to time as well (the enum default-value menu comes to mind -- it often chooses the values of the previously selected enum field). So I'll stick with 8 for now. Hopefully 9.2 brings some stability.

anonymous-swordtail-5389

Dec 15, 2010

9.1.2

Version: 9.1.2

Crazy stuff! I've been using Navicat for a long time now, and it proven itself an indispensable tool for managing MySQL databases. And I have lots and lots of them. Navicat does absolutely everything I need. Transfers, queries, data/structure sync, SSH/HTTP tunneling.. And support is beyond incredible! I files a crashing bug to them and got it fixed, AND the updated version of the program released in under 48hrs. I'm shocked! It is indeed an expensive tool, but considering how much time it'll save you in a long run, and hourly rate of almost any DBA/programmer who do DBs for living, the price is rather easily justifiable. Highly recommended.

Drtyrell969

Aug 24, 2010

9.0.9

Version: 9.0.9

This is THE product to own if you're doing MySQL work. No more myPHPAdmin crap. The power to not only create the database, but to managed it with micro edits right in the GUI is unmatched. Heavily recommend for those of you who know that time does equal money. ;-)

Macgui

Feb 8, 2013

Version: null