holistics/anfra-skills

anfra-lookup-values

Verify the exact stored values of a field before filtering on them, guarding against case sensitivity, abbreviations, and typos.

ソースを見る

使い方

  1. インストールコマンドをコピーし、自分の環境へ導入する前にソースを確認します。
  2. 必要なツール、認証情報、対応環境を原文で確認します。
  3. 入力と成果物を指定し、出力を資料と照合します。
npx skills add https://github.com/holistics/anfra-skills --skill anfra-lookup-values

開始前の確認

  • 導入にはモデル契約、API枠、ファイルへのアクセス許可は含まれません。
  • スター数や導入数は活動の指標であり、独立した品質・安全性試験ではありません。
リポジトリの原文

見出し、例、コード、表、リンク、参照画像を含む原文を表示しています。

Verifying field values before filtering

Before you filter on a value, confirm it actually exists in the data in that exact form. Filtering on a guessed literal ("Second-hand", "male", "VN") silently returns wrong or empty results when the stored form differs.

When to use

  • Any filter on a dimension whose exact stored values you haven't confirmed.
  • Especially categorical / text fields — and even "obvious" ones (a gender

column can still hold unexpected values like "f", "m", "F", "M").

How

  1. Identify the field(s) most likely to carry the concept (check field names,

labels, descriptions). Go from the most likely first.

  1. List the distinct values, narrowing with a case-insensitive

where(... ilike ...) filter. Batch 2–3 candidate patterns in a single query (joined with or) to go faster.

  1. Once you've identified the exact value(s), proceed to the real query. Don't

keep using lookups to compute the answer — write the AQL.

Command (swappable per scenario)

Default (Anfra) — unique() lists a dimension's distinct values; add a case-insensitive where(<model>.<field> ilike '%pattern%') to probe candidates, batching several patterns with or:

sh
# distinct values of a (small) column
anfra query --dataset <uname> 'unique(products.type)'

# batch 2–3 candidate patterns for "second-hand" in one query
anfra query --dataset <uname> "unique(products.type) | where(products.type ilike '%second%' or products.type ilike '%sh%' or products.type ilike '%used%')"
Replace this command for other runtimes if needed. The guidance above is stable; only the command changes.

If nothing matches

If you can't find the concept in any field, ask the user to clarify rather than guessing a value.


anfra skills 0.21.0

同じリポジトリから

関連する Skills

すべての Skills