mem9.ai vs Metrics SQL by Rill

“The primitive is clean: a drop-in MCP-compatible memory server that swaps file-backed agent memory for a cloud-persistent hybrid search store backed by TiDB. The DX bet is right — complexity lives at the infrastructure layer (TiDB handles distributed storage and indexing), so the agent-side API stays thin. The moment of truth is connecting a second agent to the same server and watching it recall context the first agent wrote; that's the demo that earns the ship. You could not replicate genuine hybrid vector + keyword search with cross-agent consistency in a weekend script — the distributed consistency guarantees alone are a real engineering problem this solves.”

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

“Direct competitors are Zep, Mem0, and whatever LangChain Memory ships next — and mem9 beats them on one specific axis: the TiDB backend means you're not doing vector-only retrieval on structured technical knowledge, where BM25 keyword search materially outperforms cosine similarity. The scenario where this breaks is large teams with conflicting write patterns — there's no obvious memory conflict-resolution story yet, and shared mutable state across agents will produce garbage reads at scale. What kills it in 12 months: OpenAI or Anthropic ships native persistent memory into their API that frameworks adopt overnight — but until that happens, the open-source Apache-2.0 license and TiDB's infrastructure credibility make this the most defensible standalone memory layer I've seen.”

“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 is falsifiable: within three years, multi-agent systems working on shared codebases will require a persistent, shared knowledge substrate the same way they require a shared filesystem today — and whoever owns that substrate owns a critical layer of the agent stack. The dependency that has to hold is that agents remain heterogeneous (different vendors, runtimes, frameworks), which keeps a neutral shared memory layer valuable versus each model provider building their own silo. The second-order effect nobody is talking about: if your CI pipeline agents and your local dev agents share the same memory, institutional knowledge stops living in Confluence and starts living in a queryable, semantically indexed store that actually surfaces when relevant — that's a genuine shift in how teams externalize context.”

“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 platform or infrastructure engineer at a company already running multiple AI agents — a narrow, technical buyer who will self-host before paying for a cloud tier that doesn't exist yet. The moat is real (TiDB's distributed infra is not easily replicated and the Apache-2.0 open-core is a proven wedge strategy), but the monetization path is invisible: 'cloud hosted pricing TBD' is not a business model, it's a GitHub repo with ambitions. What would flip this to a ship is a credible hosted tier with pricing that scales on memory operations or agent seats — something that creates a natural land-and-expand motion from the indie dev who self-hosts to the enterprise team that pays for managed reliability.”

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