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 database diagram

Trevor.io

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.

LucidChart

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).

Creately

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

  • Link: dbdiagram.io/home
  • Price: Free
  • Usecase: draw ER diagrams by just writing code.
  • Try it without creating an account here.
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

  • Link: Erdplus.com
  • Price: free
  • Usecase: create Entity Relationship Diagrams, Relational Schemas, Star Schemas, and SQL DDL statements
  • 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

  • Link: Drawsql.app
  • Price: free (for public diagrams only, up to 15 tables)
  • Usecase: create, visualize and collaborate on your database entity relationship diagrams

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

  • Link: Quickdatabasediagrams.com
  • Price: free (for public diagrams only, up to 10 tables)
  • Usecase: draw a database diagram by typing code
  • Try it without creating an account here.
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.

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.

Subscribe to stay updated

Our infrequent updates will make you happy ­čÖé View our privacy policy

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

Leave a Reply

Subscribe to stay updatedOur infrequent emails will make you happy ­čÖé