SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database and can identify Ruby on Rails style databases, as well as other implied relationships.
|Tags||Database Front-Ends reverse engineering entity relationship diagrams Oracle DB2 MySQL SQLite MSSQL Informix|
|Operating Systems||OS Independent|
Release Notes: SQL was added for querying view details for MySQL databases. On the tables tab, you can now view tables and views separately as well as hide comments. The columns page has been trimmed down to help resolve loading issues on large (e.g. 20,000 table) schemas. A -gv option was added to no longer require finding Graphviz on the path. Hooks were added to allow for custom formatting of view SQL. DB2 Materialized Query Tables (MQTs) are treated as views. A new option was added to prompt for the password, so it doesn't appear on the command line. Many additional bugs were fixed.
Release Notes: This release resolves issues with the extends directive as well as null IDs on DB2 views.
Release Notes: This release can fully evaluate Ruby on Rails databases that associate foreign keys to primary tables/keys with a translation of singular to plural form. It resolves a bug where SchemaSpy was using incorrect entity relationship diagram notation. It adds support for MS SQL Server 2005 with jTDS driver, including column comment retrieval for all of the MS SQL databases. You can now specify database connection properties on the command line. There is a new -sso option to support single sign-on databases.
Release Notes: 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.
Release Notes: This is a bugfix release primarily intended to address the Graphviz 2.9+ changes that broke SchemaSpy. It fixes bug 1602135 (an exception using dot version 2.9), bug 1571711 (failure to use a precompiled version of dot on Mac OS X), and bug 1597609 (quoting and Sybase ASE).