schemaspy VS tbls

You might try https://schemaspy.org/ - it generates a website with ER diagrams that only go one or two relationships out, but they have clickable table names to get to the next diagram

I had the same problem when i started my job. I used SchemaSpy to generate an html with all of metadata and ERD diagrams as a reference point. Then i used dbt to connect to the database and used dbt to document the table and column that i have worked on. It takes time to document but it's worth it if you company don't have your database documented yet.

SchemaSpy is a standalone application that connects to the database, scans its tables and schemas, and generated nicely composed HTML documentation. You can check out an example sample by this link but I'm showing you just one screenshot to clarify my point.

I like https://schemaspy.org/

I like the diagrams and reports SchemaSpy generates. If you are using a DBMS that allows setting comments to tables, views, columns (and other objects), those will be included and that makes those reports even more helpful

https://schemaspy.org/ creates nice looking diagrams.

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-database comments combined with something like https://github.com/k1LoW/tbls make for very cheap database documentation.

No affiliation with tbls except that I'm a big fan

Check out tbls. You can create a ERD in one command