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).

Installs
32.0K
GitHub Stars
2
First Seen
Jun 18, 2026