How to create ER diagram for existing database with DataGrip

In this tutorial I will show you how to create Entity-Relationship Diagram (ERD) with DataGrip.

From View toolbar select Tool Windows -> Database or press Alt + 1 combination.

Fig. 1. Database in toolbar

In Database window find your connection and database. Select appropriate tables or even all schemas and right click on it. From context menu choose Diagrams -> Show Visualization… or CTRL + ALT + SHIFT + U shortcut.

Fig. 2. Generate diagram with selected tables

You can save generated report as image by right click anywhere in diagram area and select Export to file from menu or by click on export icon below tabs.

Fig. 3. Exporting database diagram to file

You will be asked for choosing a destination path and file format. After clicking OK, ready ERD will be placed in provided path.

Click here to see sample AdventureWorks2017 Entity-Relationship Diagram.

Comments are only visible when the visitor has consented to statistics cookies. To see and add comments please accept statistics cookies.
0
There are no comments. Click here to write the first comment.