SchemaSpy / News: Recent posts

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.

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.... read more

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. 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/ ... read more

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.

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).... read more

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.

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).... read more

SchemaSpy analyzes database schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either graphically or through HTML tables. It works with just about any RDBMS given an appropriate JDBC 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 and Sybase. ... read more

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either graphically or through HTML tables. It works with just about any RDBMS given an appropriate JDBC 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 and Sybase. ... read more

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of your tables' parent/child relationships either graphically or through HTML tables. It works with just about any RDBMS given an appropriate JDBC 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 and Sybase. ... read more

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

SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, PostgreSQL, HSQLDB and Sybase. ... read more

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

SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, PostgreSQL, HSQLDB and Sybase. ... read more

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

SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, PostgreSQL, HSQLDB and Sybase. ... read more

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

SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, PostgreSQL, HSQLDB and Sybase. ... read more

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

SchemaSpy is available at http://schemaspy.sourceforge.net/ and currently supports Oracle, DB2, SQL Server, MySQL, PostgreSQL and Sybase.... read more

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

SchemaSpy is available at
http://schemaspy.sourceforge.net/

You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/... read more

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

SchemaSpy is available at http://schemaspy.sourceforge.net/. You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/. ... read more

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of tables' parent/child relationships either graphically or through tables. It works with just about any RDBMS given an appropriate JDBC driver. SchemaSpy also identifies common schema anomalies.

SchemaSpy is available at http://schemaspy.sourceforge.net/. You can browse a sample of its output at http://schemaspy.sourceforge.net/sample/. ... read more

SchemaSpy analyzes schema metadata, letting you click through the hierarchy of tables' parent/child relationships either graphically or through tables. It works with just about any RDBMS given an appropriate JDBC driver. SchemaSpy also identifies common schema anomalies.

SchemaSpy is available at http://schemaspy.sourceforge.net and you can browse a sample of its output at http://schemaspy.sourceforge.net/sample/.... read more

Now displays two versions of the main relationships graph: a smaller 'compact' version and a large full-size version. The compact version should make it easier to get a 'big picture' view of the relationships.

Now takes advantage of the GraphVis dot 2.6 ability to point to the East/West center of a node if running dot 2.6 or higher.

Figured out a way to have the graph point to the appropriate portion of the main table in the table detail pages.... read more

SchemaSpy now has much better MySQL support with the release of version 1.3.3. This release also has better error reporting when there are problems connecting to a database.

Indexes now include a sort order column and 'records' are now 'rows.'

The relationships counters on the main page no longer include implied relationships, just real foreign key relationships. The main page output is a little cleaner too.... read more

SchemaSpy lets you graphically click though your database's schema. Ever get dumped on a new project and need to understand the database? If you have then this tool is for you.

Changes in this release include:
- Now has links to the major pages on each page.
- Added lots of diagnostics when to help select an appropriate schema when no tables were found in the specified schema.
- Now makes sure the generated .dot files don't have inappropriate node names (table names).
- Tables with incrementing column names anomaly now gets accurately detected.
- Removed the 'Unreferenced Primary Keys' anomaly...it was controversial and of questionable value.... read more

SchemaSpy lets you graphically click though your database's schema. Ever get dumped on a new project and need to understand the database? This tool's for you.

Changes in this release include: new 'Unreferenced primary keys' anomaly detection, much more consistent naming of generated graphs and a handful of bugfixes.

Now detects these anomalies:
- Implied relationships
- Tables without indexes
- 'Nullable' and 'must be unique' columns
- Unreferenced primary keys
- Tables with a single column
- Tables with incrementing column names... read more

I've finally posted the first release of SchemaSpy. Some sample output is available at http://schemaspy.sourceforge.net/sample . The home page (http://schemaspy.sourceforge.net) needs lots of help. If you have the skills your help would be greatly appreciated.

John