المهارات extension-querying-oql

📦

extension-querying-oql

Name: extension-querying-oql
Author: caffeinelabs

v0.4.0 مراجعة المحتوى r1 آمن ⚙️ الأوامر الخارجية📁 الوصول إلى نظام الملفات

Query OQL Canisters with the ICP CLI

Writing OQL queries requires exact schema names, JSON types, Candid escaping, and careful pagination. This skill provides practical patterns for reliable, read-only canister queries.

يدعم: Claude Codex Code(CC)

🥈 80 فضي

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

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

طلب الوكيل

Review the Skillstore skill "extension-querying-oql" from https://skillstore.io/skills/caffeinelabs-extension-querying-oql.md and its manifest at https://skillstore.io/api/skills/caffeinelabs-extension-querying-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-querying-oql.md manifest موقَّع GET /api/skills/caffeinelabs-extension-querying-oql/manifest lockfile موقَّع GET /api/skills/caffeinelabs-extension-querying-oql/lockfile

اختبرها

جارٍ استخدام "extension-querying-oql". Find the five enterprise customers with the highest monthly revenue.

النتيجة المتوقعة:

Query completed against the customer entity with an enterprise-plan filter and descending revenue order.
Five rows returned. Each row includes the company name, monthly revenue, and account manager.

جارٍ استخدام "extension-querying-oql". Which account manager office has the highest average customer revenue?

النتيجة المتوقعة:

Query grouped customer rows by the account manager office and calculated average monthly revenue.
The result lists offices from highest to lowest average and reports whether more groups are available.

التدقيق الأمني

آمن

v1 • ٢٣‏/٧‏/٢٠٢٦ فتح التقرير المرتبط بالإصدار

All 160 static alerts are false positives caused by Markdown backticks, code fences, ordinary technical terms, or a pagination ellipsis. The skill documents explicit read-only ICP canister queries and contains no prompt injection, destructive behavior, credential access, or data exfiltration instructions.

الملفات التي تم فحصها

350

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

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

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

عوامل الخطر

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

دقّقه: codex

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

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

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

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

https://skillstore.io/skills/caffeinelabs-extension-querying-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-querying-oql/security.svg)](https://skillstore.io/skills/caffeinelabs-extension-querying-oql?utm_source=security_passport_badge)

شارة HTML

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

بطاقة قابلة للتضمين

<iframe src="https://skillstore.io/embed/skills/caffeinelabs-extension-querying-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-querying-oql security audit report (audit version 1) [Author version 0.4.0]. Skillstore. https://skillstore.io/skills/caffeinelabs-extension-querying-oql/audits/1

اقتباس BibTeX

@techreport{caffeinelabs-caffeinelabs-extension-querying-oql-2026,
  author = {caffeinelabs},
  title = {extension-querying-oql security audit report (audit version 1)},
  institution = {Skillstore},
  year = {2026},
  number = {1},
  url = {https://skillstore.io/skills/caffeinelabs-extension-querying-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-querying-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-querying-oql/audits/1"
identifiers:
  - type: other
    value: "skillstore:caffeinelabs-extension-querying-oql:audit:1"
    description: "Skillstore immutable audit report identifier"

تقييم Skillstore

سبب هذا التقييم موثوقية الأدلة: متوسط

الهندسة المعمارية

100

قابلية الصيانة

المحتوى

المجتمع

الامتثال للمواصفات

ما الذي يمكنك بناؤه

Analyze canister data

Explore a canister schema, filter business records, and calculate grouped metrics without downloading every row.

Validate an OQL backend

Validate OQL entities, edge declarations, result shapes, and query behavior during canister development.

Diagnose query failures

Diagnose parse traps, missing fields, type mismatches, pagination problems, and unexpected relationship results.

جرّب هذه الموجّهات

Inspect an OQL schema

Call the backend schema method with the ICP CLI. Summarize each entity, primary key, field type, allowed value, and declared edge.

Run a filtered query

Using the current schema, build and run a read-only query for [entity]. Filter by [condition], select [fields], and limit results to [number].

Calculate grouped metrics

Build and run an OQL query that groups [entity] by [field]. Calculate [aggregate] for [measure], sort descending, and return [number] groups.

Analyze related entities

Answer [question] across [parent entity] and [child entity]. Use dotted paths when possible, otherwise batch parent keys, paginate, and summarize verified results.

أفضل الممارسات

Read and cache the schema before building queries, then use its exact names, field types, allowed values, and edge declarations.
Set an explicit limit, inspect hasMore, and paginate with increasing offsets until the requested result set is complete.
Use server-side filtering and aggregation, then select only the fields needed for the answer.

تجنب

Do not guess entity names, field names, literal types, or relationship paths when the schema provides authoritative values.
Do not omit the result limit or fetch every row when filtering and aggregation can run on the canister.
Do not issue one query per parent key; collect keys and use a single membership filter.

الأسئلة المتكررة

What canisters does this skill support?

It supports canisters that expose the documented read-only schema and execute methods and return the expected Candid result shape.

Does this skill modify canister data?

No. It documents query calls to the schema and execute methods and does not cover update calls.

Why must I read the schema first?

The schema defines valid entity names, field types, allowed values, primary keys, and edges required for correct queries.

How are relationships queried?

Use dotted paths for declared forward edges. For reverse relationships, collect parent keys and query the child edge with membership filtering.

How does pagination work?

Set a limit and offset, inspect hasMore, and increase the offset until the requested rows are complete.

What happens when a query is invalid?

The canister traps without a structured error envelope. Correct the entity, field, type, JSON, or Candid escaping, then retry.

تفاصيل المطور

المؤلف

caffeinelabs

الترخيص

MIT

إصدار المؤلف

v0.4.0

مراجعة Skillstore

المستودع

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

مرجع

f32f934280aa94e399d875d7cf7b2ed16d1b82a3

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

٢٣‏/٧‏/٢٠٢٦

الاستخدام

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

بنية الملفات

📄 SKILL.md