schemaspy/schemaspy

Health v2 · maintenance only

Adoption not part of the score

3710 stars · 358 forks observed · 2026-08-28

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-29, confidence not recorded

SchemaSpy is a Java-based database metadata analyzer that generates HTML documentation of relational database schemas, including entity-relationship diagrams and data dictionaries. It runs as a standalone JAR or Docker image against a live database via JDBC drivers.

Use cases

• generate database documentation from an existing schema
• visualize entity-relationship diagrams for a database
• create a data dictionary for tables and columns
• document a PostgreSQL or SQL Server schema as HTML
• reverse-engineer a legacy database schema
• share database schema docs with my team

When to choose

• you need automatically generated, navigable HTML docs for a relational database
• you want ER diagrams without drawing them manually
• you prefer a standalone tool or Docker image with no GUI setup
• you want documentation regenerated continuously as the schema evolves

When to avoid

• you need documentation for non-relational databases like MongoDB
• you want a GUI-based schema design tool rather than a report generator
• your database is not reachable via JDBC
• you need editable, hand-written documentation rather than generated output

Facets

cli-tool · maturity active

documentation database developer-tools databases documentation developer-tools cli cross-platform jvm er-diagrams schema-analysis html-reports jdbc data-dictionary docker

Member repositories

For agents

markdown · JSON · MCP: product_card(name="schemaspy/schemaspy")