dbt Semantic Layer
MetricFlow-powered semantic layer integrated into the dbt ecosystem for governed metrics.
MCPCLI2 Skills
About dbt Semantic Layer
MetricFlow-powered semantic layer integrated into the dbt ecosystem for governed metrics. Explore how dbt Semantic Layer integrates with the agentic data stack ecosystem and supports autonomous data operations.
Key Features
- Centralized metric definitions in YAML on top of existing dbt models
- MetricFlow-powered SQL generation optimized per data platform
- Complex metric types: ratio, expression, cumulative, and derived metrics
- Dynamic multi-hop join resolution based on entity keys and semantic model relationships
- Result caching and declarative caching for performance optimization
- Consistent metric access across all downstream tools organization-wide
- Export capabilities to write queries directly to the data platform on a schedule
- Robust access control and permissions for secure metric distribution
Agent Integration
MCP Server
dbt-labs/dbt-mcpExternal Links
dbt MCP Server Documentation
Official docs on the dbt MCP server with 60+ tools across 8 toolset categories
Semantic Layer GraphQL API
GraphQL API for querying metrics and dimensions from the dbt Semantic Layer
Semantic Layer JDBC API
JDBC driver (ArrowFlight SQL) for querying Semantic Layer metrics programmatically
Introducing the dbt MCP Server
Announcement post explaining how the MCP server brings structured data to AI workflows
Partner Integration Guide
Best practices for integrating with the dbt Semantic Layer