ERBuilder Data Modeler vs SchemaCrawler

ERBuilder Data Modeler is a Windows desktop tool for designing databases with graphical entity relationship diagrams and generating SQL databases. It supports IDEF1X, Crow’s Foot, Codasyl and Relational notations. Users can create DDL scripts and databases from models, or reverse engineer existing databases into graphical models. Supported systems include Oracle, Microsoft SQL Server, MySQL, MariaDB, PostgreSQL, SQLite, Firebird, Azure SQL Database, Azure Synapse Dedicated SQL Pool, Amazon Redshift and Amazon RDS. The feature matrix lists natural-language generation and updating of ER diagrams, metadata queries powered by the ChatGPT API, and AI descriptions for procedures, views and triggers. Softbuilder says AI inputs are sent to OpenAI servers via HTTPS and are not retained. Enterprise includes navigable HTML and Word documentation, Confluence documentation and Git collaboration for browsing, merging and comparing model versions. A free edition is listed, and the maker offers a 15-day fully functional trial with all features, no credit card required and free technical support. Professional costs $139 a year; Enterprise costs $399 a year. Both include one workstation, one year of Standard support and one year of maintenance and updates.

SchemaCrawler is free, open-source software for discovering database schemas, documenting them, and supporting data governance. Its command-line tools output metadata as plain text, HTML5, HTML5 with embedded diagrams, JSON, or YAML. These formats are intended to make differences between database schemas easier to identify. SchemaCrawler can generate entity-relationship diagrams and execute JavaScript or Python against a live database connection. It supports almost any database with a JDBC driver, although some proprietary drivers require separate downloads. Integrations documented by the project include Apache Maven, GitHub Actions, GitLab pipelines, Docker, Graphviz, and several templating engines. The AI MCP Server allows natural-language exploration of database structures, table relationships, and SQL query generation. SchemaCrawler runs on operating systems supporting Java SE 17 or newer and can be self-hosted. The software is free; bundled JDBC-driver distributions are GPL v3, and commercial-use licensing terms can be arranged.