anfra-lookup-values

Installation
SKILL.md

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.
  2. 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.
  3. 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.
Installs
48
GitHub Stars
1
First Seen
Nov 2, 2026