Skip to content

mindbox-cloud/agent-skills / plugins/mindbox/skills/filter-explain

filter-explain

Unverified

Explain existing CDP filter JSON in plain language, including conditions and values that could not be read. Use when asked what a filter or segment selects. Does not change it. Russian triggers: "объясни фильтр", "что делает этот фильтр", "кого выбирает эта выборка", "разбери фильтр", "объясни условия сегмента". English triggers: "explain this filter", "what does this segment select", "who matches this filter", "explain these filter conditions". Don't use when: the filter has to be built or changed — that is filter-build; the question is how many or how much, which is a counting task, not an explanation.

Filter explain

Choose the project and input

Find the connected server's filter_* tools. Explain a missing connection. Keep calls on that server: names and IDs identify records only within the project it serves.

Use the complete original filter JSON. A filtered-list URL cannot be imported, and these tools do not fetch saved filters by name. If only a link or an unseen filter is supplied, ask for its JSON. For a successful build already in this conversation, reuse its confirmed finalSql and selected records instead of converting it again.

Freshly read the connected server's maintained, up-to-date entry point: filter_wiki_read with paths = ["README.md"].

Use its navigation and current tool guidance. Reuse pages within this explanation. Examples below name a tool and the arguments that carry the request; fill in the rest from the schema the server exposes. Use the actual input and returned paths. Tool names may have a server prefix.

1. Convert the original JSON to SQL

Pass the complete JSON unchanged to filter_json_to_sql as its filterJson object — for example this filter, customers aged 30 and over:

{
  "entityType": "User",
  "filterFactory": "and",
  "innerConditions": [{
    "entityType": "User",
    "filterFactory": "age",
    "value": {"mode": "concrete", "value": {"range": {"from": "30", "to": ""}, "unit": "Years"}}
  }]
}

Read the returned sql, selected records and warnings. The tool already attempts to resolve catalogue IDs to names; do not repeat successful lookups. status: read means the JSON was read, not that the platform has accepted the filter. unlabelled means some values remain unnamed; unsupported or UNSUPPORTED_FILTER(...) marks conditions the conversion cannot explain. Keep the original JSON and these gaps visible in your reasoning. Do not reconstruct a simpler filter to make them disappear.

2. Read the meaning and resolve remaining labels

Identify the root, fields, relations, operators and business concepts in the SQL. Search the wiki for each distinct concept whose meaning or limitations you need to establish, combining related terms in a regex and reusing relevant pages already read:

Search with filter_wiki_grep, then read the hits with filter_wiki_read. For an age condition on customers that is pattern = "возраст|\\bage(?:d|s)?\\b" over paths = ["field/user"], then paths = ["field/user.age.md"], both with root = "User".

pattern is a case-insensitive regular expression. Here возраст matches forms such as возраста and возрастной; \\bage(?:d|s)?\\b matches the English words age, aged and ages without matching message. JSON strings need \\b to send the regex boundary \b. For subscription conditions, подпис(?:к|ок|ан)|subscri(?:b|pt) covers forms such as подписка, подписок, подписан, subscribe and subscription. Choose the terms needed for the filter.

paths prioritizes sections; it does not exclude other sections. Follow skip/limit when results continue. Copy returned paths exactly, including underscores, casing and .md. Read field and relation pages for behavior, and recipes or glossary pages for business meaning. If that still leaves a product question, search with business terms and paths: ["help"]; a missing README entry alone does not establish that help is unavailable. Documentation explains a condition; it does not add conditions to the filter.

For an unresolved catalogue value, discover the relevant lookup type and supported search:

List the lookups with filter_wiki_ls at path = "lookup", read the relevant one with filter_wiki_read — paths = ["lookup/segment.md"] for a segment — and then search with filter_search_entities, passing types = ["segment"] and a context that states what you are identifying. Keep root = "User" on the wiki calls.

Browse when practical, or search a known name with query. Continue with the returned nextCursor as cursor, preserving the other arguments. If rejected, restart the same listing once without cursor; disclose a repeated failure as an unresolved lookup. Match the returned ref.ids, type and parent against the original reference before assigning a label. A similar name or ranking score cannot identify an ID, and query is not a general get-by-ID operation. If the identity remains unresolved, say so. An incomplete search or a missing label alone does not prove the record was deleted or that the audience is empty.

3. Explain the actual selection

Use the conversation's language and business terms. Structure the explanation around:

  • Result: what one returned row is and which audience or objects the filter selects.
  • Conditions: grouped inclusions, alternatives and exclusions, with values and periods.
  • Limits and gaps: material behavior from the reference and anything that could not be read.

Preserve AND/OR grouping, negation, inclusive or exclusive boundaries, relative and absolute time windows, counts, and conditions that must hold on the same related object. Distinguish one segment from its whole segmentation, current membership from historical membership, and any matching event from the latest event when those constructs occur. Do not replace these distinctions with a broad label such as "active customers".

State documented caveats that affect this filter and explain why each matters. Identify unnamed values by their role and ID when needed; never present an ID as a catalogue name. Describe an unsupported condition as a gap rather than assuming the remaining SQL is the whole filter. Do not infer an empty or unrestricted audience from an unreadable part.

Keep SQL and internal field names out of the answer unless requested or needed to identify a gap. Explanation needs no validation or compilation and does not change project data. If the user requests a correction, switch to filter-build with the original JSON, the recovered SQL and selected records; preserve untouched conditions.

slack-gif-creatoranthropics/skillsKnowledge and utilities for creating animated GIFs optimized for Slack. Provides constraints, validation tools, and animation concepts. Use when users request animated GIFs for Slack like "make me a GIF of X doing Y for Slack."Stars: 196kUpdated Claude CodeCodexVerifiedInstall
ponytailDietrichGebert/ponytailLazy senior dev mode for any coding task: the smallest change that fully solves it, and a reply a busy human understands in one read.Stars: 193kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailHarvest every shortcut: comment into one debt ledger, so deferrals get tracked instead of forgotten. One-shot report.Stars: 193kUpdated Claude CodeCodexVerifiedInstall
ponytail-debtDietrichGebert/ponytailList every `shortcut:` comment (and older `ponytail:` ones) as a debt ledger. One-shot report, changes nothing. Use for "ponytail debt", "what did ponytail defer", "list the shortcuts", /ponytail-debt.Stars: 193kUpdated Claude CodeCodexVerifiedInstall