SchemaSpy: A Graphical Database Schema Metadata Browser

SchemaSpy is a Java-based tool that analyzes the metadata of a schema in a database and generates a visual representation of it in a browser-displayable format. It lets you click through the hierarchy of database tables via child and parent table relationships as represented by both HTML links and entity-relationship diagrams. It’s also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.

This is an excellent tool in its own right; and if nothing else for its beautiful use of Graphviz.

See the example(s) here.

Leave a Reply

Your email address will not be published. Required fields are marked *