Blog home

Top 7 tools to create an Entity Relationship Diagram (ERD), 2020

Written by

Harry Marshall

Last updated on

January 10, 2023

Before you jump in...

Looking to embed lightning-fast dashboards in your website? Check out our brand new customer-facing analytics platform, Embeddable.com.

Check it out

An entity relationship diagram, ER Diagram, or ERD, is a visual model of your database schema. It shows your tables as boxes, with connecting lines representing the relationships between them. It's a great way to design a new relational database or make sense of and/or modify an existing one.

Top 7 tools for drawing your own ER Diagram

Trevor.ioGenerate an ER Diagram from your existing SQL database online, automaticallyLink: Trevor.io/create-an-er-diagram-onlinePrice: paidRequirement: you need an existing online database (localhost not supported)Trevor.io is a BI tool used by startups and companies around the world. It's great for exploring and visualizing data, and answering ad hoc questions, day-to-day. Trevor.io has an impressive ER diagram tool that lets you add your existing database tables at the click of a button. Out of the box, Trevor detects your tables, columns, and joins (using foreign keys and also naming conventions) so your diagram stays automatically up-to-date.  With features like zoom, and automatic highlighting of related tables and relationships,  it's easy to map even large diagrams very quickly and without having to draw anything yourself.

Other popular blog posts: 6 Metabase Alternatives You Don't Need a Data Team to Use

LucidChart

Draw ER diagrams using templates, symbols, and notations

LucidChart ER diagram example

LucidChart is "the visual workspace for remote teams".  It's an incredibly flexible tool, enabling you to model diagrams from scratch using templates, symbols, and notations. You can also import your own database to streamline ERD creation. LucidChart has plenty of collaboration options so you can work on the diagram with your teammates collectively (with features like sticky notes, comments, and mentions).

Related Post: The Top 7 PowerBI Alternatives to Empower Your Non-Tech Teams

Creately

Design and visualize information systems, easily

Creately ER diagram interface example

Creately is a tool for drawing diagram, flowcharts, and mindmaps. It has an impressive shape library,  complete with smart connectors and preset "handpicked" color palettes and styles, enabling you to build even complicated diagrams. You can also start from a template (see the screenshot above). Collaborating on the same document with teammates is possible and you can also share a read-only version for review. When teammates make updates, you'll receive real-time updates - nice!

According to their website, Creately is already used by over 4 million people - woah!

DBDiagram

Draw ER diagrams by just writing code.

dbdiagram interface example

DBDiagram lets you create your diagram simply by writing code, using dbdiagram's own database markup language. SQL statements are generated to create your database tables, which speeds up actually creating the database you design. You can also export to images and also pdfs - woop! Share your diagrams online with your colleagues and customers with just one click.

ERDPlus

Create Entity Relationship Diagrams, Relational Schemas, Star Schemas, and SQL DDL statements

  • Link: Erdplus.com
  • Price: free
  • You can play with ERDPlus here, without creating an account.

ERDPlus is a web-based database modeling tool. You build your diagram by adding shapes and connecting lines, and can then export the generated SQL. ERDPLus has a somewhat dated design, but is held in high regard in the industry.

DrawSQL

Create, visualize and collaborate on your database entity relationship diagrams

  • Link: Drawsql.app
  • Price: free (for public diagrams only, up to 15 tables)

A simple, well-designed tool to manually build your diagram or import from an existing database.  They have a template gallery with over 200 diagrams to choose from. You can annotate tables and columns and also share a read-only version in 'presentation mode' - - super useful for explaining things to your teammates and other stakeholders.

QuickDBD

Draw a database diagram by typing code

QuickDBD example interface ER diagram

QuickDBD lets you draw schemas rapidly just by typing, in a similar way to DBDiagram (above). Easily share your diagram with teammates via a simple share-link. Import a diagram from certain databases (MySQL, MariaDB, Oracle, SQL Server). Export the generated SQL to create the database you've designed.

ER Draw Max

ER Draw Max is a multi-purpose graphics tool that lets you create all sorts of diagrams, including ER Diagrams. It comes with an out of the box option dedicated to Entity Relationship Diagrams (i.e. database diagrams).

  • Link: https://www.edrawmax.com/
  • Price: $99 per year.
  • View a walkthrough here.

There we have it!

The most relevant tool for you will depend on what you're hoping to achieve.

If you're modelling an existing database, want to get it done fast, and have it stay up to date, try Trevor.io.

If you're creating something new and prefer code over a GUI, try QuickDBB or DBDiagram.

If you require more flexibility and have a bit more time to spend creating and maintaining your diagram, try LucidChart.