📦

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 فضي

التثبيت باستخدام Agent لدي

انسخ هذا الطلب إلى Agent لديك. يتضمن صفحة Skill المعتمدة وملف manifest.

طلب الوكيل

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 عرض خطته وطلب أي تأكيد تفرضه سياسة الأمان.

موارد مهيّأة لـ Agents

استخدم هذه الروابط عندما يحتاج AI Agent أو crawler أو script إلى سياق نظيف بدلًا من قراءة الصفحة كاملة.

تفاصيل 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 • ٢٣‏/٧‏/٢٠٢٦ فتح التقرير المرتبط بالإصدار

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

الأسطر التي تم تحليلها

عناصر المراجعة

تم تجاهل الإيجابيات الكاذبة

عوامل الخطر

⚙️ الأوامر الخارجية (50)

لم يكتشف أحدث تدقيق ثابت ودلالي مكتمل أي نتائج أمنية مؤكدة. ولا يثبت ذلك أن المهارة خالية من الآثار الجانبية.

دقّقه: codex

شارك واستشهد بهذا التقرير

شارك تقرير التقييم المرتبط بالإصدار والشارة المحايدة وبطاقة التضمين والاستشهادات. تعرض Skillstore الأدلة من دون أن تقرر ما إذا كانت هذه المهارة آمنة.

فتح التقرير المرتبط بالإصدار

نسخ رابط التقرير

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

حداثة الصيانة

٢٣‏/٧‏/٢٠٢٦

الاستخدام

0 تنزيلات · 0 مشاهدات

بنية الملفات

📄 SKILL.md