After an AI Agent Nearly Leaked Another Tenant's Revenue, Dev Open-Sources Canonic MCP Server
canonic-app · reddit · 2026-09-06
A developer found their multi-tenant analytics LLM agent generated technically valid SQL that joined across tenant boundaries — no prompt injection needed. Semantic layers like dbt describe metrics but don't enforce mandatory filters or tenant scoping.
They built canonic, an open-source context layer between agent and warehouse that compiles business rules (mandatory filters, required dimensions, tenant/role scoping) directly into every query, and returns answers with a trust score explaining why they should be believed. Ships as an MCP server for Claude Code, Cursor and others; ingests dbt/LookML or raw schemas.
More from coding & agent
- Claude Code overtakes Cursor and Copilot in job-post mentions ahead of Anthropic IPO — antgoldbloom · 2026-11-19
- Dev submits PR adding periodic checkpoints to GKE sandboxes so agents don't lose progress — yoimnotkesku · 2026-11-19
- AWS adds private CA support to Bedrock AgentCore Identity for connecting agents to self-hosted IdPs — AWS ML Blog · 2026-11-19
- Orchestrator's Cloud Agents graduate from beta to general availability — julianweisser · 2026-11-19
- Zero users, 33 pages shipped: dev crowdsources audit for AI-agent trust schema — TheHamzaShahbaz · 2026-11-19
- She vibecoded her own photobooth with Claude Code — and shared the prompt — toolstelegraph · 2026-11-19