SchemaSpy

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc) and can identify Ruby on Rails relationships. ... [More] Highlights of Release 5.0.0: - Added SQL to query 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. - Support for z/OS-based DB2 systems. - New option to exclude specific tables based on a regular expressions. - New -gv option to no longer require finding Graphviz on the path. - Now shows details about foreign key constraint deletion rules: cascade on delete, null on delete and restrict delete. - Added hooks to allow for custom formatting of view SQL. - Now treats DB2 Materialized Query Tables (MQTs) as views. - New -logLevel option to display verbose details of program flow. - New option to prompt for password so it doesn't appear on the process's command line. - New -noviews option that causes SchemaSpy exclude all views from its analysis. - Many additional bugs were fixed. [Less]

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc) and can identify Ruby on Rails ... [More] relationships. Highlights of Release 5.0.0: - Added SQL to query 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. - Support for z/OS-based DB2 systems. - New option to exclude specific tables based on a regular expressions. - New -gv option to no longer require finding Graphviz on the path. - Now shows details about foreign key constraint deletion rules: cascade on delete, null on delete and restrict delete. - Added hooks to allow for custom formatting of view SQL. - Now treats DB2 Materialized Query Tables (MQTs) as views. - New -logLevel option to display verbose details of program flow. - New option to prompt for password so it doesn't appear on the process's command line. - New -noviews option that causes SchemaSpy exclude all views from its analysis. - Many additional bugs were fixed. [Less]

SchemaSpy analyzes database metadata to reverse engineer dynamic Entity Relationship (ER) diagrams. It works with just about any JDBC-compliant database (Oracle/MySQL/DB2/SQL Server/PostgreSQL/Sybase/etc) and can identify Ruby on Rails relationships.

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC ... [More] driver. SchemaSpy also identifies several common schema anomalies. SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, Firebird, PostgreSQL, HSQLDB, Informix, Sybase, MaxDB, Firebird and Derby (JavaDB).You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/ (0 comments) [Less]

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC ... [More] driver. SchemaSpy also identifies several common schema anomalies. SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, Firebird, PostgreSQL, HSQLDB, Informix, Sybase, MaxDB, Firebird and Derby (JavaDB).You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/ Release 4.1.1 is a bug patch release resolving issues with the extends directive as well as null IDs on DB2 views. [Less]

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC ... [More] driver. SchemaSpy also identifies several common schema anomalies. SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, Firebird, PostgreSQL, HSQLDB, Informix, Sybase, MaxDB, Firebird and Derby (JavaDB).You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/ (0 comments) [Less]

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC ... [More] driver. SchemaSpy also identifies several common schema anomalies. SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, Firebird, PostgreSQL, HSQLDB, Informix, Sybase, MaxDB, Firebird and Derby (JavaDB).You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/ Release 4.1.1 is a bug patch release resolving issues with the extends directive as well as null IDs on DB2 views. [Less]

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC ... [More] driver. SchemaSpy also identifies several common schema anomalies. SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, Firebird, PostgreSQL, HSQLDB, Informix, Sybase, MaxDB, Firebird and Derby (JavaDB). You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/ Highlights of Release 4.1.0: - Can now fully evaluate Ruby on Rails databases that associate foreign keys to primary tables/keys with a translation of singular to plural form. - Resolved a bug where SchemaSpy was using incorrect entity relationship diagram notation. - Added a new import directive to database configuration files to be able to reuse complex SQL (or other settings) from configurations not in the normal inheritance tree. - Added support for MS SQL Server 2005 with jTDS driver, including column comment retrieval for all of the MS SQL databases. - Can now specify database connection properties on the command line. - New sso option to support single sign-on databases. [Less]

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC ... [More] driver. SchemaSpy also identifies several common schema anomalies. SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, Firebird, PostgreSQL, HSQLDB, Informix, Sybase, MaxDB, Firebird and Derby (JavaDB). You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/ Highlights of Release 4.1.0: - Can now fully evaluate Ruby on Rails databases that associate foreign keys to primary tables/keys with a translation of singular to plural form. - Resolved a bug where SchemaSpy was using incorrect entity relationship diagram notation. - Added a new import directive to database configuration files to be able to reuse complex SQL (or other settings) from configurations not in the normal inheritance tree. - Added support for MS SQL Server 2005 with jTDS driver, including column comment retrieval for all of the MS SQL databases. - Can now specify database connection properties on the command line. - New sso option to support single sign-on databases. [Less]

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either via entity-relationship diagrams or through HTML tables. It works with just about any RDBMS given an appropriate JDBC driver. SchemaSpy also identifies several common schema anomalies. (0 comments)