What is MySQL Workbench. Find an overview

MySQL Workbench is a  visual GUI based mysql database management and development tool for database developers, architects, designers and database administrator. MySQL Workbench provides Database Administrator (DBA) and developers an integrated tools for:

• Database Designing & Modeling
• SQL database Development
• MySQL Database Administration tools for server configuration, user administration, and much more
• Database Migration

MySQL Workbench is available for Windows, Linux and Mac Operating systems.

 To download MySQL workbench clich here

Installation of workbench is very easy. Just download the MySQL Workbench software file and save it in your desired folder and run the file and follow the step by step instructions.

In previous blog  What is MySQL Database Server. How to download and install MySQL Server and Workbench at Windows, we also installed MySQL workbench with MySQL Database Server.

MySQL Workbench has provided an easy way for Database server administration, designing, development, and forward & reverse engineering of database.


Below snapshot is showing the workbench home page overview

SQL Visual Design:

MySQL Workbench enables a DBA, developer, or data architect to visually database design, model and to  generate the database and managed it. It includes everything a data modeler needs for creating complex ER models, forward and reverse engineering, and also delivers key features for performing difficult change management and documentation tasks that normally require much time and effort.


Below snapshot is showing the workbench SQL Visual database design overview

SQL Database Development

MySQL Workbench  provides the visual tools for creating, executing, and optimizing the SQL queries. The Database Connections Panel enables developers to easily manage database connections. The SQL Editor panel provides the reuse of SQL snippets, color syntax highlighting and execution SQL history. The Object Browser provides an instant access to schema s and objects of database.

Database Server Administration

Workbench provides an easily and visually administer MySQL environments and has gained better visibility of databases. DBA and developers can use the visual tools for configuring the servers, administering the users and viewing the database health.

Database Migration

MySQL Workbench is now providing a complete and easy to use solution for migrating of Microsoft SQL Server, Sybase ASE, PostreSQL, and other RDBMS tables, objects and data to MySQL database. DBAs and developers can easily convert existing applications to run on MySQL database server for both on Windows and other platforms. It is also support migrating from old versions of MySQL to the latest version.