DbSketch vs dbt Semantic Layer

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.

The dbt Semantic Layer centralizes metric definitions on dbt models and handles joins so downstream tools and applications can use metrics consistently. MetricFlow generates SQL at query time from semantic model and metric configurations. Teams define those models and metrics in YAML as version-controlled, lineage-aware code. MetricFlow can optimize joins, rewrite queries to reduce compute and latency, and cache repeated queries. The product offers an API, the dbt MCP Server and integrations for BI tools, notebooks, spreadsheets, embedded analytics and AI systems. GraphQL and JDBC APIs and a Python SDK provide ways to query metrics and dimensions; Claude and ChatGPT can connect to governed metrics through the MCP server. Documented warehouse platforms include Snowflake, BigQuery, Databricks and Redshift. Defining and querying metrics requires a dbt Starter or Enterprise-tier account, and single-tenant accounts need account-representative setup and enablement. Starter includes 5,000 queried metrics per month; Enterprise and Enterprise+ each include 20,000. Starter costs $100 a month per user. The free Developer plan does not list the Semantic Layer.