Como usar
- Copie o comando e verifique o pacote antes de instalar no seu ambiente de agente.
- Consulte no original as ferramentas, credenciais e ambientes necessários.
- Descreva os dados de entrada e a entrega esperada; confira a saída com as fontes.
npx skills add https://github.com/holistics/anfra-skills --skill anfra-lookup-valuesAntes de começar
- A instalação não inclui assinatura de modelo, franquia API ou acesso aos seus arquivos.
- Estrelas e instalações indicam atividade, não um teste independente de qualidade ou segurança.
Renderizado do repositório de origem, preservando títulos, exemplos, código, tabelas, links e imagens.
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
- Identify the field(s) most likely to carry the concept (check field names,
labels, descriptions). Go from the most likely first.
- 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.
- 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:
# 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