MySQL Workbench vs. Navicat

It works best when you need to create basic queries or manage an simple MySQL schema. For more complicated data modeling, I'll use another tool. You can't beat the price though.

Incentivized

I was tasked with migrating data from our local PostgreSQL DB to an Amazon RDS instance. I expected this to be a difficult job, but Navicat's migration wizard made it fairly straightforward. I think that it's more geared towards professional users, although not necessarily database practitioners. Non pros might do better with the new Navicat Lite edition.

• Send queries to DB
• Export results in csv

Incentivized

• Easy to understand
• Simple UI/UX
• Easy to connect data

• On the Mac version, quitting always throws an exception. More of an annoyance but still. This should have been fixed a long time ago.

Incentivized

• Filter table
• Save to external file

Incentivized

Quite complicated. It's unrealistic to use without prior preparation (guides on youtube or colleagues' help).

Incentivized

There is quite a lot to learn because Navicat Premium is a very comprehensive database management and development tool, but it's User Interface is intuitive enough to pick up fairly quickly. I have also referred to the documentation on occasion, and can attest that it is quite good. I feel that it works best on a large monitor, but that's fairly common for this sort of software.

Very robust online community and well as excellent support staff. Easy to follow video tutorials. Detailed sample configurations are provided with guided walk-throughs via remote classroom instruction. Very fast response from support staff. No internal hires were necessary for support as vendor support staff fully met all technical expertise. 24/7 incident reporting and tracking is great.

Incentivized

phpMyAdmin is way better only when local database is concerned but MySQL Workbench is way better then SQLyog because of the more cleaner UI and cost. SQLyog does not have any open-source featuring whereas MySQL Workbench has open source edition with lot of good free features. So MySQL Workbench is powerful than SQLyog.

Incentivized

While Sequel Pro is a great shareware tool, it's limited to MySQL databases; while our department does use MySQL databases, we also use Oracle databases, so Navicat Premium's multi-product support is an absolute requirement. Navicat Premium also provides data browser support, including filtering, to empower less technically-minded users to query and manipulate databases, an option not available in Sequel Pro. And the job scheduling and batching features of Navicat Premium further distinguish it above the admirable, if limited, Sequel Pro.

Incentivized

• It provides good features and saves the time.
• When we use remote server, we can connect without using ssh etc. so saves the time and easy to understand.
• Do not have to write the queries to check the schema, so saves the time.

Incentivized

• Similar features to OEM provided very easy to use, out-of-the-box functionality.
• No large infrastructure changes were needed to deploy and install.

Incentivized