Metrics SQL by Rill vs Sourcegraph Cody MCP Server

“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.”

“The primitive here is clean: Sourcegraph's code graph as an MCP tool, meaning any MCP-compatible client gets semantic code search, symbol resolution, and cross-repo context via a well-defined interface rather than a vendor-locked plugin. The DX bet is correct — instead of forcing you to adopt Cody as your IDE extension, they expose the valuable part (the index) as a composable service. The moment of truth is connecting it to Claude Desktop and running a cross-repository symbol search; if that works in under 5 minutes with no custom config, this earns its ship. The specific technical decision that gets the ship: they exposed the code graph as a protocol primitive, not a product bundle.”

“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.”

“Direct competitors are GitHub Copilot Workspace and Cursor's codebase indexing — both of which are now shipping their own MCP surfaces. Sourcegraph's actual defensible asset is the enterprise code graph built on years of cross-repo indexing at scale, which neither GitHub nor Cursor can match for large polyglot monorepos. The scenario where this breaks: teams under 50 engineers with a single GitHub repo get nothing here they couldn't get from Cursor's native context. What kills this in 12 months isn't a competitor — it's GitHub Copilot indexing cross-repo context natively, which Microsoft has every incentive to ship. The reason I'm still shipping it: Sourcegraph has the enterprise sales motion and the graph depth that makes this genuinely valuable to the buyer who most needs it right now.”

“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 thesis Sourcegraph is betting on: by 2027, AI coding clients will be commoditized at the interface layer, and the durable value accrues to whoever owns the best structured representation of a codebase. Making the code graph an MCP server is the right infrastructure move — it positions the graph as a read layer that survives IDE wars. The dependency that has to hold: MCP actually becomes a stable cross-vendor standard rather than another protocol that fractures into incompatible implementations by 2026Q4. The second-order effect that matters: this creates a market for code graph infrastructure separate from code editing, which is a new category. Sourcegraph is on-time to this trend — not early, not late — but they're one of the only players with the enterprise index depth to make the bet credible.”

“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.”

“The buyer is the enterprise DevTools budget holder — VP Engineering or CTO at a company with 200+ engineers and a complex polyglot codebase. That's a real check-writer with a real problem. The moat is the indexed code graph itself: years of enterprise customer data have trained the retrieval system in a way that can't be replicated by a new entrant standing up an MCP server this quarter. The stress test: if Anthropic or OpenAI ships native codebase indexing into their APIs, the MCP server becomes a pass-through with no differentiation. The specific business decision that earns the ship is using MCP to extend the graph's reach without cannibalizing the existing enterprise seat revenue — it's an expand motion disguised as an open protocol move, and that's smart distribution.”