Navicat for MySQL
Navicat for MySQL
15.0.21

4.5

HomeInternet UtilitiesNavicat for MySQL
Navicat for MySQL free download for Mac

Navicat for MySQL

15 September 2020

Graphically manage MySQL databases.

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 Navicat for MySQL

Version 15.0.21:
Bug-fixes:
  • The "Set Null" option was applied to a wrong column when some columns were hidden in Table Viewer.
  • The field size was incorrect in Form View.
  • Crashed when opening/testing a connection after changing "Settings Location" to a folder in Documents.
  • The "Encoding" setting was not stored when the connection was synchronized to Navicat Cloud.
  • "Dump SQL File" stopped running in some cases.
  • Minor bug fixes and improvements.
Navicat for MySQL for Mac Old Versions

Related articles

Join over 500,000 subscribers.

Subscribe for our newsletter with best Mac offers from MacUpdate.

How would you rate Navicat for MySQL app?

31 Reviews of Navicat for MySQL

MarkRobinson1897
07 April 2013
Version: 10.1.3

Most helpful

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.
(2)
MarkRobinson1897
07 April 2013
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.
(2)
5
Colin-☕
29 November 2012
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!
(0)
4
Colin-☕
08 January 2011
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.
(1)
5
anonymous-swordtail-5389
15 December 2010
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.
(1)
5
Drtyrell969
23 August 2010
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. ;-)
(1)
Jamesehale
29 May 2010
Version: 9.0.5
What's new refers to Navicat PREMIUM, not Navicat MySQL. From Navicat's site: May 20 2010 Navicat for MySQL (Mac) version 9.0.5 is now available Improvements: If the row is selected, Filter Wizard will now display the words in white color. Query Builder supports to show diagram for some incomplete statement. Bug Fixes: Crashed when getting server Information on Information View if connection failed. Improper join lines were displayed when joining multiple tables in Query Builder. Crashed when parsing some improper SQL statements. Wrong bit field default values were displayed in Table Designer for MySQL version 5.1.31 or above.
(1)
5
Banshee_z71
13 May 2010
Version: 9.0.4
Version 9 is the update for Navicat I have been waiting for. I've used Navicat for 6+ years on both Windose and Mac. It has always had the same problem on both OS. Would randomly crash. At least 1 or 2 times a day. But with Version 9 on my Mac I have never had a crash. Definitely worth the $50 upgrade just to get rid of the random crashes. Buy it!
(1)
Intelios
24 February 2009
Version: 8.0.2
Could someone point me to to right direction on where to find the menu for opening a new Main window. I sometimes accidentally close the main window and cannot bring it up without restarting the entire application. Any help would be appreciated. Thanks.
(0)
Show comments (3)
anonymous-gerbil-5319
17 February 2009
Version: 8.0.1
Still no Access import like the Windows version, very disappointing to see Macusers still have to put up with a crippled version. On the developers site it is almost impossible to find out what's new and why I would have to upgrade for $50,-. It's a pity, because Navicat may have some quirks, but I work with Navicat all day and overall I am very pleased.
(1)
4
Macaron1
11 August 2008
Version: 7.1.4
Have been using Navicat for over two years. As far as I'm concerned, it's the best MySQL editor on the Mac. If you do heavy editing, you'll appreciate its versatility compared to web-based solutions. Download and check out the 30-day trial. Or grab the free version off their website if you are going to use it non-commercially. Some minor quibs: SSH tunneling is buggy. It regularly crashes whenever I use SSH tunneling on the road. Related to the above: You lose all your unsaved queries when it crashes. Very frustrating if you have several or more query tabs open! The GUI for editing triggers and stored procedures is non-intuitive. I frequently find myself typing up the SQL in a text editor like TextMate and pasting it into Navicat. When in table design, you can't duplicate rows. Also, there is something unintuitive about the whole process because I find myself having to resort to the mouse when adding stuff: Tabbing will not get you to all editable fields. The Mac version, for some reason, trails one point behind the Windows/Linux version. Not sure what you lose, but probably implies they devote less resources to the Mac side of their business. The query tool does process multiple SQL commands but will return results for only the last. Also, older results will disappear as soon as you edit the SQL or want to type in something new. So, whenever I need to compare results of two or more queries, I find myself opening multiple tabs and going back and forth between them. Would be nice if I could see the results on the same window somehow.
(0)
4
Cenocre
07 January 2008
Version: 7.0.11
If you think that being forced to install things via command lines in Terminal is primitive and idiotic and should have been abandoned in 80's, then you'll like Navicat. It is light years better and easier than using WebMin. The interface still needs works, to improve the flow and ergonomics (HI considerations seem to have been forgotten about by most including Apple about a decade ago.), but this is a very useful and rather featured tool. And, so what if you have to pay. Good work deserves compensation. Besides if you use this for business you will have done dozens of things with this before you have even figured out how to install , access, and use WebMin. Additionally, using an application for direct access always blows away any browser access in almost every way shape and form, especially speed, convenience and features. Use your brain, use open source, if it is good, but too much open source stuff will waste years of a professional's life. If you want to get work done, rather than blindly hold on to open source, command line installs, and browser just because it is free, by all means, get Navicat.
(1)
Don-Morris
05 November 2007
Version: 7.0.9
Expensive, but worth the price because of the time it has saved me over using phpMyAdmin.
(0)
4
Web-Jive
23 July 2007
Version: 7.0.4
OK, I have sent 3 bug reports in over the last month had the developers have taken all 3 and fixed them! What great service. I can't say enough about a company that will actually take a bug report, verify it, get back in touch to let you know it's fixed and the latest version is available for download. WOW. Navicat is a critical part of my web design and hosting business. I played with a lot of tools before I settled on Navicat and have tried others since. Nothing seems to cover the bases as well. Highly recommended.
(1)
anonymous-gerbil-5319
14 July 2007
Version: 7.0.3
It is good software, I administer quite a lot of db's and found it a very usefull tool. It could indeed be a bit more stable. Further Navicat doesn't quite follow the UI rules we are used on a mac. For example, if you want to quit the program and have more tabs open, Navicat will present you a dialog if you are sure to close multiple tabs and if you enter "yes" it will close tha tabs but doesn't quit, this is annoying ... (and simple to fix) I am happy with this tool on the mac, but it should follow mac interface behaviour.
(0)
Show comment (1)
Web-Jive
07 July 2007
Version: 7.0.2
Navicat is a good DB tool, especially for the Mac. Be warned about 7.0.2, it crashes constantly. If your running 6.3.7, keep using that version. I'm almost paralyzed because of the 7.0 crashes and when I installed 6.x over the 7.x, it wouldn't work at all.
(0)
5
Drtyrell969
31 May 2007
Version: 6.3.6
I know its hard to pay money for tools like this if you're used to getting everything for free, but this bad boy is worth your money. From the easy user interface that is VERY comprehensive to the AWESOME backup feature, this product has saved my ass many of times, and I've only owned it for 6 months. I've had to move sites from one server to another, and this product do the transfer for me with one click of a button. Truly amazing. If you're serious about saving time, give up the demos, and get the real thing.
(0)
Stalepez
22 March 2006
Version: 6.1.5
Great software! I submitted a bug recently about slow connections to database servers with tons of dbs on them, and they were not only responsive, but fixed it like they said. This is an indespensible application for any heavy SQL development, the only thing I wish it has was direct .xls import/export. otherwise, a great app and highly recommended.
(1)
Ronnie-Mac
07 January 2006
Version: 6.1.3
Navicat is in a class by itself. Yes, you can manage MySQL on the Mac with Webmin or phpMyAdmin, but Navicat does so much more. If you're a serious MySQL user, you'll understand why Navicat is worth it. Remote SSH logins, scheduled backups (that actually work on a Mac), all the goodies you'd expect from a commercial application with REAL live support. Runs on Mac, Linux, Windows. Even if you're not a MySQL guru (I'm not) you'll like Navicat's ease of use to get up and running (very intuitive), yet loaded with power to repair, optimize, automate. Love it. I use it on over two dozen MySQL databases on Tiger Server.
(0)
Anonymous
10 November 2005
Version: 6.0.10
I use Webmin, free, can be accessed from any web browser and the Mysql server control is full featured. It just doesnt seem quite right having to pay for something used to front end an open-source project when there are other open-source utilites that will do the same.
(0)
Show comment (1)
4.25
Anonymous
06 September 2005
Version: 6.0.8
I usually second the advice given when there is an alternative out there that does the same for free, but this NOT the case with mySQL and Navicat, they are two completely different beasts. Navicat allows you to schedule backups, remotely connect to databases, transfer entire sets of tables with just one click, save queries, create immediate backups (local & remote). The support is also good, I have had my answers replied to in their forums in less than 24 hours (although their English is far from perfect ;). I work with mySQL on daily basis and of all the products out there that allow you to adiminister a mySQL DB, this is the one. CocoaSQL is a good alternative if you are looking for something free, but to this day the amount of time this app has saved me is well worth its price.
(0)
Anonymous
11 June 2005
Version: 6.0.4
just get MySQL Administrator its free!! and its made by the same people
(0)
4.75
Anonymous
10 June 2005
Version: 6.0.3
I administer several installations of Moodle and other course management systems. Backing up critical data to multiple servers was a headache until I found Navicat. I tried doing similar backups and restores with PhpMyAdmin and CocoaMySQL and always ran into problems. Navicat, on the other hand, just runs smoothly and sweetly each and every time. I've also found Navicat email support to be very reliable. I've always received a knowledgeable response within 24 hours.
(0)
Anonymous
10 June 2005
Version: 6.0.3
CocoaMySQL = free and it has a better interface than this.
(0)
4.75
Anonymous
13 May 2005
Version: 6.0.2
We have tried many different software to manage our MySQL databases in the past, however only Navicat came out on top. Once I download it as a trial I knew I had to purchase it for our company. The time it saves us managing our databases is unavailable. The backup features and how simple it is to use can not be compared. I recommend Navicat to everyone I know. Keep up the great work guys!!! Orlando Piedrahita, System Engineer, World Fuel Services Corporation
(0)
Anonymous
03 January 2005
Version: 5.3.1
one word: phpmyadmin =FREE (ok that might be 2 words...)
(0)
4.5
Anonymous
03 August 2004
Version: 5.2
Navicat has solved several problems for me. My biggest problem was database backup. With Navicat automated backup is extremely easy. I just scheduled a backup job to run every day using Navicat and the problem was solved. Table design and alterations are a snap with Navicat . New tables can be constructed in a fraction of the time it used to take. The export feature of Navicat allow me to export data in a form that can be used on Palm Pilots by my employees. User management is very easy with Navicat . Adding, deleting and setting privileges is easily done with a few clicks of the mouse. I have tried many other fine programs, but Navicat is by far the best. Ease of use and the list of features make it my choice for MySQL administration. By Jeff Tucker, Emmis Communications
(0)
4.75
Anonymous
20 May 2004
Version: 5.1
Our company has been using Navicat for about two months now. Rarely have we found a product that has boosted our productivity so much! The ease of administering and modifying our database driven site is truly remarkable compared to the old approaches that we used (web based, server command line). It has truly changed the way that we do business. The time that it saves us allows us to focus on improving website content and functionality. Thank you for a well done, well supported product. Amy Strycula, Top Cat CatsPlay.com http://www.CatsPlay.com Fun Furniture for Felines
(0)
4
Phil Chapman
24 January 2004
Version: 5.0
Navicat is an excellent piece of software that makes administering a MySQL database very straightforward. Of particular importance are the back-up and data transfer features which make keeping your databases safe, and transferring data from one server to another dead easy. The user management feature is also simple to use and again makes admin very simple. Version 5 has a query builder which starts to bridge the gap between the mac and pc versions of the product. It isn't as advanced as the PC version does make creating relational queries from several dbs a lot easier. What is still missing as compared to the PC version is the import from MS Access feature which I find invaluable - I can design a relational database in MS Access and then import it directly into MySQL which is fantastic. Cost wise I'd definitey say it was worth the money, especially seeing as you are getting MySQL for nothing!! In summary, a great piece of software and definitely recommended. There are lots of free or shareware tools that do a similar thing out there and of the ones I looked at this was by far the best. The piece of software that does beat Navicat for Mac is Navicat for PC - if like me you use both platforms I'd probably recommend getting the PC one, although I ended up getting both just for convenience.
(0)
5
Daniel Maier
20 January 2004
Version: 5.0
I don't know what all the kids are doing here rating Software they don't understand. I'm very happy with navicat very fast and stable. CocoaMySQL crashes if I do a query. With Navicat you can doe a query and can view results with 10'000 entry's. It handel's my Database with over 2 Million records easily. That's software not unfinished freeware. And what does it cost 99$. OK its not cheap but it works. It would be nice to have support for PostgreSQL So I rate it very high as a comparsion for others. They only rate bad and dont understand that somebody probably hast to feed his kids and give's somebody els a job. Not everybody is M$ and named Gates
(0)
1
Tidrion
15 January 2004
Version: 4.4
Cocoa MySQL blows this version and their latest (5.0) out of the water. There is simply no comparison. I think the developers at Navicat need to spend some time checking out their competition. When there is a free product that runs circles around yours...it is never a good sign.
(0)
3.25
Anonymous
23 August 2003
Version: 4.2.4
not much functionality. No search field for tables. cocoa mysql is for free and lets you search for data in tables. very good back up and download of tables and data on the good side.
(0)
$199.00Buy Now

4.5

App requirements: 
  • Intel 64
  • OS X 10.11.0 or later
License: 
PaidOne-Time Purchase

Downloaded & Installed 56,322 times

Similar apps
Sequel Pro
Sequel Pro
Manage MySQL databases.
Is this app is similar to Sequel Pro? Vote to improve the quality of this list.
Vote results
0
Upvotes
8
Total score
0
Downvotes
SQLPro for MySQL
SQLPro for MySQL
Database management studio for MySQL.
Is this app is similar to SQLPro for MySQL? Vote to improve the quality of this list.
Vote results
0
Upvotes
2
Total score
0
Downvotes
MySQL Workbench
MySQL Workbench
Efficiently design, manage and document database schemata.
Is this app is similar to MySQL Workbench? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
Querious
Querious
MySQL database management application.
Is this app is similar to Querious? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes
MySQL Optimizer
MySQL Optimizer
Database tuning (was MySQL and MariaDB Optiimizer).
Is this app is similar to MySQL Optimizer? Vote to improve the quality of this list.
Vote results
0
Upvotes
1
Total score
0
Downvotes