TIL: about Entity Relationship Schemas

• plantuml2mysql

  1 114 10.0 Python

  This utility parses PlantUML class diagram and generates SQL DDL for MySQL

You also have PlantUML. There exists an SQL generator for MySQL - not tested - and this utility for generating PlantUML ERD from PostgreSQL tables. This tool is more focussed on communication and allows you to draw large diagrams. However, you loose the sync between the diagram and the code base. You have the official PlantUML on-line drawer.

• planter

  4 532 4.3 Go

  Generate PlantUML ER diagram textual description from PostgreSQL tables

You also have PlantUML. There exists an SQL generator for MySQL - not tested - and this utility for generating PlantUML ERD from PostgreSQL tables. This tool is more focussed on communication and allows you to draw large diagrams. However, you loose the sync between the diagram and the code base. You have the official PlantUML on-line drawer.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• ecto_erd

  1 205 4.8 Elixir

  A mix task for generating Entity Relationship Diagram from Ecto schemas available in your project.

finally, the add-ons tools any framework has to build ERd. For example, with Elixir/Ecto project, you have the project ecto_erd. This generates an ERD from your schema (model), not from the migration.

• pgadmin4

  44 2,096 9.7 Python

  pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.

  

the build-in ER tool for PostgreSQL included in pgAdmin. You can design a database with it, and conversely, generate an ERD snapshot from an existing database. You can quickly learn how to use it with this video.

Suggest a related project