SchemaCrawler

• Please see the SchemaCrawler website for more details.
• Explore the SchemaCrawler command-line with a live tutorial on Katacoda.

About

SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format. The output serves for database documentation, and is designed to be diff-ed against other database schemas. SchemaCrawler also generates schema diagrams. You can execute scripts in any standard scripting language against your database. You can find potential schema design issues with lint.

SchemaCrawler supports almost any database that has a JDBC driver, but for convenience is bundled with drivers for some commonly used RDBMS systems. SchemaCrawler works with any operating system that supports Java SE 8 or better.

SchemaCrawler is also a Java API that makes working with database metadata as easy as working with plain old Java objects.

Licensing

SchemaCrawler is available under a number of licenses.

Distributions and Downloads

Explore the SchemaCrawler command-line with a live tutorial on Katacoda. Download SchemaCrawler releases with tutorials from GitHub. All SchemaCrawler jars are in the Central Repository. They can be used as dependencies in Gradle or Apache Maven projects, or with any other build system that supports the Central Repository. Pre-packaged Docker images are on Docker Hub.

Additional SchemaCrawler database plugins are available from the schemacrawler/SchemaCrawler-Database-Plugins project.

SchemaCrawler reports can be incorporated into Apache Maven builds with the SchemaCrawler Report Maven Plugin and into the GitHub Actions workflow with the SchemaCrawler Action.

Support

Please get support on Stack Overflow, following the Guidelines for Support.