SchemaCrawler
Free database schema discovery, linting, and comprehension tool with automated ER diagrams.
Why consider SchemaCrawler?
SchemaCrawler is an open-source database schema discovery, metadata inspection, and linting tool written in Java. It connects to any relational database over JDBC, searches table structures with regular expressions, lints design flaws, and generates automated Graphviz ER diagrams.
Learn SchemaCrawler by building
Practical setup notes, real use cases, and copy-ready examples in one focused guide.
In this guide2 sections
Overview of SchemaCrawler
SchemaCrawler generates visual SVG entity relationship diagrams and schema diffs automatically in CI workflows.
Quickstart
schemacrawler --server=postgresql --host=localhost --port=5432 --database=mydb --user=postgres --password=secret --info-level=standard --command=schema --output-format=html --output-file=schema.htmlSchemaCrawler is licensed under the GNU LGPL-3.0 and EPL-1.0 licenses.
Related tools
More options with a similar category or technology profile.
diskus
Minimal, fast alternative to du -sh written in Rust using multi-threaded directory traversal.
peco
Simplistic interactive filtering tool for Unix pipelines, process lists, and file trees.
Dapr CLI
Command-line tool for managing Dapr distributed application runtime environments and sidecars.
Freeze
Generate beautiful image screenshots and SVGs of code snippets and terminal outputs.