How to create ER diagram for existing database with DataGrip

Bart Gawrych - Dataedo Team Bart Gawrych 2019-09-17

Table of Contents:

    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.

    There are no comments. Click here to write the first comment.

    By continuing to use our website, you consent to the use of cookies in accordance with our Privacy Policy (updated 28-04-2020).