4 ms·
- a visual database diagram We are looking at sqldbm to visualize and document our DWH schema. It looks nice, but is cloud first and expensive if you want to co
by john_minsk 5y ago
- a visual database diagram
We are looking at sqldbm to visualize and document our DWH schema. It looks nice, but is cloud first and expensive if you want to collaborate.
How are you solving this issue?
- lf-non 5y agoA very lofi solution I have been using is tbls [1]. It is a native cli utility that generates documentation from db schema (and includes comments in the db as well). It can output in markdown with embedded svg diagrams (which is great for previewing in github) as well as yaml (which I use for generating models). It is not quite polished but works pretty well. Also all the db diagrams and docs are committed alongside code in the repo which is a big plus for me. [1] https://github.com/k1LoW/tbls https://github.com/k1LoW/tbls
- mjhagen 5y agoTools like this only emphasize my point I think. I've resorted to writing my own diagram (also in svg) and docs generator for our apps and those things are fun to write, but I can't help but feel like this was all better taken care of back in the early 2000s with SQL Server Enterprise Manager.
- etoulas 5y agoTo document your Schema, try https://schemaspy.org/ https://schemaspy.org/