DEV Community

Discussion on: Generate Mermaid Diagrams for Your Database

View post
Collapse
 
lastlink profile image
lastlink •

Got a better example of this working see github.com/Software-Developers-IRL....

To run on windows cmd.exe:

          docker run ^
            -v "%cd%":/home/schcrwlr/share ^
            --name schemacrawler ^
            --rm -i -t ^
            --entrypoint="/bin/bash" ^
            schemacrawler/schemacrawler
Enter fullscreen mode Exit fullscreen mode

run mermaid script, need to have the mermaid.py and sqlite file in the same directory where you launched

      schemacrawler \
        --server=sqlite --database=./share/chinook-database-2.0.1.sqlite \
        --info-level=maximum \
        --command script \
        --script-language python \
        --script ./share/mermaid.py > ./share/output.md
Enter fullscreen mode Exit fullscreen mode
Collapse
 
lastlink profile image
lastlink •

Package now released. You can generate sql DDLs from markdown mermaid erDiagram.
See npmjs.com/package/@funktechno/litt....