SchemaCrawler
schemacrawler.com
- Free plan
- Windows
- macOS
- Linux
- API
- Self-hosted
What SchemaCrawler is
SchemaCrawler is a free tool for discovering database schemas, documenting them, and supporting data governance. Its command-line tools output database metadata as plain text, HTML5, HTML5 with embedded diagrams, JSON, or YAML, with formats designed to help identify schema differences. It can generate entity-relationship diagrams and run JavaScript or Python scripts against a live database connection. SchemaCrawler supports almost any database with a JDBC driver, though some proprietary drivers must be downloaded separately. Documented integrations include Maven, GitHub Actions, GitLab pipelines, Docker, Graphviz, and templating engines such as Velocity, Thymeleaf, FreeMarker, and Mustache. Those templating engines are separate downloads. The AI MCP Server supports natural-language exploration of database structure and table relationships, as well as SQL query generation. SchemaCrawler runs on operating systems that support Java SE 17 or better. Community support is available on Stack Overflow; professional support packages can provide direct access to the author. The maker says only the latest version receives new feature development and security updates, while older-version support requires a professional package.
Who it suits
SchemaCrawler may suit database administrators, developers, and data governance teams who need schema documentation or comparisons. It is aimed at people comfortable using command-line tools and Java-supported operating systems.
Good to know, and what to watch
- Exports database metadata in five formats.
- Generates entity-relationship diagrams and schema comparisons.
- Supports nearly any database with a JDBC driver.
- Includes an AI MCP Server for natural-language exploration.
- Requires an operating system supporting Java SE 17 or better.
- Some proprietary database drivers require separate downloads.
- Templating engines are not included in the download.
- Older-version support requires a Professional Support Package.
Plans
Every plan and priceSchemaCrawler
Free plan
The verdict
SchemaCrawler offers a broad set of schema documentation and discovery options at no charge. Check driver availability, Java requirements, and support terms before adopting it.
What the maker publishes
- AI interface
- The SchemaCrawler AI MCP Server supports natural-language interaction for exploring database structure, understanding table relationships, and generating SQL queries. source
- Database support
- It supports almost any database with a JDBC driver, though some proprietary drivers must be downloaded separately. source
- Diagrams and scripts
- SchemaCrawler can generate entity-relationship diagrams and execute scripts in JavaScript or Python against a live database connection. source
- Integrations
- The site documents integrations with Apache Maven, GitHub Actions, GitLab pipelines, Docker, Graphviz, and templating engines including Velocity, Thymeleaf, FreeMarker, and Mustache. source
- Online tutorial
- A live online command-line tutorial works in a browser without additional software or plugins. source
- Output formats
- The command-line tools can output database metadata as plain text, HTML5, HTML5 with embedded diagrams, JSON, or YAML. source
- Platform requirement
- SchemaCrawler works on operating systems that support Java SE 17 or better. source
- Purpose
- SchemaCrawler is a free database schema discovery and comprehension tool for database documentation and data governance. source
- Schema comparison
- Its schema output formats are designed to make it easy to find differences between database schemas. source
- 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. source
- 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. source
- 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. source
- 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. source
- Templating limit
- Templating engines are not included in the SchemaCrawler download and must be downloaded separately. source
Checked against the maker's pages on 30 Sept 2026.