Projects / SchemaCrawler

SchemaCrawler

SchemaCrawler is a Java API which makes working with database metadata as easy as working with ordinary Java objects. It is also a database schema discovery and comprehension and schema documentation tool. You can search for database schema objects using regular expressions, output the schema and data in a readable text format, and find potential design issues with lint . The output is designed to be diff-ed against other database schemas. SchemaCrawler supports almost any database which has a JDBC driver, but for convenience is bundled with drivers for some commonly-used RDBMS systems. SchemaCrawler works with any operating system which supports Java.

Tags
Licenses
Operating Systems
Implementation

RSS Recent releases

  •  04 Apr 2014 13:53

    Release Notes: Data dumps now show data for columns in sorted order, if requested using commandline switches. Database diagrams show the generation time.

    •  24 Mar 2014 02:24

      Release Notes: Tables have definitions now. Tables definition DDL is filled in for Oracle, as well as DDL for foreign keys. Source code has moved to Git.

      •  30 Dec 2013 17:00

      Release Notes: Copyright notices are updated, and the javadocs are in Java 7 format.

      •  12 Nov 2013 02:45

      Release Notes: This release adds more details about table constraints, including details of constrained columns.

      •  07 Nov 2013 07:21

      Release Notes: The CheckConstraint class was renamed to TableConstraint, and provides more information about table constraints such as primary key, foreign key, and unique and check constraints.

      Screenshot

      Project Spotlight

      List My Apps

      App lister

      Screenshot

      Project Spotlight

      SportsTracker

      A tool for recording and displaying sport activities.