Azimutt vs tbls

Azimutt is a database exploration and documentation tool for understanding and managing databases. Its ERDs let users choose which tables, columns, relations, and ordering to show, while data exploration follows relations and can access real data on demand. For schema design, it provides AML, a minimal domain-specific language. Documentation includes table and column notes, layout memos, and visual indications; schema analysis can point out inconsistencies and possible improvements. Listed connectors cover PostgreSQL, MySQL, MariaDB, SQL Server, Oracle, MongoDB, Couchbase, BigQuery, and Snowflake. Other schemas can be imported in JSON format, and the CLI includes JSON schema inference. The maker says schema parsing happens in the browser, projects can remain local, and Azimutt can be self-hosted. The free plan has no long-term save and allows a maximum of one user. Solo costs €7.00 per month billed annually; Team costs €35.00 per month billed annually per user. The site says Azimutt is made and hosted in the EU, while its privacy policy says personal data is hosted on DigitalOcean servers in the United States.

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.