Last answered:

12 Nov 2022

Posted on:

23 Dec 2021


Resolved: How to get diagram in SQL Workbench

Is there a way to get diagram like the picture below in SQL Workbench? Thank you.


3 answers ( 1 marked as helpful)
Posted on:

04 Feb 2022


Hi Thai!

Yes, there is a way to do it in Workbench. Please, follow these steps:

  1. First make sure you have a Database and Tables created on the MySQL server.

  2. Click on Database -> Reverse Engineer.

  3. Select your stored connection (for connecting to your MySQL Server in which database is present) from the dropdown. Then click Next.

  4. After the execution gets completed successfully (connection to DBMS), click Next.

  5. Select your Database from the MySQL Server for which you want to create the ER Diagram (in our case the database name is***“employees”***), then click Next.

  6. After the retrieval gets completed successfully for the selected Database, click Next.

  7. Select the Tables of the Database which you want to be visible on the ER Diagram (usually all the tables of the DB), then click Execute>.

  8. After the Reverse Engineering Process gets completed successfully, click Next.

  9. Click Finish.

Now you can see the ER Diagram of the Database.

Hope this helps.

Posted on:

29 Sept 2022


Insightful way to depict the complete schema! Thank you so much!

Posted on:

12 Nov 2022


Edsson Thank you for question and Tsvetelin Thanks a bunch for powerful answer

Submit an answer