Skip to content
SPECIFICTION
Get listed

SchemaSpy

schemaspy.org

Free plan WindowsmacOSLinuxSelf-hosted
Visit schemaspy.org
Spec score 7.6 #15 of 27 in Data Modeling Software

What it is

SchemaSpy is a free, open-source command-line application that reads database metadata and creates shareable HTML documentation. It generates entity-relationship diagrams from an existing database, collects structural statistics, and can export those statistics to Excel or CSV. Reports can identify design anomalies such as missing indexes, implied relationships, and orphan tables. The project says it supports over a dozen databases directly and can work with others through JDBC drivers. Documentation generation can be placed in a CI/CD workflow, and SchemaSpy can run against an empty database replica because it reads structural information. There is no graphical interface: distribution is through a JAR file or Docker image. Installation requires Java, a database JDBC driver, and viz.js or Graphviz for relationship diagrams. The JAR excludes drivers, while the Docker image includes drivers for MySQL, MariaDB, PostgreSQL, and jTDS for MSSQL. The listed plan price is free.

Spec sheet

Purpose
SchemaSpy analyzes database metadata and creates HTML reports to help people visualize, navigate, and understand data models.Read 7 Oct 2026 · github.com
Deployment
SchemaSpy is a standalone command-line application without a GUI and is distributed as a JAR file or Docker image.Read 7 Oct 2026 · github.com
Support
The project directs users who need help or find a bug to open an issue on GitHub.Read 7 Oct 2026 · schemaspy.org
License
The GitHub repository lists LGPL-3.0 and GPL-3.0 licenses.Read 7 Oct 2026 · github.com
Founded
2004Read 28 Sep 2026 · schemaspy.org
Anomaly checks
It can report database design anomalies such as missing indexes, implied relationships, and orphan tables.Read 7 Oct 2026 · github.com
Continuous use
The project describes generating documentation as part of a CI/CD workflow to keep it up to date.Read 7 Oct 2026 · github.com
Data access
SchemaSpy reads structural information and the project says it can run against an empty database replica.Read 7 Oct 2026 · github.com
Database coverage
The project says SchemaSpy supports over a dozen databases out of the box and can work with other databases that have a JDBC driver.Read 7 Oct 2026 · github.com
Diagrams
It generates entity-relationship diagrams from an existing database.Read 7 Oct 2026 · schemaspy.org
Driver limits
The JAR distribution does not include JDBC drivers; the Docker image includes drivers for MySQL, MariaDB, PostgreSQL, and jTDS for MSSQL.Read 7 Oct 2026 · schemaspy.readthedocs.io
Generated output
SchemaSpy generates HTML documentation that can be shared with a team or community.Read 7 Oct 2026 · schemaspy.org
Project history
The official site says the project continues work begun by John Currier in 2004.Read 7 Oct 2026 · schemaspy.org
Requirements
The documented installation prerequisites include Java, a JDBC driver for the database engine, and viz.js or Graphviz for rendering relationship diagrams.Read 7 Oct 2026 · schemaspy.readthedocs.io
Statistics
It can collect database structure statistics and display them in reports or export them to Excel or CSV.Read 7 Oct 2026 · github.com

Plans and prices

SchemaSpy Free Open-source database documentation tool Read 7 Oct 2026 · github.com

Every SchemaSpy plan and price →

Strong points and limits

Strong points

  • Free plan with 0.00 USD price
  • Generates HTML data-model documentation
  • Creates entity-relationship diagrams
  • Exports statistics to Excel or CSV
  • Supports CI/CD documentation workflows

Limits

  • No graphical user interface
  • JAR distribution excludes JDBC drivers
  • Requires Java and diagram-rendering prerequisites
  • No free trial is offered

Who it suits

It suits developers, database teams, and communities that need generated schema documentation, diagrams, statistics, or anomaly checks. It is intended for users comfortable with command-line deployment and database drivers.

Verdict

SchemaSpy provides database documentation and diagnostics through a standalone command-line tool rather than a GUI. Its free distribution is useful for automated or shareable documentation, provided the required runtime, drivers, and rendering tools are supplied.

Where Specifiction places it

Alternatives to SchemaSpyAll alternatives →