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
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
Liam ERD
Database Tools
Automatically generates beautiful and easy-to-read ER diagrams from your database.
Apache-2.0vs dbdiagram.io★ 5.2k
DBeaver
Database Tools
Free universal database tool and SQL client
Apache-2.0vs DataGrip★ 52k
ChartDB
Database Tools
Database diagrams editor that allows you to visualize and design your DB with a single que
AGPL-3.0vs dbdiagram.io★ 23k
MySQL
Databases
MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-tim
OSSvs Oracle Database★ 13k
drawDB
Database Tools
Free, simple, and intuitive online database diagram editor and SQL generator.
AGPL-3.0vs dbdiagram.io★ 40k
pgModeler
Database Tools
Open-source data modeling tool designed for PostgreSQL. No more typing DDL commands. Let p
GPL-3.0vs DbSchema★ 3.6k
SaaS alternatives to Schemacrawler
See all
dbdiagram.io
Database Tools
Browser tool for drawing database schemas from DBML code
SaaS
DbSchema
Database Tools
Visual database design and documentation tool for relational and NoSQL databases
SaaS
erwin Data Modeler
Database Tools
Enterprise data modeling tool for designing and documenting database schemas
SaaS
Dataedo
Database Tools
Data catalog and database documentation tool that generates schema docs and ER diagrams
SaaS
dbdocs
Docs & Wikis
Create web-based database documentation using DSL code
SaaS
1explain
Docs & Wikis
Turns videos, voice recordings, PDFs and notes into step-by-step instructions and SOPs for teams
SaaS

