This program is used for database development. Users can create visual models that display table structures. An integrated SQL query editor is also available.
MySQL Workbench
MySQL Workbench is a utility for Windows that offers you to create databases. Thanks to this application, you can access a tool for visual modeling. Thus, there is an option to visualize all tables, keys, processes, and connections between them. The software allows you to create new types of MySQL databases.
Development
There is a design mode where each table is represented as a separate area containing the names of keys and headers. It is necessary to arrange elements in the required order and create links between them. Column names can be added as well.
You can access a drawing toolbar on the left side of the workspace. It is possible to add comments and group several tables. Furthermore, this utility supports a list view mode for components. The structure of an existing database can be exported for editing and refinement.
Queries
In the process of development, you may create SQL queries and send them to the server. MySQL Workbench supports operator analysis and highlighting. Moreover, this app provides tools for writing scripts for automatically creating databases according to a template. You can also view query statistics.
Features
- designed for visual database design;
- users can create table structures and add connections between them;
- there is an integrated SQL query editor;
- it is possible to create scripts and connect extensions;
- free to download and use;
- compatible with modern Windows versions.