simple-ddl-parser icon indicating copy to clipboard operation
simple-ddl-parser copied to clipboard

Published 20 hours ago • verified publisher icon xnuinside

Generate output for Mermaid, Graphviz, PlantUML or other "graphics" format

Open rbanffy opened this issue 2 years ago • 2 comments

Is your feature request related to a problem? Please describe. As part of a CI pipeline, it'd be useful to document SQL DDL as ER diagrams. Graphviz, Mermaid, PlantUML are all tools that can output graphics from a textual representation.

Describe the solution you'd like Setting the output format to one of these should do the trick

Describe alternatives you've considered I was about to write my own (https://dba.stackexchange.com/questions/311402/) didn't show any already existing tools.

Additional context N/A

rbanffy avatar Jun 08 '22 10:06 rbanffy

@rbanffy hi, interesting topic, what I got quick in the mind, for example, exists: https://dbdiagram.io/ that uses https://www.dbml.org/home/ DBML language to draw ER diagrams. You can import SQL DDL in dbdiagram and it will auto convert to DBML & ER diagram Screen Shot 2022-06-08 at 2 14 09 PM

xnuinside avatar Jun 08 '22 10:06 xnuinside

I was looking at the output code and it wouldn't be trivial to add this - the output module assumes (very reasonably) that the output will be some sort of SQL DDL. Would you mind if I tried?

rbanffy avatar Jun 09 '22 14:06 rbanffy