What’s in it
Schema annotations
Pin business meaning to columns and tables:
flag_2_new = cancellation flag, 1 = Active, 0 = Cancelled. Stored encrypted per tenant.Business glossary
Tenant-wide terms — “MRR”, “VIP customer”, “active subscription” — each mapped to a definition and (optionally) the SQL pattern that computes it.
Query Memory
Validated question→SQL pairs the agent has gotten right before, retrieved as few-shot examples on the next similar question. The more it runs, the sharper the SQL — isolated per tenant.
Live retrieval
Slack threads, Microsoft 365 emails, and content from connected SaaS apps are embedded per tenant and retrieved at query time, with citations.
Schema relationships
Foreign-key hints and virtual relationships you declare in the panel — so the agent writes correct joins even when the database has no FK constraints.
How an agent uses it
Every agent request — in chat, in a flow, or via the API — builds a per-tenant context bundle:- Active annotations and glossary terms for the scoped sources are injected into the agent’s tool descriptions and system prompt.
- If the prompt mentions a concept (
MRR,VIP customer), the glossary entry is surfaced before SQL generation. - Similar past queries from Query Memory are added as examples.
- Relevant document chunks from Slack / M365 retrieval are added with citations.
- The agent picks the right tool, writes the right SQL, and answers grounded in your data.
flag_2_new means or invent a definition of MRR.
What you control
In the panel under Semantic Layer:- Annotations — one entry per column or table: business term, value map (
1 = Active, 0 = Cancelled), example values, PII flag. The schema tree supports filtering and pagination for databases with hundreds of tables. - Glossary — define tenant-wide terms once; every agent call sees them.
- Virtual relationships — declare implicit joins your database doesn’t enforce.
- Audit — see when each entry was added and by whom.
Per-tenant isolation
Unified Context is strictly tenant-scoped — independent annotation sets, glossaries, memories, and retrieval per organization. No cross-tenant reads, no shared training data. Isolation is enforced at the database with Row-Level Security, not just in the application. See Governance.Plan availability
Unified Context is included in every plan — Free, Growth, Team, and Enterprise. Tier differences are volume (data sources) and enterprise controls (RBAC, audit, air-gap), not the context layer itself.Roadmap
- Self-healing verification — automatically detect when an annotation has gone stale against live data (new enum values, dropped columns) and flag it for review.
- Suggested annotations — propose entries from column-name patterns and reused query shapes.