Is there any tool/software the can export all the tables structure (column names , its datatype ) in the database as a pdf/excel/word. additional diagram export will be added advantage.


You need a Entity Relation Diagram (ERD) generator. The most popular and advanced one that I know of that is FOSS is SchemaCrawler.

It does everything you want anyway. Though the diagrams are generated with Graphviz (so don't expect Visio quality).

You may want to go scavenger hunting through different graphviz viewers. This one using d3 seems to be pretty decent.

| improve this answer | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.