Schema Spy

Generates clickable HTML reports with entity-relationship diagrams that make navigating complex data models intuitive, as demonstrated in the sample at schemaspy.org.

Works with over a dozen databases out of the box via JDBC, including PostgreSQL, MySQL, and SQLite, and allows plugging in any JDBC-compatible driver.

Identifies sub-optimal constructs like missing indexes and orphan tables, incorporating best practices for database quality assurance.

Operates on structural metadata only, enabling safe use with empty database replicas to protect sensitive data during documentation.

Can be incorporated into automated workflows to ensure documentation stays current, as highlighted in the CI/CD integration feature.