When comparing SchemaSpy vs TablePlus, the Slant community recommends TablePlus for most people. In the question“What are the best database design programs?” TablePlus is ranked 5th while SchemaSpy is ranked 7th. The most important reason people chose TablePlus is:
TablePlus supports multi-tab and multi-window viewing, as well as generates code review whenever you make a change to your database.
Specs
Ranked in these QuestionsQuestion Ranking
Pros
Pro Entity Relationship Digramming for nearly any JDBC-compliant database
SchemaSpy can analyze database metadata in order to reverse engineer ER (Entity Relationship) diagrams for any JDBC-compliant database which includes Oracle, MySQL, Sql-Server and Postgres among others.
Pro Has a GUI option available
SchemaSpy is a CLI tool. For people who prefer GUI-based tools there's one available from a different maintainer which stands on top of the CLI version.
Pro Multi-tabs & code review
TablePlus supports multi-tab and multi-window viewing, as well as generates code review whenever you make a change to your database.
Pro Powerful SQL editor
Equipped with the following features:
•Highlight syntax
•Indent SQL Command
•Split Results into Tabs
•Save favorite SQL to snippet
•Customize font size
Pro Native, beautiful and friendly
TablePlus is a native app which helps you easily edit database data and structure.
Pro It's fast
Pro Clean interface
Unlike many database editors, TablePlus is simple and clean. Just enough. Think SequelPro, but for many databases.
Pro Customizable appearance
TablePlus' smartly designed interface not only gives you powerful functions, but also allows you to personalize your database workspace by changing themes and font sizes.
Our shortcut keys also help you work faster and be more efficient.
Cons
Con Does not work with schema dumpfiles
SchemaSpy has no methods for dealing with when you only have a schema generated via something like (mysqldump --no-data [options] >schema-only_dump.sql
) , and do not currently have access to a live database to connect with.
Con GUI option is a separate download by a different maintainer
Since the GUI version is from a different maintainer, it may be abandoned and eventually break if SchemaSpy development continues beyond that. Or it may implement new features much later than the CLI version.
Con Project may be dead or dying
The codebase on sourceforge hasn't seen an update since 2010.