ER diagram tool

Lucidchart is a visual workspace that combines diagramming, data visualization, and collaboration to accelerate understanding and drive innovation. 

Watch the Video
or
Google Markor sign up with Google

By registering I agree to Lucid Software's Terms of Service and Privacy Policy.

ER Diagram tool

Why choose Lucidchart as your ERD maker

  • Visualize relationships with our entity relationship modeling tool

    Visualize relationships with our entity relationship modeling tool

    Entity relationship diagrams (ERDs) help you understand relationships between entities within a system, such as customers, products, or order IDs. An entity relationship diagram tool like Lucidchart helps you conceptualize your database design before you build it, including the overall structure and the ways different types of data interact, if at all. So, if you’re designing, patching, or debugging relational databases for software engineering, business information systems, or another industry, create ER diagrams online to better visualize your schemas, while spotting and correcting flaws early on.

  • Easily diagram using ERD templates, symbols, and notations

    Easily diagram using ERD templates, symbols, and notations

    Our ER diagram tool simplifies database modeling, whether your diagrams are conceptual or physical. Drag and drop standard ERD shapes and symbols onto the canvas within seconds using our ER diagram creator. Differentiate relationships, entities, and their attributes. Include tables, fields, and primary or foreign keys, then connect each entity with specific crow’s foot notations to indicate the cardinality and ordinality of each entity. Or, select and customize a template by swapping symbols and notations to match your database structure.

  • Import your database structure

    Import your database structure

    Lucidchart makes it easy to visualize your database structure and build ER diagrams online.  Our ER diagram generator automatically generates an ERD and draws relationship lines when you import your database tables and schemas directly to your toolbox. Worry less about updating your diagrams every time you make a change—Lucidchart updates your fields whenever you import new or revised database files. Export your diagram to your database management system, including MySQL, PostgreSQL, SQL Server, or Oracle.

  • Import your Salesforce schema

    Import your Salesforce schema

    Contrary to other ER diagram tools, Lucidchart eases the pain of managing your Salesforce database with our Salesforce schema builder. As a Salesforce admin or consultant, you can optimize your CRM faster and easier than ever before. Lucidchart automatically generates an ERD—all you have to do is simply import your Salesforce schema. Within seconds, start visualizing tables and relationships, and begin restructuring symbols and entities to discover new ways to customize your CRM.

  • Collaborate and share with anyone, anywhere, anytime

    Collaborate and share with anyone, anywhere, anytime

    Invite team members to help you quickly assess the accuracy of your ERD as it grows larger and more complex. Lucidchart makes it easy to collaborate in real time as you draw ER diagrams online, whether your teams use Mac, PC, or Linux. Share your document via email or URL, and use @mention notifications and the comment locator to direct individuals to specific parts of your diagram. You can also export your diagram to Jira or Confluence or include it in a company presentation to facilitate understanding among individuals with different levels of technical knowledge. 

How to draw ER diagrams online in Lucidchart

1

Enable ERD shape libraries

Open the shape manager by pressing M on your keyboard. From there, simply select the “Entity Relationship” library, which includes standard ERD shapes and the ERD import/export.

2

Determine the entities from your database

Entities represent a table in your database. Depending on the subject of your diagram, your entity could be a customer, product, or even a physical location, like a bank.

3

Identify the relationships between entities

Relationships highlight how entities will interact with each other, if at all. Indicate entity relationships by drawing lines between them and then adding the appropriate cardinality on each end.

4

Add all necessary entity attributes

Attributes are the specific properties or traits of an entity that are important in your model, such as the first and last name of a customer entity. Add your attributes and the associated primary and foreign keys.

5

Export your ERD to the DBMS of your choice

Lucidchart automatically generates the code you need to translate your ERD into your DBMS. Simply click export, located below your entity relationship shapes, and select your preferred database system.

Frequently asked questions about ERDs

Simplify ER diagrams with Lucidchart

Browse ER diagram templates

Entity Relationship Diagram Example