MySQL Workbench vs. Navicat

It is good software when we have to connect the database of the remote server but it is not as good as phpMyAdmin. When local server is concerned, phpMyAdmin is way better because it has more cleaner UI than Workbench. Workbench is preferred only because phpMyAdmin does not support the connection of remote servers.

Incentivized

Navicat Premium is a very well-rounded tool with a reasonable licensing fee given its feature set. It is primarily suited for technical resources who must work with a variety of different database systems, but who may not be database or command line tool wizards. However, its query building and job batch scheduling feature support end-users as they build competency, and it continues to hold its value even as users outgrow their training wheels. Navicat is probably not so appropriate for DBAs and others for whom database development and management is already a career path; these folks have their preferred toolsets, both vendor-supplied and homegrown, and they might consider the additional licensing cost to outweigh the value they'd personally get out of Navicat.

Incentivized

• Readily available too for quick and easy SQL queries
• Maintains upgrades
• Works across multiple OS platforms

Incentivized

• Really helpful auto-completion.
• Can connect to multiple (different) database types simultaneously.
• Can generate some really impressive charts.
• The new data dictionary tool is great!

• There are a lot of menus, some of them aren't needed or users who only need to send queries. I had to watch a videos on youtube to learn how to use workbench. It would be great to have some videos inside software (or links to videos on youtube)

Incentivized

• Remote deploy databases
• Clone databases

Incentivized

MySQL Workbench is useful for specifically remote databases. Remote databases generally does not have any UI and we have to connect the server via SSH and on CLI, we write the queries and it shows the data, which is quite tiering and more prone to make mistakes whereas MySQL Workbench provides cleaner way to connect and provides lot of tools, so that we do not have to write queries all the time.

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

It's like comparing a VW to an performance car like a Ferrari. If you need the performance, bells and whistles you'll want PhpStorm. If you just need to get from one place to another, MySQL Workbench will do just fine.

Incentivized

Navicat allows for easier querying of data while still allowing for visualization and modeling

• 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

• Assisting new employees with understanding our DB
• Reduce debugging and testing time with being able to visualize data/queries
• Allowing non-SQL users to execute queries to get real-time data.

Incentivized