Show HN: Databasediagram.com – Private, Text to Entity-Relationship Diagram Tool

1. dbml

   1 6 2,987 9.6 JavaScript

   Database Markup Language (DBML), designed to define and document database structures

   

   We've been using https://dbdiagram.io/, which also has an open-source markup language: https://github.com/holistics/dbml

2. SaaSHub

   www.saashub.com featured

   SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives

   

3. spark-joy

   2 39 9,442 6.2 JavaScript

   ✨😂 2000+ ways to add design flair, user delight, and whimsy to your product.

   

   ive been a keeping a list of other diagramming tools too https://github.com/swyxio/spark-joy/blob/master/README.md#di...

4. d2

   3 97 19,302 9.6 JavaScript

   D2 is a modern diagram scripting language that turns text to diagrams.

   

   The issue I have with a lot of these tools is they work fine when depicting relationships between tables in the same schema (talking mainly about PostgreSQL databases), but few support showing relationships between tables across different schemas.

   Also, when the number of tables grows large, few have layouts arranged in an optimal way. I use D2 (https://d2lang.com/) to create ERDs. However, of the free layout engines available in D2, Dagre (https://github.com/dagrejs/dagre) and ELK (https://github.com/eclipse/elk) both don't have optimal placement of layouts for a sufficiently complicated database.

5. dagre

   4 10 4,817 7.2 JavaScript

   Directed graph layout for JavaScript

   

   The issue I have with a lot of these tools is they work fine when depicting relationships between tables in the same schema (talking mainly about PostgreSQL databases), but few support showing relationships between tables across different schemas.

   Also, when the number of tables grows large, few have layouts arranged in an optimal way. I use D2 (https://d2lang.com/) to create ERDs. However, of the free layout engines available in D2, Dagre (https://github.com/dagrejs/dagre) and ELK (https://github.com/eclipse/elk) both don't have optimal placement of layouts for a sufficiently complicated database.

6. elk

   5 3 265 7.6 Java

   Eclipse Layout Kernel - Automatic layout for Java applications. (by eclipse-elk)

   

   The issue I have with a lot of these tools is they work fine when depicting relationships between tables in the same schema (talking mainly about PostgreSQL databases), but few support showing relationships between tables across different schemas.

   Also, when the number of tables grows large, few have layouts arranged in an optimal way. I use D2 (https://d2lang.com/) to create ERDs. However, of the free layout engines available in D2, Dagre (https://github.com/dagrejs/dagre) and ELK (https://github.com/eclipse/elk) both don't have optimal placement of layouts for a sufficiently complicated database.

7. sqlparse

   6 7 3,802 8.0 Python

   A non-validating SQL parser module for Python

   

   Suggest checking out the sqlparse library for a way to do the different flavours without needing to address each case directly: https://github.com/andialbrecht/sqlparse

8. Mermaid

   7 97 4,482 8.9 TypeScript

   Edit, preview and share mermaid charts/diagrams. New implementation of the live editor.

   

   ditto, it's very impressive with all types of mermaid [0] diagrams! even helps w/ styling and formatting tweaks. It's helped me so much with better 'coverage' and maintainability on diagrams for projects I'm working on.

   0. https://mermaid.live/

Suggest a related project