ER diagram tool

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

Do you have any examples of ER diagrams to help me get started?

Yes. Simply navigate to the template gallery and select an example entity-relationship diagram for inspiration, or customize the template to reflect your specific process.

Learn more
Can I import my database structure to create an ERD and automate the process?

Yes! Our ER diagram tool includes an import feature that allows you to upload your database tables and schemas directly to your Lucidchart toolbox. From there, drag each of your tables onto the canvas, and Lucidchart will automatically draw lines between entities, based on the relationships in your database structure.

Learn more
How do I create an ERD from scratch?

You can create an ERD from scratch using the entity relationship shape library in the shape manager. Manually label entities, attributes, and keys, and determine all appropriate relationships and cardinalities.

Learn more
How can I map my current Salesforce schema in Lucidchart without having to create it from scratch?

Use our Salesforce schema import. Admins can map out the architecture of their Salesforce instances by easily importing existing schema from Salesforce directly into the Lucidchart editor and automatically generating a diagram.

Learn more
Can I export my ER diagrams once I'm finished?

Yes! You can export your ERD into code. When you go to export, simply choose your preferred database management system. Some options include MySQL, PostgreSQL, SQL Server, and Oracle.

Learn more

Simplify ER diagrams with Lucidchart