⭐ Star it ⤴️ if you love it!

SchemaCrawler

[!NOTE]

• Please see the SchemaCrawler website for more details.
• Use the SchemaCrawler AI MCP Server to get deep insights into your database
• Explore the SchemaCrawler command-line with a live online tutorial.

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 can also generate structured database documentation in Google OKF format using SchemaCrawler Scribe.

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 17 or better.

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

The SchemaCrawler-Core API and tools framework code is available as a separate GitHub project.

Licensing

SchemaCrawler is available under a number of licenses.

Distributions and Downloads

Explore the SchemaCrawler command-line with a live online tutorial.

SchemaCrawler is available in a number of formats, including a download with examples, source code examples, plugin starters, a Maven reporting plugin, Docker containers, operating system specific installers, and jars on The Central Repository. For a complete list, see downloads and distributions.

Support

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