Menu
Query curated read-only MLAI backend data resources through the permissioned data access API
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/MLAI-AUS-Inc/roo --skill mlai-data-queryThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Answer authorised, read-only questions about MLAI organisational memory in clear conversational language
Admin event/Stripe reports and guarded preparation of outstanding Xero bank-feed transactions.
Create Linear issues or project updates from Slack context, meeting notes, and files with project and assignee resolution
Based on SOC occupation classification
Showing SKILL.md
| name | mlai-data-query |
| description | Query curated read-only MLAI backend data resources through the permissioned data access API |
| requires_auth | true |
| routing | {"use_when":"The user wants to READ curated MLAI backend data: counts, lists, or aggregates over Vibe Raising companies, startup/monthly update drafts, Content Factory jobs/runs, synced Linear issues/projects, Gmail/Slack sync metadata, GitHub integration status, financial records, organizations, or coworking booking records — or asks what data/tables/resources Roo can query.\n","avoid_when":"CREATING Linear issues (linear-meeting-actions). Luma event attendance (luma-events). Personal points/coworking bookings (mlai-points). Questions about files the user uploaded (chat). Roo never writes data or runs SQL.\n","examples":[{"text":"How many Vibe Raising companies do we have?","action":"query"},{"text":"Which Content Factory jobs failed this week?","action":"query"},{"text":"Show Linear issues synced for this startup","action":"query"},{"text":"What data resources can Roo query?","action":"catalog"}],"negative_examples":[{"text":"create a linear ticket from this thread","instead":"linear-meeting-actions"},{"text":"how many people registered for the AI safety event?","instead":"luma-events"},{"text":"how busy was the coworking space in may?","instead":"mlai-points"}]} |
| actions | [{"name":"catalog","description":"List the data resources/tables Roo is allowed to query."},{"name":"query","description":"Run a read-only list/count/aggregate query against one resource.","params":{"resource":{"type":"string","description":"Exact resource key if known (e.g. vibe_raising_companies, content_factory_jobs, linear_issues)."},"operation":{"type":"string","enum":["list","count","aggregate"],"description":"Query type."},"limit":{"type":"integer","description":"Max rows if the user asked for a specific number."}}}] |
Use this skill when a Slack user asks Roo to read curated backend data across the MLAI app, especially Vibe Raising, startup update artifacts, Content Factory state, Linear/Gmail/Slack sync metadata, GitHub integration status, financial metadata, organizations, and coworking booking records.
Roo must not write data and must not send SQL. It calls the backend's read-only data access API:
GET /api/v1/data/catalog/?requester_slack_id=<actual Slack user ID>POST /api/v1/data/query/The backend registry is the security contract. Each resource has explicit allow-listed fields, supported operations, filters, ordering, pagination limits, and role-scoped policies. There is no "admin bypass all" mode. The catalog uses the same requester identity and policies, so it only includes resources, operations, and fields the requesting Slack user can query.
catalog when the user asks what data/tables/resources are available.vibe_raising_companies, monthly_update_drafts, content_factory_jobs, or linear_issues.list, count, or aggregate.{ "field": "...", "operator": "...", "value": ... }.{ "field": "...", "direction": "asc|desc" }.eq, neq, gt, gte, lt, lte, in, and icontains.icontains means case-insensitive substring search and only works on backend fields marked searchable.returned_count, limit, offset, and has_more.count is only the count returned by an explicit count operation. List responses do not include total matching rows.