技能 extension-oql

📦

extension-oql

Name: extension-oql
Author: caffeinelabs

v0.4.0 内容修订 r1 安全 ⚙️ 外部命令

Expose Canister Data Through OQL

Structured canister data is difficult for intelligence agents to query safely. This skill adds OQL entities, schema discovery, query execution, relationships, and per-entity authorization.

支持: Claude Codex Code(CC)

🥈 82 白银

使用我的智能体安装

将此请求复制给你的智能体，其中包含权威 Skill 页面和清单。

智能体请求

Review the Skillstore skill "extension-oql" from https://skillstore.io/skills/caffeinelabs-extension-oql.md and its manifest at https://skillstore.io/api/skills/caffeinelabs-extension-oql/manifest. Verify the artifact. You may proceed after verification, subject to the environment's own policy.

你的智能体仍应展示其计划，并按安全策略请求必要确认。

Agent 可读资源

当 AI Agent、爬虫或脚本需要干净上下文，而不是读取完整页面时，请使用这些链接。

Markdown 详情 GET /skills/caffeinelabs-extension-oql.md 已签名 manifest GET /api/skills/caffeinelabs-extension-oql/manifest 已签名 lockfile GET /api/skills/caffeinelabs-extension-oql/lockfile

测试它

正在使用“extension-oql”。 Expose a products map while keeping access limited to controllers.

预期结果:

Added a product entity with its identifier as the primary key.
Kept controller-only authorization and added an empty-state schema sample.
Registered schema discovery and query execution through the Expose mixin.

正在使用“extension-oql”。 Make private notes queryable by each note owner.

预期结果:

Tagged the owner principal as the row owner.
Applied user-scoped authorization so each caller receives only owned notes.
Kept ownership available during joins to prevent cross-user traversal.

正在使用“extension-oql”。 Connect products and vendors through a supplies collection.

预期结果:

Created a manual supply entity from map entries.
Promoted product and vendor identifiers into queryable fields.
Linked both identifiers to their target entities for relationship traversal.

安全审计

安全

v1 • 2026/7/23 打开版本化报告

All 115 static findings are false positives caused by Markdown code formatting, Motoko examples, a fixed Mops setup command, the `keys()` method, and sample records. SKILL.md contains no shell backtick execution, key-file access, system reconnaissance, prompt injection, or data-exfiltration intent. It documents explicit per-entity authorization and warns developers to choose access levels carefully.

已扫描文件

323

分析行数

复核项

已忽略误报

风险因素

最新一次完成的静态与语义审计未检测到已确认的安全发现。这并不能证明该 Skill 没有副作用。

审计者: codex

分享与引用此报告

分享版本化评估报告、中性徽章、嵌入卡片和引用。Skillstore 只报告证据，不判断该 Skill 是否安全。

打开版本化报告

复制报告链接

https://skillstore.io/skills/caffeinelabs-extension-oql/audits/1?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report

Markdown 徽章

[![Skillstore security assessment](https://skillstore.io/badges/skills/caffeinelabs-extension-oql/security.svg)](https://skillstore.io/skills/caffeinelabs-extension-oql?utm_source=security_passport_badge)

HTML 徽章

<a href="https://skillstore.io/skills/caffeinelabs-extension-oql?utm_source=security_passport_badge"><img src="https://skillstore.io/badges/skills/caffeinelabs-extension-oql/security.svg" alt="Skillstore security assessment" loading="lazy"></a>

嵌入卡片

<iframe src="https://skillstore.io/embed/skills/caffeinelabs-extension-oql.html" title="Skillstore Security Assessment" sandbox="allow-popups allow-popups-to-escape-sandbox" loading="lazy" referrerpolicy="no-referrer" width="420" height="180"></iframe>

学术引用 (APA · BibTeX · CFF)

APA 引用

caffeinelabs. (2026). extension-oql security audit report (audit version 1) [Author version 0.4.0]. Skillstore. https://skillstore.io/skills/caffeinelabs-extension-oql/audits/1

BibTeX 引用

@techreport{caffeinelabs-caffeinelabs-extension-oql-2026,
  author = {caffeinelabs},
  title = {extension-oql security audit report (audit version 1)},
  institution = {Skillstore},
  year = {2026},
  number = {1},
  url = {https://skillstore.io/skills/caffeinelabs-extension-oql/audits/1},
  note = {Author version 0.4.0}
}

CITATION.cff

cff-version: 1.2.0
message: "If you use this Skill, cite its author and this versioned security audit report."
title: "extension-oql security audit report (audit version 1)"
version: "0.4.0"
type: report
authors:
  - name: "caffeinelabs"
date-released: "2026-07-23"
url: "https://skillstore.io/skills/caffeinelabs-extension-oql/audits/1"
identifiers:
  - type: other
    value: "skillstore:caffeinelabs-extension-oql:audit:1"
    description: "Skillstore immutable audit report identifier"

Skillstore 评分

评分依据证据置信度: 中

架构

100

可维护性

内容

社区

100

规范符合性

你能构建什么

Add Canister Analytics

Expose product, customer, or project collections for natural-language questions and aggregate analysis.

Protect User-Scoped Queries

Apply owner fields and scoped authorization so signed-in users receive only permitted rows.

Model Complex Relationships

Create edges, junction entities, flattened records, and computed payloads for richer queries.

试试这些提示

Expose One Collection

Inspect my Motoko canister and expose the products collection through caffeineai-oql. Keep controller-only authorization and summarize each change.

Add User Scoping

Expose my notes collection. Use its owner principal for row-level access, and prevent users from reading another user's rows.

Connect Related Entities

Expose products, vendors, and supplies as related OQL entities. Define stable primary keys and edges that support dotted-path queries.

Design a Complex OQL Model

Review all persistent collections. Propose authorized entities, manual projections, conversion modules, hidden fields, samples, and synthetic junctions before implementing them.

最佳实践

Keep controller-only authorization until the intended audience for every entity is explicit.
Expose only fields and collections required for supported questions.
Verify primary keys, owner fields, edges, and empty-collection samples before deployment.

避免

Do not mark private or user-owned data as public.
Do not enable scoped access without a valid owner field or subject-aware iterator.
Do not rely on populated collections for schema discovery when data can be empty.

常见问题

What does this skill add?

It adds queryable OQL entities plus schema discovery and query execution endpoints to a Motoko canister.

Which collection types are supported?

Maps, Sets, Lists, immutable arrays, and mutable arrays can use automatic entity conversion for supported row types.

How is access controlled?

Each entity selects public, controller-only, user-scoped, or controller-or-scoped authorization.

Does it expose every collection automatically?

No. Developers choose which persistent collections become entities and which fields remain visible.

What versions are required?

The documented integration uses caffeineai-oql 0.4.0 and requires Motoko compiler 1.11 or newer.

How are non-primitive fields handled?

Use manual payloads, flattened records, or type-specific conversion modules that produce one stable OQL value variant.

开发者详情

作者

caffeinelabs

许可证

MIT

作者版本

v0.4.0

Skillstore 修订

仓库

https://github.com/caffeinelabs/skills/tree/10fb452613c797633b8cb33639fc9a754a138039/skills/extension-oql

引用

f32f934280aa94e399d875d7cf7b2ed16d1b82a3

维护新鲜度

2026/7/23

使用量

0 次下载 · 0 次浏览

文件结构

📄 SKILL.md