Turn Leadership Questions Into Trusted Answers.
Rudder Analytics builds a custom Model Context Protocol (MCP) server for your existing warehouse. Leaders ask questions through a connected AI assistant. The server applies your metric definitions and access rules, and returns results with the calculation, filters and reporting period.
Sale buyers come back at half the rate. After 120 days, 12% of spring-sale customers ordered again, against 25% of full-price buyers. Their second orders were also 31% smaller.
Built on the open MCP standard. Sits on the stack you already run.
Answers Beyond the Dashboard
Leadership meetings raise questions that existing reports do not cover. Answering them can mean joining data across systems or waiting for an analyst.
The Answer Spans Several Systems
Sales units, product costs and refunds often come from different systems. A one-off question needs those records joined and interpreted consistently.
Every New Cut Becomes a Ticket
An analyst rebuilds context, writes SQL and sends a spreadsheet. By then, the meeting has moved on.
Exports Drift From the Truth
Last week's CSV disagrees with this week's close. The Monday meeting debates which file is right instead of what to do.
Valid SQL Can Still Give the Wrong Answer
A query can run successfully and still use the wrong currency, period or definition. The result looks credible until someone checks the logic.
Rudder Analytics builds business definitions and query checks into the MCP server, with access controls enforced for each user.
“What was net revenue in Q3?”
- Added USD and EUR orders together as one currency
- Counted budget and forecast rows as actual results
- Ignored returns that posted after quarter close
- Quoted September in full before the last week finished loading
Actual Q3 net revenue, in USD reporting currency: $11.6M. The reply overstates it by $3.2M.
In dbt Labs’ April 2026 benchmark, Claude Sonnet 4.6 scored 90.0% with text-to-SQL and 98.2% with the dbt Semantic Layer.
dbt Labs benchmark, April 2026Introducing Rudder Analytics MCP
A COO works through three hard questions in one continuous chat. Each answer moves from headline to root cause to a recommended next step.
An Analyst That Already Knows How Your Business Counts
The assistant queries the data behind your dashboards through the MCP server. Rudder Analytics configures the metric definitions and access rules so leaders can explore questions beyond existing reports.
Ask follow-up questions across the data your role can access. The assistant uses the server’s tools to find relevant tables and run permitted queries. Results can be exported where an approved export workflow is available.
Which regions grew online sales this year but lost margin to shipping costs?
ordersshipping_costproduct_costPermitted query · read-only
$2.6Mmargin lost to free-shipping orders in 4 of 12 regions, while their online sales grew 15–22%
Rudder Analytics documents agreed KPI formulas and builds reusable queries for common questions. These are checked against the corresponding dashboard metrics during setup.
(net sales − COGS) ÷ net salesstock ÷ weekly sales rateunits sold ÷ units receivedunits returned ÷ units shippedGross margin, last 12 months: one formula, one figure
Each number arrives with its formula, filters and period. A CFO can audit the logic without opening SQL.
$8.42M+6.2% on Q2
Where Q3 DTC net sales went$26.84M
The chart tool uses returned query values to generate each chart, keeping the plotted figures tied to the result.
Gross profit by month, $M
6 rows returned · 12 points plotted · 0 values typed
The server checks the last loaded day for each table it touches, and flags partial periods in the answer.
sales_lineOct 8 · 07:30profit_and_lossSep closedinventory_moveWeek 41 partialWeek 41 is partial. Stock moves are loaded through Thursday, Oct 8, and the answer says so.
Each leader signs in individually. Rudder Analytics maps that identity to the data they are permitted to access. Assistant licensing and usage limits depend on the selected platform and plan.
- CEOChief executiveClaude · individual sign-inAll areas
- CFOFinanceClaude · individual sign-inFinance · Sales
- COOOperationsClaude · individual sign-inOrders · Stock
- VPSalesClaude · individual sign-inSales
OAuth sign-in per person · access mirrors their portal role
Curated questions help leaders explore sales, orders, finance and merchandising. They can use a starter or ask their own question.
Business Context Behind Every Query
The assistant needs to know how your business counts revenue, groups channels and reports across entities. Rudder Analytics documents those rules, builds the query tools and validates the results. The definitions are maintained as your business changes.
Learns the Business
Loads entities, channels, the fiscal calendar and house rules for the analysis.
get_business_contextFinds the Right Data
Opens only the tables a question needs, with their required filters and relationships.
describe_tableChecks Freshness
Confirms the last fully loaded day before quoting any period.
get_data_freshnessRuns the Numbers
Uses a governed metric where one exists, and read-only SQL where none does.
query_metricShows the Working
Returns the figure with formula, filters, period and a chart from real rows.
render_chartLive With a Global Outdoor Apparel Brand
The brand sells through wholesale, DTC, Amazon, closeout, intercompany and OEM channels, across two legal entities in North America and EMEA. Its leadership portal already ran on Azure and ClickHouse, with two ERPs unified. Rudder Analytics added a governed MCP server on the same tables. It covers sales, orders, financials, merchandising and reporting.
Which styles were top 10 by units this year but ranked far lower on gross profit, and what does each earn per unit?
3 of the top-10 styles by units ranked far lower on gross profit. Each earned roughly a third of the brand's top styles per unit.
Gross profit per unit, indexed (top-earning style = 100)Two of the three flagged styles
The analysis points to lower selling prices rather than weaker margin rates. The flagged styles held margins of 60–64%, with discount depth and product costs also checked.
Access Controls and Query Governance
Rudder Analytics configures warehouse permissions, query checks and audit logging as part of deployment. Your security team reviews the access model, data flow and retention settings before launch.
Read-Only by Construction
The server uses read-only warehouse credentials and exposes no tools for changing business records.
Access Matched to Each Role
Rudder Analytics maps each authenticated user to permitted data. Restricted requests return a permission notice.
Every Call on the Record
Each call is logged with who asked, when, and what came back.
Required Filters Enforced
A query that skips a mandatory currency or scenario filter is refused.
Plans Never Pass as Actuals
Budgets and targets stay labeled as plans, never as results.
Query Result Limits
Interactive responses are capped at 300 rows. Query execution limits are configured separately for your warehouse.
Per-Person Sign-In
Each leader authenticates individually. Access is revoked per person.
No Separate Analytics Warehouse
Queries run in your existing warehouse. Returned results are sent to the connected assistant under the agreed access and data-handling policies.
Why Not Just Use the Connector Your Vendor Ships?
A vendor connector can answer questions within its supported systems. Cross-system analysis also needs consistent definitions for revenue, costs and returns. Rudder Analytics builds that context around the data already brought together in your warehouse.
| Vendor connectorsstorefront, ERP, email tools | DIY text-to-SQLan LLM pointed at the warehouse | Rudder Analytics MCPgoverned, on your warehouse | |
|---|---|---|---|
| Data coverage | Depends on connector | Depends on connected data | Integrated warehouse data |
| Metric definitions | Product-specific or configurable | Your team defines them | Agreed metric catalog |
| Dashboard reconciliation | Depends on implementation | Your team validates it | Checked during setup |
| Required-filter checks | Depends on connector | Your team implements them | Configured server checks |
| Read-only access and audit logging | Depends on connector | Your team configures them | Configured for the deployment |
| Ongoing maintenance | Vendor and internal team | Your team | Rudder Analytics |
What Leadership Teams Ask First
Still have one? Bring it to the strategy call.
Can the AI invent numbers?
The server supplies query results and metric definitions, but the assistant can still misinterpret a result. Showing the calculation, filters and period makes answers easier to check. Rudder Analytics tests common questions against agreed results and reviews failures during ongoing support.
Which AI assistants does it work with?
The production deployment described here uses Claude. Other MCP-capable assistants can be assessed during setup. Compatibility depends on the specific product, plan, authentication method and tools required.
Do we need a new warehouse or BI platform?
No new warehouse or BI platform is required. The server uses your existing warehouse. Rudder Analytics checks whether the data, metric definitions and access controls are ready during the assessment.
Can it change or delete anything?
This deployment uses read-only warehouse access and exposes no tools to update your business systems. Questions can retrieve permitted data but cannot change business records.
What does it cost to run?
Costs include setup, server hosting, warehouse queries and ongoing support, alongside assistant licenses or model usage. Rudder Analytics scopes these costs against your expected users and workload.
How does it stay accurate as the business changes?
Business definitions, table guides and the metric catalog are version-controlled. Changes are tested against agreed results before deployment. Failed queries and new reporting needs inform updates.
Does this require AI expertise in-house?
No. Rudder Analytics builds, validates and maintains the server and its context layer. Your team brings the questions and signs off on the metric definitions.
Agentic AI
AI agents that call your systems, follow your rules and complete tasks with audit trails.
Related platformAI OS for eCommerce
Sales, finance, operations and supply chain in one governed commerce center.
Related serviceAI Shopping Agent
Turn product questions on your Shopify store into confident purchases.
Bring the One Question Your Dashboards Can't Answer
In a 30-minute strategy call, Rudder Analytics maps it to your data. You'll see which tables and metrics it touches, and what a governed MCP server would take for your business.
