MySQL vs SchemaSpy
MySQL
mysql.comSchemaSpy
schemaspy.orgSide by side
| Figure | MySQL | SchemaSpy |
|---|---|---|
| Price from | Free | Free |
| Free plan | Yes | Yes |
| Free trial | Yes | — |
| Open source | — | — |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| API | Yes | — |
| Self-hosted | Yes | Yes |
| Plans published | 18 | 1 |
| Spec score · Data Modeling Software | 9.1 (#2) | 7.6 (#15) |
| Spec score · Database Documentation Tools | 8.9 (#4) | 7.7 (#19) |
| Support | MySQL Enterprise technical support provides 24x7 direct access to MySQL support engineers. | The project directs users who need help or find a bug to open an issue on GitHub. |
Plans
MySQL
- Community EditionPrice not published
- Community EditionPriced on request
- Standard EditionPriced on request
- Standard EditionPrice not published
- Enterprise EditionPriced on request
- Enterprise EditionPrice not published
- Cluster Carrier Grade EditionPriced on request
- Cluster Carrier Grade EditionPrice not published
- MySQL Cluster Carrier Grade EditionPriced on request
- MySQL Enterprise EditionPriced on request
In their own words
SchemaSpy
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.