SchemaCrawler is a platform (OS and database) independent command line tool to output your database schema and data in a readable form. The output is designed to be diff-ed with previous versions of your database schema. SchemaCrawler is also an API that improves on standard JDBC metadata.
| Tags | Database API Software Development Quality Assurance |
|---|---|
| Licenses | LGPL |
| Operating Systems | OS Independent |
| Implementation | Java |
Recent releases


Release Notes: This release adds the ability to configure SchemaCrawler linters and a new lint for useless surrogate keys. You can now tag tables and columns with additional metadata attributes from SQL queries.


Release Notes: This release allows you to programatically use configurations that are available for different databases. This allows you to obtain detailed metadata, for example triggers, with Oracle, Microsoft SQL Server, IBM DB2, and any of the SchemaCrawler releases that bundle database drivers.


Release Notes: This release adds a new lint report and several new lints, which are described on the website. Lints are extensible. You can add new custom commands to SchemaCrawler as well, using the new command provider API.


Release Notes: This release outputs database metadata as JSON for use in websites and other applications. The SchemaCrawler Maven Plugin is now broken out into a separate project on SourceForge.


Release Notes: SchemaCrawler provides even more Oracle metadata details using new INFORMATION_SCHEMA views. This release contains bug fixes and updated database driver versions.
A patch that enables MySQL to use wsrep replication plugins.