스킬 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 실버

Maintain this Skill? Claim it 🥈 80 실버

내 에이전트로 설치

이 요청을 에이전트에 복사하세요. 공식 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 에이전트, 크롤러, 스크립트가 전체 페이지 대신 정리된 컨텍스트만 필요할 때 이 링크를 사용하세요.

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 • 2026. 7. 23. 버전별 보고서 열기

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는 근거를 보고하지만 이 Skill의 안전 여부를 판단하지 않습니다.

버전별 보고서 열기

보고서 링크 복사

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

유지보수 최신성

2026. 7. 23.

사용량

0 다운로드 · 0 조회

파일 구조

📄 SKILL.md