SchemaSpy
A command-line tool that generates browsable HTML documentation and ER diagrams from a database schema.
These buttons open the developer's own site, repository or store listing in a new tab. wares.gg does not host downloads.
About SchemaSpy
SchemaSpy connects to a database through a JDBC driver and produces a set of HTML pages describing its tables, columns and relationships, including entity relationship diagrams. The output can be shared with a team or published as documentation.
It is a single Java .jar file run from the command line, which makes it easy to add to a build so documentation is regenerated as the schema changes. It suits developers and database administrators who need up-to-date schema documentation without writing it by hand.
Strengths
- Generates ER diagrams automatically
- Static HTML output is easy to share
- Single jar that fits into continuous builds
Limitations
- Requires Java and the right JDBC driver
- Command-line configuration only
Details
- Pricing
- FreeFree and open source.
- License
- LGPL-3.0
- Developer
- The SchemaSpy contributors
- Platforms
- Windows, macOS, Linux, Command line
- How it runs
- Downloadable app
- Account
- Not required
- Works offline
- Yes
- Best suited for
- Teams that want generated documentation for a database schema
- Categories
- Database tools, Developer tools
- Last verified
- Added
- Provenance
- Facts checked against the developer's own pages and store listings, 1 sources on file.
Alternatives to SchemaSpy
Compare allSoftware that can replace SchemaSpy for an important use case, and what changes if you switch.
DbSchema
A visual database designer and client that turns SQL and NoSQL databases into ER diagrams.
DbSchema replaces generated command-line output with a desktop visual designer that also produces ER diagrams and HTML documentation, but advanced features are paid and it is not open source.
ChartDB
An open-source tool for visualizing and editing database schema diagrams, hosted or self-hosted.
ChartDB builds ER diagrams in a web interface from a single query without database access, hosted or self-hosted under AGPL-3.0, rather than producing static HTML from a Java jar.
Similar software
Related functionality, not necessarily a direct replacement.
dbdiagram.io
A web tool for drawing database relationship diagrams by writing a simple text-based language.
pgModeler
An open-source PostgreSQL modeling tool for designing, reverse-engineering, diffing and deploying database schemas.
DBeaver Community
One database client for more than a hundred databases, with a proper SQL editor and ER diagrams.
Atlas
A command-line tool that manages database schemas as code and plans migrations automatically.
Jailer
A database subsetting tool and relational data browser for extracting consistent slices of a database.
