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.
このリクエストをエージェントにコピーしてください。正規の Skill ページとマニフェストが含まれています。
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.エージェントは引き続き計画を提示し、セキュリティポリシーで必要な確認を求める必要があります。
AI エージェント、クローラー、スクリプトがページ全体ではなく整理されたコンテキストを必要とする場合は、これらのリンクを使ってください。
「extension-querying-oql」を使用しています。 Find the five enterprise customers with the highest monthly revenue.
期待される結果:
「extension-querying-oql」を使用しています。 Which account manager office has the highest average customer revenue?
期待される結果:
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.
バージョン付き評価レポート、中立的なバッジ、埋め込みカード、引用を共有できます。Skillstore は証拠を報告しますが、この Skill が安全かどうかは判断しません。
https://skillstore.io/skills/caffeinelabs-extension-querying-oql/audits/1?utm_source=security_passport&utm_medium=share&utm_campaign=versioned_report[](https://skillstore.io/skills/caffeinelabs-extension-querying-oql?utm_source=security_passport_badge)<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>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@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}
}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"
Explore a canister schema, filter business records, and calculate grouped metrics without downloading every row.
Validate OQL entities, edge declarations, result shapes, and query behavior during canister development.
Diagnose parse traps, missing fields, type mismatches, pagination problems, and unexpected relationship results.
Call the backend schema method with the ICP CLI. Summarize each entity, primary key, field type, allowed value, and declared edge.
Using the current schema, build and run a read-only query for [entity]. Filter by [condition], select [fields], and limit results to [number].
Build and run an OQL query that groups [entity] by [field]. Calculate [aggregate] for [measure], sort descending, and return [number] groups.
Answer [question] across [parent entity] and [child entity]. Use dotted paths when possible, otherwise batch parent keys, paginate, and summarize verified results.
作成者
caffeinelabsライセンス
MIT
作者バージョン
v0.4.0
Skillstore リビジョン
r1
参照
f32f934280aa94e399d875d7cf7b2ed16d1b82a3
メンテナンスの新しさ
2026/7/23
利用状況
0 ダウンロード · 0 閲覧
ファイル構成
📄 SKILL.md
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.
Troubleshoot Motoko Migration Failures
Motoko migration errors can conflict with current source code and put deployed state at risk. This reference explains diagnostics and forward-only repairs while preserving migration history.
Build TMDb Movie and TV Features
Movie and TV integrations often fail because generated clients hide authentication, response shapes, and unsupported operations. This skill gives Caffeine developers a tested implementation path for catalog reads, credential handling, and service limits.
為 Caffeine AI 應用程式新增使用者核准機制
應用程式需要一套受控機制，在開放受保護功能前核准使用者存取。本技能提供後端核准檢查與前端管理工作流程的指引。
Add Object Storage to Caffeine AI Apps
Large files need storage beyond Internet Computer canister limits. This skill guides Caffeine AI projects through backend integration, browser uploads, cached display, downloads, and troubleshooting.
Add Camera Capture to React Apps
Web camera integration requires permission handling, preview state, and device controls. This skill guides Claude, Codex, and Claude Code through the provided React hook.
Visualize Personal Finances in a Local Report
作成者 jasonhmy
Financial records can obscure spending patterns when transfers, refunds, and shared purchases are mixed together. This skill reconciles authorized records and creates local interactive charts with transaction details and optional daily allowances.
分析科學資料檔案
作成者 davila7
科學資料檔案很難檢查，因為每種格式儲存結構與中繼資料的方式都不同。此技能會偵測格式、剖析資料品質，並建立實用的 Markdown EDA 報告。
使用 Scanpy 分析單細胞 RNA-Seq
作成者 davila7
單細胞 RNA-seq 工作流程需要謹慎的 QC、正規化、分群與文件化。此技能提供 Scanpy 工作流程、指令碼、範本與參考資料，用於可重現的分析。
處理 JSON、YAML 和 TOML 資料
作成者 0xDarkMatter
結構化設定資料在 JSON、YAML 和 TOML 檔案之間可能難以檢視。此技能會引導使用 jq 和 yq 查詢來進行擷取、篩選、轉換和更新。
建立符合期刊投稿規範的科學圖表
作成者 davila7
科學圖表經常因尺寸、解析度、色彩和標籤而未通過期刊檢查。此技能可引導 Claude、Codex 和 Claude Code 建立兼具無障礙性且可直接用於發表的圖表。
使用 PyTDC 分析治療性 ML 資料集
作成者 K-Dense-AI
藥物探索團隊需要可靠的資料集與公平的評估協定。此技能可協助 Claude 使用 PyTDC 取得精選的治療性 ML 資料、基準切分、指標與分子 oracle。