Open source reader

Tuesday, May 16, 2006

a java opensource graphical DB schema generator

SchemaSpy is ...
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. The browsing through relationships can occur though HTML links and/or though the graphical representation of the relationships. It's also designed to help resolve the obtuse errors that a database sometimes gives related to failures due to constraints.
Here a browsable sample and the generated image schema:

And yes, for those who recognized this kind of graphs: SchemaSpy is using the great graphviz library.


Post a Comment

<< Home