Using SchemaSpy, a Java-based command-line interface tool, you can generate database schema documents from your database.
Generating Database Schema Documents
You must have Graphviz installed on your machine. Graphviz is required in the generation of the table/view relationships graph.
To generate your database schema documents:
- Open the command prompt and navigate to extensions/database/ext-schema-documentation
- Execute the command below to run Maven's site plugin and generate the documentation.
- Navigate to extensions/database/ext-schema-documentation/target/site/schemaspy
- Open index.html in a web browser to view the schema documents.