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.

Journal Entries

No entries yet. Link your entries with 'schemaspy' to include this project.


Ratings & Reviews

Community Rating
4.0/5.0

Based on 3 user ratings.

Your Rating

Click to rate this project.

Links

0 links submitted so far. Submit your own links.

News

Edit RSS feeds.

    SchemaSpy 4.1.1 released

    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 4.1.1 released

    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 4.1.0 released

    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)

    SchemaSpy 4.1.0 released

    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)

    SchemaSpy 4.0.0 released

    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)

Read all SchemaSpy articles…

Download Page
51 downloads

Who uses SchemaSpy?

Avatar Avatar Avatar Avatar

Who contributes to SchemaSpy?

Avatar

Who manages SchemaSpy?

Avatar
I'm a manager

Where in the world?



Related Projects by Tags

benerator, Dashboard Studio, DBI, LiquiBase, SchemaCrawler


People who use SchemaSpy also use:


Project Cost

This calculator estimates how much it would cost to hire a team to write this project from scratch. More »
Include
Codebase 11,208
Effort (est.) 2 Person Years
Avg. Salary $ year
$ 135,888