TrustRadius: an HG Insights company

MySQL Workbench

Score6.7 out of 10

10 Reviews and Ratings

What is MySQL Workbench?

MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, and backup. MySQL Workbench is available on Windows, Linux and Mac OS X. It is available free through its Community edition, and an Enterprise edition is available for a commercial license as well, supported by Oracle.

A reliable workhorse

Use Cases and Deployment Scope

We use this for a MySQL database access. We write queries and often need to use the SSH tunnel feature. We like that it's free and works well for the most part.

Pros

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

Cons

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

Return on Investment

  • For basic MySQL users e.g. people who query databases it's a great tool.
  • For more complex queries you'll want something with more horsepower that can integrated in version control and calculate execution time/cost.

Usability

Other Software Used

PhpStorm

MySQL Workbench - Good software for remote database connection

Use Cases and Deployment Scope

MySQL Workbench allows us to connect the database of remote and local servers easily. It allows easy features to check the table, it's schema, data and allows manipulation. We can easily view and modify data as needed. It is one of the best software to connect and manage data remotely.

Pros

  • Data Retrieval
  • Data Manipulation
  • Schema View

Cons

  • Error Handling
  • Connection of the database
  • Simple approach to view table and it's schema

Return on Investment

  • 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.

Usability

Alternatives Considered

phpMyAdmin and SQLyog

Other Software Used

phpMyAdmin, SQLyog, Laravel PHP Framework, WooCommerce

It does what expected, but you need to learn how to use it

Use Cases and Deployment Scope

We use it to make various queries to our DB to get the data for analytical purposes.

Pros

  • Send queries to DB
  • Export results in csv

Cons

  • 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)

Usability

Alternatives Considered

Azure Database

Other Software Used

Azure SQL Database, Microsoft Excel, ChatGPT