Autogenerated database documentation is often pretty hit and miss but tbls[1] does a pretty good job in that space. Especially when you comment on your tables, fields, views, functions etc (which is a good habit anyway!) the output is quite useful

[1] https://github.com/k1LoW/tbls

In a similar vein there is Schemaspy[1]. It generates a static documentation website for your DB, which also uses GraphViz to build ER diagrams.

[1] https://github.com/schemaspy/schemaspy

That looks really cool. Would you possibly share the script?

It's part of the repo.

https://github.com/enter-haken/schema/blob/master/schema.sh

It's a mixture of sed, awk and sql.

Oh I did take a quick look at the repo but didn't notice it was in the SQL. Thank you!