Schemacrawler

Open source

SchemaCrawler is a free tool for discovering and comprehending database schemas, supporting output in multiple formats and schema diagram generation.

schemacrawler.com
Schemacrawler homepage screenshot
GitHub stars
1.8k
Last 30 days
+6(+0%)
Last commit
3 days ago
Repository age
11 years
Version
v18.0.2
Licence
Custom
Self-hosted
Yes

About Schemacrawler

SchemaCrawler is a free database schema discovery and comprehension tool. It allows users to search for database schema objects using regular expressions and output the schema and data in a readable text format. The output is designed to be diff-ed against other database schemas and serves for database documentation.

SchemaCrawler also generates schema diagrams and supports executing scripts in any standard scripting language against a database. It can find potential schema design issues with lint and rank tables and views by graph metrics and importance. The tool supports almost any database with a JDBC driver and works on any operating system that supports Java SE 17 or better.

Key features

  • Search for database schema objects using regular expressions
  • Output schema and data in readable text format, HTML5, JSON, or YAML
  • Generate schema diagrams
  • Execute scripts in any standard scripting language against the database
  • Find potential schema design issues with lint
  • Rank tables and views by graph metrics and importance

Good fit for

  • Database documentation
  • Schema comparison and diffing
  • Schema design analysis
Built with
Java tools
Tags
database
schema
discovery
documentation
diagramming
lint

Schemacrawler: questions and answers

What is Schemacrawler used for?
SchemaCrawler is a free tool for discovering and comprehending database schemas, supporting output in multiple formats and schema diagram generation. It is a good fit for database documentation, schema comparison and diffing, and schema design analysis.
Is Schemacrawler open source?
Yes. Schemacrawler is open source under a custom licence. Its source code is on GitHub at schemacrawler/SchemaCrawler and is written mainly in Java.
Is Schemacrawler free?
Yes. Schemacrawler is open source, so the software itself is free to use under the terms of its own licence.
Can I self-host Schemacrawler?
Yes. Schemacrawler can be self-hosted on your own server or infrastructure.
What is Schemacrawler an alternative to?
Schemacrawler is an open-source alternative to dbdiagram.io, DbSchema, erwin Data Modeler and Dataedo. Other open-source alternatives to dbdiagram.io include Liam ERD, DBeaver and ChartDB.
Is Schemacrawler actively maintained?
Yes. The most recent commit to Schemacrawler was on 10 November 2026, and the latest release is v18.0.2, published on 10 November 2026. The project has 1.8k stars on GitHub, with 6 added in the last 30 days.

Open-source alternatives to Schemacrawler

See all

SaaS alternatives to Schemacrawler

See all