Skip to content
SPECIFICTION
Get listed

SchemaCrawler

schemacrawler.com

Free plan WindowsmacOSLinuxAPISelf-hosted
Visit schemacrawler.com
Spec score 7.7 #13 of 27 in Data Modeling Software

What it is

SchemaCrawler is free, open-source software for discovering database schemas, documenting them, and supporting data governance. Its command-line tools output metadata as plain text, HTML5, HTML5 with embedded diagrams, JSON, or YAML. These formats are intended to make differences between database schemas easier to identify. SchemaCrawler can generate entity-relationship diagrams and execute JavaScript or Python against a live database connection. It supports almost any database with a JDBC driver, although some proprietary drivers require separate downloads. Integrations documented by the project include Apache Maven, GitHub Actions, GitLab pipelines, Docker, Graphviz, and several templating engines. The AI MCP Server allows natural-language exploration of database structures, table relationships, and SQL query generation. SchemaCrawler runs on operating systems supporting Java SE 17 or newer and can be self-hosted. The software is free; bundled JDBC-driver distributions are GPL v3, and commercial-use licensing terms can be arranged.

Spec sheet

Purpose
SchemaCrawler is a free database schema discovery and comprehension tool for database documentation and data governance.Read 30 Sep 2026 · schemacrawler.com
Integrations
The site documents integrations with Apache Maven, GitHub Actions, GitLab pipelines, Docker, Graphviz, and templating engines including Velocity, Thymeleaf, FreeMarker, and Mustache.Read 30 Sep 2026 · schemacrawler.com
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.Read 30 Sep 2026 · schemacrawler.com
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.Read 30 Sep 2026 · schemacrawler.com
AI interface
The SchemaCrawler AI MCP Server supports natural-language interaction for exploring database structure, understanding table relationships, and generating SQL queries.Read 30 Sep 2026 · schemacrawler.com
Database support
It supports almost any database with a JDBC driver, though some proprietary drivers must be downloaded separately.Read 30 Sep 2026 · schemacrawler.com
Diagrams and scripts
SchemaCrawler can generate entity-relationship diagrams and execute scripts in JavaScript or Python against a live database connection.Read 30 Sep 2026 · schemacrawler.com
Online tutorial
A live online command-line tutorial works in a browser without additional software or plugins.Read 30 Sep 2026 · schemacrawler.com
Output formats
The command-line tools can output database metadata as plain text, HTML5, HTML5 with embedded diagrams, JSON, or YAML.Read 30 Sep 2026 · schemacrawler.com
Platform requirement
SchemaCrawler works on operating systems that support Java SE 17 or better.Read 30 Sep 2026 · schemacrawler.com
Schema comparison
Its schema output formats are designed to make it easy to find differences between database schemas.Read 30 Sep 2026 · schemacrawler.com
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.Read 30 Sep 2026 · schemacrawler.com
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.Read 30 Sep 2026 · schemacrawler.com
Templating limit
Templating engines are not included in the SchemaCrawler download and must be downloaded separately.Read 30 Sep 2026 · schemacrawler.com

Plans and prices

SchemaCrawler Free Free and open-source software · bundled JDBC-driver distributions are GPL v3 · commercial-use licensing terms can be arranged Read 30 Sep 2026 · schemacrawler.com

Every SchemaCrawler plan and price →

Strong points and limits

Strong points

  • Free and open-source database tooling
  • Outputs metadata in text, HTML5, JSON, or YAML
  • Generates entity-relationship diagrams
  • Runs JavaScript or Python against live connections
  • AI MCP Server supports natural-language schema exploration

Limits

  • Requires Java SE 17 or newer
  • Some proprietary JDBC drivers need separate downloads
  • Templating engines are not bundled
  • Security of executed scripts cannot be vouched for

Who it suits

It suits database teams handling documentation, governance, schema history, data dictionaries, or lineage. Developers and operators who prefer command-line, self-hosted, or automation-oriented workflows can use its documented integrations.

Verdict

SchemaCrawler offers broad database discovery and documentation output with scripting, diagrams, automation integrations, and an AI interface. Its self-hosted model and free licensing suit technical teams, but separate dependencies and script-security responsibilities require attention.

Where Specifiction places it

Alternatives to SchemaCrawlerAll alternatives →