Dust MCP Server Builder vs Metrics SQL by Rill

“The primitive here is an MCP server configuration layer: you point it at an internal API, describe the schema, and Dust emits a spec-compliant MCP server that agents can discover. That's a real and annoying problem — every enterprise AI project starts with 'okay but how does the agent actually talk to our Salesforce instance.' The DX bet is low-code config over explicit server code, which is the right call for the target audience (platform engineers who shouldn't have to maintain Node glue code). My concern is the moment of truth: what happens when the internal API has weird auth, non-standard pagination, or needs a custom retry strategy? If the config layer handles 80% cleanly and exposes escape hatches for the rest, this earns its place. If it's a GUI over a fixed template with no overrides, it's a drag-and-drop wrapper that breaks the second anything is non-trivial. No public repo to verify, which costs a full tier.”

“We've been burned by data agents that invent their own GROUP BY logic and produce wrong numbers that look right. Metrics SQL solves this at the infrastructure level — define revenue once, have every agent query the same definition. The SQL-native interface means no new tools for agents to learn; they just use the tables.”

“Category: enterprise MCP tooling. Direct competitors include Stainless, Speakeasy, and the growing pile of 'API-to-MCP' converters that have shipped in the last six months — this is not a novel surface. The specific scenario where this breaks is a mid-sized enterprise with a mix of legacy SOAP services, OAuth2 APIs, and internal GraphQL endpoints that all have different auth models; I'd bet the builder handles REST-over-JSON and nothing else gracefully. What kills this in 12 months: Anthropic or a major API gateway (Kong, Apigee) ships native MCP export as a checkbox feature, and the 'build your MCP server without code' pitch evaporates because the platform you're already paying for does it. To earn a ship, Dust needs to show this works on the weird, legacy, authenticated-weirdly APIs that actually exist in enterprises — not just the clean demo APIs on their landing page.”

“The value here is only as good as how well-maintained your metric definitions are — if analysts don't keep them updated, agents query stale or wrong definitions and you've added a layer of false confidence. Adopting a semantic layer also creates vendor dependency; migrating away from Rill's cloud later is a real switching cost. For smaller teams without dedicated data engineering, maintaining a semantic layer is overhead.”

“The thesis Dust is betting on: by 2027, enterprise AI deployment bottlenecks shift from 'can we run models' to 'can agents reliably access the right internal context,' and MCP becomes the lingua franca for that handoff. That's a plausible and specific bet — MCP adoption is accelerating faster than most protocol specs do because it has Anthropic's weight behind it and tooling vendors are shipping support quickly. The second-order effect that matters here isn't the time saved writing glue code — it's that Dust becomes the registry layer for enterprise agent capabilities, which is a fundamentally different and stickier position than 'we run your agents.' The dependency that has to hold: MCP doesn't fragment into competing schemas before enterprise buyers standardize on it. That's not guaranteed, but the trend line is more favorable than not. Dust is roughly on-time to this, not early — the risk is that the window for owning the registry layer closes fast.”

“Data governance and AI agents are on a collision course. As more business decisions are delegated to AI, the correctness of KPI computation becomes load-bearing — a hallucinated revenue figure that influences a product decision is a serious failure mode. Metrics SQL represents a class of infrastructure that will become mandatory as AI takes on more analytical work.”

“The buyer here is a VP of Engineering or Head of AI Platform at a company already inside Dust's enterprise tier — this is an upsell motion to an existing customer base, not a new acquisition channel. That's fine strategically, except the pricing page doesn't exist: it's 'contact sales' all the way down, which means I can't evaluate whether the expansion revenue math actually works. The moat question is critical: if this is just a config UI that emits MCP specs, the defensibility is entirely dependent on Dust's broader workflow lock-in, not on this feature itself. The existential stress test is what happens when AWS, Azure, or a major API gateway ships 'export as MCP server' natively in 2025 or 2026 — at that point, Dust's MCP builder is a feature parity checkbox, not a differentiator. For this to be a real business move, Dust needs the builder to generate proprietary metadata or agent-routing intelligence that makes migrating away expensive, not just inconvenient.”

“I rely on AI to pull weekly performance data, and the number of times it's given me different 'correct' answers for the same metric is maddening. Having a single governed source that every AI query resolves against means I can trust the numbers I'm making decisions on. That trust is worth a lot.”