SchemaSpy
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.
| Tags | Database Front-Ends |
|---|---|
| Operating Systems | OS Independent |
| Implementation | Java |
Recent releases
- 20 Oct 2008 18:14
Changes: This release resolves issues with the extends directive as well as null IDs on DB2 views.
- 17 Oct 2008 23:01
Changes: 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.
- 22 Sep 2008 23:41
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.
- 18 Dec 2006 09:33
Changes: 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).
- 04 Oct 2006 23:53
Changes: The Columns page is now sortable by column, table, type, size, nullability, auto increment, default value, children, or parents. A new option (-desc) was added to provide a description of the schema that is displayed on the non-detail pages. The -notablecomments option was added for databases like MySQL that stuff unrelated data where comments belong. Many bugs were fixed, including support for Oracle 10g's recycle bin.
- All comments
Recent commentsHurray!
I love SchemaSpy -- I am so glad to see that it's being updated. This is a great tool. Excellent execution. Thank you so much for making this available!
Re: Fantastic database mapping tool!
Post the details of the failure in the help forum (http://sourceforge.net/forum/forum.php?forum_id=462850) and we should be able to figure it out.
Re: Fantastic database mapping tool!
where are the debugging notes for Jdbc -cp jar file issues?
I have a successful command line into the PostgreSql instance but running this with the command line will not invoke without error. Any ideas?
java -jar schemaSpy.jar -t pgsql -db mydb -host localhost -port 6432 -u user -p password -o postgresql_schema
I even tried adding the -s name as 'public' and no luck either.
First ever ...
... tool I found that "digest" a vintage Sybase database without a glitch ... Hey ... GREAT job. Thank you.
Re: Fantastic database mapping tool!
> Produces very attractive graphical
> representations of your database schema.
> Works well with postgres 8, and is
> generally quite impressive. Give it a
> try.
Thanks Jason. Note that I really appreciate any/all feedback. If there's something that anyone would like to see added then tell me about it on the SourceForge site. I want to make SchemaSpy as useful as possible.