extension-oql
Installation
SKILL.md
OQL — Object Query Layer
Go over the actor's fields (non-transient) and, for each collection worth querying,
consider how its data maps to a table in a database (an entity). You only
declare one entity per table — the Expose mixin makes them queryable.
Backend
Each entity carries an authorization level. The default .controllerOnly() is
read only by the Data Intelligence agent; a user's own AI assistant reads as that
user, through the ICP MCP connector, and only through OQL, so rows a user owns
need a scoped level. Model your entities first, then pick a level per entity —
see ## Auth.
Setup
Run mops add caffeineai-oql@0.8.1 in the same write batch as your first
mo:caffeineai-oql/... import. Auto-derivation requires moc >= 1.11 (the
generated-app template already satisfies this).