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

      Highlight

      A universal source code to formatted text converter.

      Screenshot

      Project Spotlight

      bystroTeX

      A tool for preparing HTML slides with LaTeX formulae.