21–30 of 87 posts
I love tools like this (text to diagram) and tend to use mermaid for most things. I also really like draw.io which includes a gui and has integration with GitHub to save diagrams directly to a source repo. Is there a solution that has direct, bi-directional integration with Postgres/MySQL. For example, execute DDL from the diagram or point to an existing db and output the diagram text?
Looks like it's capable of turning a diagram to SQL too? That's neat!
For those that are interested in an GPT-powered tool, we have a project that can generate diagrams from code of any language or natural language: https://eraser.io/diagramgpt
Cool tool. My favorite tool for text to model / model to SQL is: https://app.quickdatabasediagrams.com/
Are there any Terraform-like declarative tools for your schemas that will do a diff and generate a change script?
I've seen liquibase and it's just a series of migrations which I think is pretty gross.
I really like MS's SSDT tools, but the DACPAC workflow is pretty heavy to operationalize, though doable.
Check it out at https://app.erdlab.io/designer/new
Has a lot more cool features for better visual representation like color tagging and search.
I also like the ability to create tables/notes using the canvas even though it has DDL support.
Since this thread is likely to attract good answers to this... Are there any Terraform-like declarative tools for your schemas that will do a diff and generate a change script? I've seen liquibase and it's just a series of migrations which I think is pretty gross. I really like MS's SSDT tools, but the DACPAC workflow is pretty heavy to operationalize, though doable.
It's mostly part of a JS/TS ORM, but it uses a declarative schema language, and there are libraries in other languages to parse and process it. E.g. https://prisma-client-py.readthedocs.io/en/stable/
But, if this is looking to be a big moneymaker? eh, nah.