How do you create a database diagram?

Generate a diagram for a database object

• In the Database Explorer (), right-click a database object and select .

Build a query plan

1. Right-click an SQL statement, and select Explain Plan.

2. By default, you see the tree representation of the query in the Plan pane. To see the query plan, click Show Visualization , or press Ctrl+Alt+Shift+U.

Enable column comments

1. Generate a diagram. For more information about generating a diagram, see Generate a diagram for a database object.

2. Click the Comments button ().

Apply colors to diagram objects

1. In the Database Explorer (), right-click an object and select .

2. Select a color and click OK.

Save diagrams in the UML format

This UML format is an internal format supported only by DataGrip.

• Right-click a diagram and navigate to .

  To open the saved diagram, drag the UML file to the editor.

Save diagrams in the PNG format

• Right-click a diagram and select .

Analyze graph

The Analyze Graph action group lets you analyze the graph in various ways such as perform auto clusterization, measure the node centrality, search cycles, filter path between two nodes, and so on.

Filter paths between two nodes

Most of the time, generated diagrams are big and complicated. Typically, you want to concentrate only on the specific part of the diagram. DataGrip lets you filter paths between two diagram elements.

1. In the diagram editor, select two nodes on which you want to focus and right-click one of them to open the context menu.

2. From the context menu, select Analyze Graph | Focus on Paths between Two Nodes.

3. In the dialog that opens, select additional options if needed and click Find.

   DataGrip displays connections associated only with the selected nodes.

Measure diagram centrality

You can use this action to identify the important nodes in the graph.

1. In the diagram editor, right-click anywhere in the editor to open the context menu.

2. From the context menu, select Analyze Graph | Measure Centrality.

3. In the dialog that opens, select additional options if needed and click Measure.

   The node "importance" is expressed via fractional value from 0.0 to 1.0 measurement and the brightest node selection should be explored first.

Diagram configuration settings

To configure the default visibility settings and layout for diagrams, open settings by pressing Ctrl+Alt+S and navigate to .

Content pane

Select the checkboxes next to the elements to be shown on diagrams.

Item	Description
Show Difference
Details	If this checkbox is selected, all the specified details of the elements will be shown in the UML class diagram for a revision. If this checkbox is not selected, only node elements will be included in the diagram.
Database Schema Diagram
Key columns	For the primary key columns to be shown when a diagram opens, select this checkbox. When viewing a diagram in the editor, use on the toolbar to show or hide the corresponding columns.
Columns	For the columns other than the primary key columns to be shown when a diagram opens, select this checkbox. When viewing a diagram in the editor, use on the toolbar to show or hide the corresponding columns.
Graphical Explain Plan
Attributes	Toggles the display of query attributes on a query map. These attributes can be a number of rows, index names, or any other additional information about the query.