Create Entity Relationship diagrams (ERDs) with customized text, styling, and relationships between fields. Automatically generate database tables and schemas using our SQL import feature.

Watch this video to learn more about ERDs, then read the tutorial below to learn how to make one in Lucidchart.

ERD overview

An Entity Relationship diagram (ERD) is a visual representation of a database that shows how the elements within are related. An ER diagram is made up of two object types—entities and relationships. An entity in this context is a component of data from the dataset, shown as a shape on the canvas. The relationships between entities are represented as lines that have special line endings called cardinalities, which describe how two elements of the database interact with each other.

Import your database

The ERD import feature uploads all of your database tables and schemas directly to your shape menu. You can import updated database files at any time, and the fields will be updated in the shape menu and on the canvas.

To import your database components, follow these steps:

Open the Shape Library Manager by clicking + Shape Library at the bottom of the shape menu.
Search for the “Entity Relationship” shape library.
Click the checkbox next to “Entity Relationship”.
Select Use selected shapes.
Click Import from the Entity Relationship shape library.
In the import menu, select the Database Management System (DBMS) you use.
Click Copy to Clipboard to copy the query.
Paste and run the query on your database.
Select Next.
Click Choose File to Import your .CSV, .TSV, or .TXT file.
- Alternatively, copy and paste the query results in the open text area.
Click Import.

Lucidchart immediately converts the imported query into a list of databases, tables, and schemas and organizes the list in your shape menu. Each collapsible section of the shape menu represents a database. The names inside a section correspond with database tables. An additional subsection would indicate a schema.

You can then drag the database tables from the shape menu onto the canvas. If you have properly set up the primary and foreign keys, when you drag related tables onto the canvas, Lucidchart draws relationship lines automatically.

Import Your Salesforce Schema

With the Schema Import from Salesforce, admins can map out the architecture of their Salesforce instances.

Note: This feature is available only on Enterprise accounts and is not available to users in the FedRAMP environment. To learn more, see our FedRAMP overview article.

To import your schema, follow these steps:

Open the Shape Library Manager by clicking + Shape Library at the bottom of the shape menu.
Search for the “Entity Relationship” shape library.
Click the checkbox next to “Entity Relationship”.
Select Use selected shapes.
Click the Salesforce Import button in the Entity Relationship shape library.
In the dialog that pops up, click Import from Salesforce.
The next window will prompt you to sign in to Salesforce. Click Continue.
If you have not linked to Salesforce before, the next window will prompt you to grant Lucidchart permission to access your Salesforce account. Click Allow.
- You can revoke access at any time in your Lucid account settings.
- If you encounter an error message after this step, please check your login IP Ranges under your Salesforce user profile and make sure that those ranges are not restricted.
In the next window, select which Salesforce objects you would like to import into Lucidchart.
- Search for specific objects using the search bar at the top. If no objects are found, you will be prompted to adjust your search term.
Select between “Show only relationships” or “Show all object details.”
Click Import.

Manually create or edit an ERD

You can create an ERD manually using the Entity Relationship shape library. You can do this by dragging out shapes from the shape library and adding relationships, text, and styling.

Add or remove fields

To add or remove fields, select the shape or click Screen_Shot_2022-04-20_at_9.32.54_AM.png

Screen_Shot_2022-04-20_at_9.32.54_AM.png

in the upper-right corner of the canvas to open the Entity Contextual Panel. In Advanced Options drop-down, indicate the number of fields needed.

Add text

Double-click on the text to enter text edit mode.

Once you have selected a text box, you can press:

Tab on your keyboard to move to the next row.
Shift+Tab to go to the previous row.
Enter or click off the object to exit.

Adjust entity size

To change the size of an object, click and drag from one of the corners and extend to either side. As you move an object, the columns will auto-adjust to fit the content inside.

Add lines

Create a relationship line between two entities by clicking and dragging from any dot on an object. You can drag the line to another shape and create a relationship to a specific field.

You can also drag and release the cursor over the canvas to auto-prompt adding a new entity object.

Note: If you decide to add or remove fields after you have created a relationship, any connected lines will move with the fields they are attached to. There is no need to redraw them.

Format lines

To add formatting to the lines of your ERD, select the line and use the drop-down menu in the properties bar to assign new cardinalities to each of the line's endpoints. The default line for an ERD is the starting point of the screen recording below.

Cardinalities

Cardinalities represent the relationships between databases, or entities. Each line connection contains different symbols to reflect the type of relationship between the entities.

Use this guide to understand the cardinality each symbol represents:

Add style

You can use the advanced shape bar to adjust the shading of your entity objects. Here are your options for doing so:

Add shading to alternate rows of a table or to the table header using Advanced Options in the Entity Contextual Panel.
Change the color of the shading of the header or alternate rows.

Use the formatting bar across the top of the canvas to style entity objects while they are selected. You can:

Modify text format, size, color, font, and alignment.
Adjust line thickness and color.
Style shapes by adding color, gradient, and images.

Tip: Enhance your ERD by color-coding and adding a key. Read our Diagram Keys article for more information.

Export an ERD

Export your ERD to the DBMS of your choice (with the exception of connections between tables).

To export your entire page, follow these steps:

In the Entity Relationship shape library, click Export.
An "Export to SQL" dialog box will appear. Choose a DBMS from the menu.
Click Copy to Clipboard to copy the correct statement for the entire page.
Click Done.

FAQs

Why are the relationships between the shapes of my diagram not showing up?

When Lucidchart is not drawing lines between the entities of your imported ERD, it is likely that your data file does not indicate the relationships using primary and foreign keys. To check this, please open your data file and make sure that the cells at the end of each row are populated with information about the relationships between entities.

Are there any limitations on exporting my ERD?

If you are exporting your ERD to Quickbase, there is a maximum limit of 80 tables and 50 connections. Otherwise, if you are exporting in another format, there are no hard limits.

Resources

Community Post

Represent the relationships between your databases by building an ERD!

Templates

Database ER diagram (crow’s foot)

DBMS ER diagram (UML notation)