DbSchema vs DbSketch

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.

DbSketch is a command-line generator for turning live relational database schemas into version-controlled documentation. It reads tables, columns, primary keys, and foreign keys from SQL Server, PostgreSQL, MySQL, and SQLite. Output choices are Graphviz DOT, Mermaid ER, or Markdown files with diagram text in a fenced code block. A YAML configuration holds one database connection and can define named diagram targets, allowing one setup to produce multiple focused diagrams with separate output and renderer settings. DbSketch can include native database comments where supported and apply YAML comment overrides. Its DOT renderer preserves foreign-key relationships down to the connected columns. The maker describes it as useful for repository documentation, CI, and compact schema snapshots for people and AI coding assistants. It is distributed as the.NET tool DimonSmart.DbSketch, which installs the dbsketch command; the getting-started guide requires the.NET 10 SDK. The software is MIT-licensed and costs nothing. It runs on Linux, macOS, and Windows and is self-hosted.