Skip to content
SPECIFICTION
Get listed

MetricFlow vs Sema

MetricFlow

github.com

Sema

semalayer.com

Side by side

FigureMetricFlowSema
Price from$100/mo$49/mo
Free planYesYes
Free trialYesYes
Open sourceYes—
WebYesYes
WindowsYes—
macOSYes—
LinuxYes—
APIYesYes
Self-hostedYesYes
Plans published54
Spec score · Semantic Layer Software9.1 (#3)8.7 (#4)
APIThe hosted Semantic Layer exposes GraphQL and JDBC interfaces for metric queries.The roadmap lists a developers API using workspace-scoped keys, and the product states that governed definitions resolve through an API.
Founded20162025
IntegrationsOfficial documentation lists downstream integrations including Tableau, Hex, Dot, Mode, and Google Sheets.Sema describes its capabilities as MCP tools for use with Claude, Cursor, or an in-house agent, and supports OAuth2/OIDC identity providers including Okta, Entra, Auth0, and Google Workspace.
LicenceMetricFlow versions 0.209.0 and newer use Apache 2.0; earlier releases used AGPL or BSL licensing.The EULA grants a limited, non-exclusive internal-use subscription licence and prohibits copying, modification, redistribution and reverse engineering; it is not an open-source licence.
Securitydbt Labs reports ISO certifications, a SOC 2 Type II examination, and GDPR compliance for dbt.Sema says it uses TLS in transit and encryption at rest, role-based access, restricted-column masking, workspace isolation, and an append-only log of queries, plans, and configuration changes.
Self-hostingMetricFlow can run locally with self-hosted dbt using the mf command prefix.The architecture describes Kubernetes deployment with a Helm chart, customer-provided PostgreSQL and object storage, and a control plane that holds the graph rather than warehouse rows.
Semantic graphSemantic models define entities, dimensions, and measures that form a graph used to navigate metric relationships.Tables, joins, metrics and business terms are represented in a typed graph; verified joins are reused by later answers.
What it doesMetricFlow is a semantic layer that defines metrics and compiles requests into reusable, warehouse-specific SQL.Sema is a governed semantic layer that connects databases, models business meaning and answers questions in plain English with audit evidence.

Plans

MetricFlow

  • DeveloperFree
  • MetricFlowFree
  • Starter$100 a month
  • EnterprisePriced on request
  • Enterprise+Priced on request

MetricFlow pricing →

Sema

  • SandboxFree
  • Pro$49 a month
  • Business$99 a month
  • EnterprisePriced on request

Sema pricing →

In their own words

MetricFlow

MetricFlow is a free, open-source tool from dbt Labs for defining metric logic and generating SQL across data dimensions. Metrics and semantic models are written in YAML within a dbt project, using simple, conversion, cumulative, derived and ratio types. Entity types and parameters construct joins while avoiding fan-out and chasm joins. MetricFlow works with dbt 1.6 and higher and lists Snowflake, BigQuery, Databricks and Redshift, plus Postgres for dbt v1 only. A working dbt project and adapter are required. It is distributed under Apache 2.0 and installs from PyPI with `pip install dbt-metricflow`. The tool does not currently support dbt built-in functions or packages. Custom integrations can use JDBC, ADBC, GraphQL or the Python SDK. The dbt Semantic Layer, powered by MetricFlow, lists integrations including Power BI, Tableau, Google Sheets, Excel, Omni, Hex, Mode and Sigma. MetricFlow is self-hosted and costs nothing; hosted Semantic Layer Starter access is listed at $100 per user/month.

Visit github.com

Sema

Sema is a semantic layer for enterprise AI that connects databases and answers business questions in plain English, with governance controls. It maps tables, joins, metrics, and business terms into a typed graph; verified inferred joins can be reused in later answers. It can ask clarifying questions, show the SQL and graph nodes behind an answer, and select a chart. Users can save and schedule reports for email delivery and set metric alerts for thresholds or deviations. Available connectors include PostgreSQL, MySQL, MariaDB, SQLite, and SQLAlchemy URIs; ClickHouse and Amazon Redshift are in beta, while SQL Server, Snowflake, BigQuery, Databricks, and dbt metadata are on the roadmap. Sema can run in a customer VPC or its own environment; self-hosting uses Kubernetes and Helm with customer-provided Postgres and object storage. The free Sandbox costs nothing and limits use to one connector, one user, 100 monthly chat queries, and five saved reports, without scheduled delivery or alerts. Pro costs $49 a month per user, with a three-seat minimum and a 14-day trial.

Visit semalayer.com