SeenPixel

Service

Governed “ask your data” agents over the warehouse you already have

A semantic layer, an MCP server, an evaluation loop and access control, so people can ask questions in plain language and get the same number the dashboard gives. Built in a 6–8-week pilot, in your environment.

What it is

Four parts that have to exist together. Leave one out and the project joins the statistics below.

Semantic layer

One definition of every metric and dimension, in Cube, dbt metrics or LookML, so the agent cannot invent a revenue number that disagrees with the dashboard.

Agents and MCP server

An MCP server that exposes typed tools over the semantic layer, and an agent runtime that plans, calls them and explains its answer. Works from Claude, ChatGPT, Slack or an IDE.

Evaluations

A set of golden questions with known answers, run on every change. Accuracy, latency and cost per query are measured, not assumed.

Access control

SSO, row- and column-level rules enforced below the agent, and an audit log of every query. A user gets the same answer the warehouse would give them directly.

Why most of these projects fail

60%

of agentic-analytics projects relying solely on MCP will fail by 2028 without a consistent semantic layer.

Source: Gartner, May 2026

11–14%

of MCP pilots reach production.

Source: Stacklok, State of MCP in Software 2026

71%

of data practitioners worry about hallucinated numbers reaching stakeholders.

Source: dbt Labs, State of Analytics Engineering 2026

The pattern is the same each time: an agent is pointed at raw tables, it writes plausible SQL, the numbers do not match finance, and trust is gone. The fix is not a better prompt. It is a layer that defines the metrics, a policy layer that enforces who sees what, and a test suite that proves the answers.

Reference architecture

The design a pilot starts from. Every component sits inside your cloud account.

Reference architecture for a governed ask-your-data agentA user or assistant sends a question to an agent runtime, which calls an MCP server. The MCP server passes every request through authentication and policy, then through the semantic layer, which generates governed SQL against the warehouse. An evaluation and monitoring loop observes the agent runtime and the MCP server.User / assistantChat, Slack, IDEAgent runtimePlanning, tool callsMCP serverTyped tools, schemasSemantic layerCube · dbt · LookMLWarehouseSnowflake · BigQueryDatabricksAuth and policySSO, row/column rules, audit logEvaluations and monitoringGolden questions, accuracy and cost per query, traces, alertsquestiontool callmetric querygoverned SQL
Reference design. Boxes are components we build or configure; the warehouse is the client's existing one.

What we deliver

  • Semantic model for one or two business domains, in the tool that fits your stack (Cube, dbt metrics or LookML)
  • MCP server with typed tools, schemas and tests, deployed in your environment
  • Agent runtime wired to your chosen interface (chat, Slack, IDE), with explanations and citations back to the metric definitions
  • Evaluation suite: golden questions, scoring, a dashboard for accuracy and cost per query
  • Auth and policy layer: SSO, row- and column-level rules, audit log
  • Monitoring and alerts for latency, error rate and spend
  • Runbooks, architecture notes and a handover session with your team

How an engagement runs

  1. Week 0

    Readiness scan: which questions people actually ask, which tables answer them, what already has definitions.

  2. Weeks 1–2

    Semantic model for the first domain; MCP server skeleton; first 30 golden questions. Stop-point: you can end here and keep the model.

  3. Weeks 3–5

    Agent runtime, access control, evaluation loop, second domain. Internal users on it daily.

  4. Weeks 6–8

    Hardening: cost ceilings, monitoring, runbooks, handover. Production for a defined user group.

After the pilot: stop, extend to more domains, or move to a dedicated pod. See how we work.

Questions we get

Do we need to migrate our warehouse first?

No. The design runs over the Snowflake, BigQuery or Databricks you already have. If the data model is not ready for a semantic layer, the readiness scan says so before anyone pays for a pilot.

Which models and interfaces do you support?

The MCP server is model-agnostic. It works with the Claude and OpenAI APIs, and the agent can be reached from Claude, ChatGPT, Slack or a code editor. You choose; the governance below the agent does not change.

How do you keep the agent from inventing numbers?

It cannot write free-form SQL. Every answer is a query against the semantic layer, which maps to a defined metric. The evaluation suite catches regressions, and the answer cites the definition it used.

What about people who should not see certain rows?

Access control is enforced in the auth and policy layer and in the warehouse, not in the prompt. The agent runs as the user, with the user's permissions.

What does the pilot leave us with if we stop?

The semantic model, the MCP server, the evaluation suite and the docs, in your repositories. All of it is usable without us.

Is there a public demo?

Not a public one. We walk through the reference design, with a live demo, on request. See the reference design.

Ask us about your warehouse

Bring the three questions your team asks most. We will tell you what it takes to answer them with an agent you can trust.