DbSchema vs tbls

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.

tbls is a command-line tool for documenting databases and checking their schemas. It generates GitHub Flavored Markdown and can export schema information in formats including DOT, PlantUML, Mermaid, SVG, PNG, JPG, JSON, YAML, Excel, and configuration files. Its configurable lint rules can require column comments or set column-count limits. The `diff` command compares a database schema with generated documentation or another database, while `coverage` measures documentation for descriptions and comments. Documented data sources include PostgreSQL, MySQL, MariaDB, SQLite, BigQuery, Cloud Spanner, Amazon Redshift, SQL Server, Azure SQL, Microsoft Fabric Warehouse, DynamoDB, Snowflake, MongoDB, ClickHouse, Databricks, JSON, HTTP, and GitHub. Docker and a GitHub Action are documented for CI use, and external drivers can extend database support. It runs on Linux, macOS, and Windows, or in a self-hosted setup. The listed plan is free under the MIT License. SQL Server requires version 2017 or later and database compatibility level 110 or higher.