DbSchema vs ERBuilder Data Modeler

DbSchema is a desktop tool for designing, documenting and working with SQL and NoSQL databases on Linux, macOS and Windows. It connects to more than 70 databases through JDBC and can download the needed driver. Users can build interactive schema diagrams, split designs into subsystem diagrams, or create physical schemas while offline and save them as local.dbs files. For connected databases, schema synchronization compares the model with the database and can produce migration SQL for review. The SQL editor offers schema-aware autocomplete, and a visual query builder lets users arrange tables, joins and filters and inspect generated SQL before execution. DbSchema can also publish interactive HTML5 schema documentation that opens in a browser without an installation or license. Connections run directly from the user's computer to the database, with configured SSL and SSH tunnels available. Community Edition is free forever. Pro Monthly is $29.40 a month, and Architect Monthly is $47.04 a month, plus taxes. The shared installer requires no registration and includes a 15-day Architect trial that can be extended by 15 days.

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.