How to create ER Diagram of an existing database using MySQL Workbench

2019-11-05   Rishit Patel

The following step-by-step guide will help you create ER Diagram of an existing database using MySQL Workbench very easily.

Step 1:

Open your MySQL Workbench and click on Database. (You can also press Ctrl+R and skip first two steps)

How to create ER Diagram of an existing database using MySQL Workbench step 1

Step 2:

Now click on Reverse Engineer…

How to create ER Diagram of an existing database using MySQL Workbench step 1

Step 3:

Select your database connection and click on Next.

3 1

Step 4:

Click on Next when you see fetch finished.

4 1

Step 5:

Select the database schema for which you want to create the ER diagram and then click on Next.(You can select multiple databases also)

5 1

Also read: The Boot Process

Step 6:

Now, it will retrieve objects from the selected database and check results, after the blue ticks in similar to the image below appear and you see Finished, click on Next.

6 1

Step 7:

Now there will be option to select MySQL table objects to reverse engineer, it’s the objects for which you want to create the diagram, After selecting objects click on Execute.(Make sure that checkbox at bottom-left corner labeled as “Place imported objects on a diagram is checked)

7 1

Step 8:

Now click on Next.

8 1

Step 9:

Click on Close.

9 1

Step 10:

Now you will see the ER Diagram of an existing databasethat you have selected.

10 1

I hope you will find this tutorial on how to create ER Diagram of an existing database using MySQL Workbench helpful. If you have any suggestions or you need any help feel free to comment in the comment section below.