How to Generate Database EER Diagrams from SQL Scripts using MySQL Workbench

MySQL Workbench makes it really easy to generate EER diagrams from SQL scripts. Follow below steps to make one for yourself. Download and install MySQL Workbench for your system. See below simple SQL commands, later I’ll use them to generate a sample diagram. 1create table country ( 2 id integer primary key, 3 name CHAR(55)); 4 5create table city ( 6 id integer primary key, 7 country_id integer, 8 name CHAR(55), 9 foreign key (country_id) references country(id)); Open MySQL Workbench and create a new model (File -> New Model).