Recently I have tried to parse mongoose
schema definitions to some meaningful db markdown to visualize the data models connections.
Original choice was mermaid
(Entity Relationship Diagrams
) however after producing the diagram for 50+
collections with 150+
relations it appeared to be unusable and not something you can deal with.
Another option was dbml
. Once I finally produced the valid dbml
definitions I have pasted them at https://dbdiagram.io/. You still need to manually move the blocks to visualize the relationships better, but looks much more promising now.
Few notes regarding https://dbdiagram.io/:
- Exports are available to
PDF, PNG, SVG
- Export is also possible to
SQL
forPostreSQL/Oracle/MySQL/SQL Server
- No (at least I have not found) any way to export the diagram's meta data (e.g. if I create new db and add the same definition I will need to move again the blocks manually, which is not a great experience); however update the definitions in the existing db model works fine and does not reset the position of the moved items.
- Purchased
Personal Pro
subscription to play with that for a while and to be able to share model internally with couple team mates.
2025-06-03