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.
License: GNU Lesser General Public License (LGPL)
Changes:
Many additional metadata settings can now be specified via XML. The compact view of the relationships page now hides non-PK/non-indexed columns to reduce clutter and clarify the relationships. jQuery is now used for DOM manipulation. Support has been added for Derby (JavaDB) databases, both embedded and network, along with SQL Server with the jTDS driver, SQL Server 2005, and MaxDB. A new option for evaluating multiples with databases like MySQL where a database isn't composed of multiple schemas. Significantly improved performance of generation of entity-relationship diagrams. Many additional bugs were fixed.
