Projects / 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.

Operating Systems

Recent releases

  •  16 May 2014 00:57

    Release Notes: Table is based on a string, not an enum.

    •  24 Apr 2014 17:05

      Release Notes: Bugs related to serialization to XML, lints for indexed foreign keys, and mixed-case MySQL table names are fixed.

      •  04 Apr 2014 01:03

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

        •  23 Mar 2014 21:09

          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 02:14

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


            Project Spotlight


            A Fluent OpenStack client API for Java.


            Project Spotlight

            TurnKey TWiki Appliance

            A TWiki appliance that is easy to use and lightweight.