Schemacrawler logo

SchemaCrawler

Free database schema discovery and comprehension tool

SchemaCrawler Output

SchemaCrawler generates clean plain text, HTML5, HTML5 with embedded diagrams, or JavaScript object notation (JSON) output. The HTML5 output is a combination of valid XML (that can be manipulated by XML tools or XSLT), and HTML that can be viewed in a browser. The output serves for database documentation, and is designed to be diff-ed against other database schemas.

SchemaCrawler is unique among database documentation tools in that you do not need to know the table names or column names that you are interested in. All you need is a search expression, in the form of a regular expression. SchemaCrawler has powerful command-line options to match tables, and then find other related tables, whether they are parent or child tables. If your schema changes, you can simply regenerate the diagram, without having to know the exact changes that were made.

Text Output Options

SchemaCrawler outputs complete details of your database schema (see HTML output), and in addition offers several options to change what you see on the database diagram. Here are a few variations, with examples in SchemaCrawler’s HTML output format: