← All use cases
Trustworthy AI with MCP
Most of the trustworthy context already lives in recurring reports. DRE brings reviewed report logic and upstream pipeline comments into a MCP server, so an agent can find an answer, show its origin and let you review the rendered SQL.
description: Net revenue by customer region, excluding GST
meta:
units: AUD
ai:
# Exposure is reviewed and enabled by the owner.
expose: true
questions:
- What is net revenue by region?
- Which region has the most revenue?
queries: [revenue]
output: {format: xlsx}select c.region, sum(o.net_amount) as revenue
from {{ source('shop', 'orders') }} o
join {{ source('shop', 'customers') }} c
on o.customer_id = c.customer_id
group by c.region
order by c.region# Report-linked tables are exposed by default.
expose_report_tables: true
# Additional tables and schemas require explicit opt-in.
# tables:
# warehouse: [analytics.customer_targets]
# Exclusions override inherited exposure.
# exclude_tables:
# warehouse: [analytics.customer_private]# Requires DRE 0.4.1 or later.
dre extension install dre-mcp@0.1.0-rc.1 --accept-proprietary
# Read the complete EULA before accepting it.
dre mcp license show
dre mcp license accept --version 2026-10
dre mcp validate
dre mcp test
dre mcp serve