- Home
- Database Documentation Tools
- SchemaCrawler
SchemaCrawler
What it is
SchemaCrawler is free software for discovering and understanding database schemas, with uses in documentation and data governance. Its command-line tools present database metadata as plain text, HTML5, HTML5 with embedded diagrams, JSON, or YAML; the output formats are designed to make schema differences easier to locate. It can produce entity-relationship diagrams and run JavaScript or Python scripts against a live database connection. The tool supports almost any database with a JDBC driver, though some proprietary drivers need separate downloads. Documented integrations include Apache Maven, GitHub Actions, GitLab pipelines, Docker, Graphviz, and templating engines such as Velocity, Thymeleaf, FreeMarker, and Mustache. Templating engines are not included in the SchemaCrawler download. Its AI MCP Server enables natural-language exploration of database structure and table relationships, as well as SQL query generation. SchemaCrawler requires an operating system that supports Java SE 17 or better. It is free and open source; bundled JDBC-driver distributions are GPL v3, and commercial-use licensing terms can be arranged. The security guidance cautions that the software cannot vouch for scripts it runs.
For and against
For
- Outputs metadata in text, HTML5, JSON, and YAML.
- Creates entity-relationship diagrams.
- Supports nearly any database with a JDBC driver.
- Includes an AI MCP Server for schema exploration.
Against
- Some proprietary JDBC drivers need separate downloads.
- Templating engines are not included in the download.
- Security guidance cannot vouch for executed scripts.
The verdict
SchemaCrawler offers database discovery and documentation tools across command-line, diagram, and AI-assisted workflows. Users should account for separate driver or templating downloads where needed and review its guidance on script security.
Who it suits
SchemaCrawler suits database professionals who need schema documentation, comparison, diagrams, or governance support. It requires an operating system that supports Java SE 17 or better.
Plans and prices
SchemaCrawler
Free and open-source software · bundled JDBC-driver distributions are GPL v3 · commercial-use licensing terms can be arranged
Read 30 Sep 2026 · schemacrawler.com
On the record
- AI interface
- The SchemaCrawler AI MCP Server supports natural-language interaction for exploring database structure, understanding table relationships, and generating SQL queries.schemacrawler.com · read 30 Sep 2026
- Database support
- It supports almost any database with a JDBC driver, though some proprietary drivers must be downloaded separately.schemacrawler.com · read 30 Sep 2026
- Diagrams and scripts
- SchemaCrawler can generate entity-relationship diagrams and execute scripts in JavaScript or Python against a live database connection.schemacrawler.com · read 30 Sep 2026
- Integrations
- The site documents integrations with Apache Maven, GitHub Actions, GitLab pipelines, Docker, Graphviz, and templating engines including Velocity, Thymeleaf, FreeMarker, and Mustache.schemacrawler.com · read 30 Sep 2026
- Online tutorial
- A live online command-line tutorial works in a browser without additional software or plugins.schemacrawler.com · read 30 Sep 2026
- Output formats
- The command-line tools can output database metadata as plain text, HTML5, HTML5 with embedded diagrams, JSON, or YAML.schemacrawler.com · read 30 Sep 2026
- Platform requirement
- SchemaCrawler works on operating systems that support Java SE 17 or better.schemacrawler.com · read 30 Sep 2026
- Purpose
- SchemaCrawler is a free database schema discovery and comprehension tool for database documentation and data governance.schemacrawler.com · read 30 Sep 2026
- Schema comparison
- Its schema output formats are designed to make it easy to find differences between database schemas.schemacrawler.com · read 30 Sep 2026
- Security
- The security guidance says SchemaCrawler cannot vouch for the security of scripts it executes and recommends removing the scripting JAR if scripting is not needed.schemacrawler.com · read 30 Sep 2026
- SQL Server encryption
- The security guidance says the server, host, and port connection method turns off encrypted connections and recommends a trusted certificate and a URL containing encrypt=true.schemacrawler.com · read 30 Sep 2026
- Support
- Community support is available on Stack Overflow, while professional support packages provide direct access to the author and can cover project advice or consulting.schemacrawler.com · read 30 Sep 2026
- Support scope
- The support page says only the latest SchemaCrawler version receives new feature development and security updates, and older-version support requires a Professional Support Package.schemacrawler.com · read 30 Sep 2026
- Templating limit
- Templating engines are not included in the SchemaCrawler download and must be downloaded separately.schemacrawler.com · read 30 Sep 2026
