skillZs
★ LIVE SKILL TAGS ★
>>> LIVE SKILLS INDEX <<<
* OPEN SOURCE *
NO LOGIN, NO TRACKING
※ REAL INSTALL DATA ※
← back to all skills
lytics/agent-skills49 installs

filterql-builder

Translate structured conditions into valid FilterQL expressions. Use when the user wants to write, build, or validate a FilterQL query or filter expression.

How do I install this agent skill?

npx skills add https://github.com/lytics/agent-skills --skill filterql-builder
view source ↗

Is this agent skill safe to install?

  • Gen Agent Trust Hubpass

    The skill is a safe utility for constructing FilterQL queries from structured input. It does not perform any network operations, access sensitive files, or execute system commands.

  • Socketpass

    No alerts

  • Snykpass

    Risk: LOW · No issues

What does this agent skill do?

FilterQL Builder

Purpose

Translate structured conditions into valid FilterQL syntax. Takes field/operator/value tuples with AND/OR grouping and produces a syntactically correct FilterQL string.

Environment

  • None required (pure construction, no API calls)

Inputs

  • Conditions: list of (field, operator, value) tuples
  • Grouping: AND/OR/NOT composition
  • Table: target table (default: user)
  • Alias: segment slug name

Behavior

Step 1: Map Each Condition to FilterQL Syntax

For each condition, use the type-operator compatibility matrix from ../references/field-types.md:

Field TypeNatural LanguageFilterQL
stringequals "X"field = "X"
stringnot "X"field != "X"
stringcontains "X"field CONTAINS "X"
stringlike patternfield LIKE "pattern*"
stringone of A,B,Cfield IN ("A", "B", "C")
boolis truefield = true
boolis falsefield = false
int/numbermore than Nfield > N
int/numberat least Nfield >= N
int/numberless than Nfield < N
dateafter N days agofield > "now-Nd"
datebefore N days agofield < "now-Nd"
datewithin last N hoursfield > "now-Nh"
[]string (set)has "X"field INTERSECTS ("X")
[]string (set)doesn't have "X"field NOT INTERSECTS ("X")
anyhas any valueEXISTS field
anyis emptyNOT EXISTS field

Step 2: Compose Conditions

Wrap conditions in AND/OR/NOT:

FILTER AND (
  condition1,
  condition2,
  OR (condition3, condition4)
) FROM table ALIAS slug_name

Rules:

  • Single condition: FILTER condition FROM table ALIAS slug
  • Multiple conditions default to AND
  • NOT can wrap any single condition or group
  • Parentheses required for AND/OR groups
  • Comma-separate conditions within groups

Step 3: Generate Slug Name

Convert the alias to a valid slug:

  • Lowercase
  • Replace spaces with underscores
  • Remove special characters
  • Keep it descriptive but concise

Step 4: Output

Return the complete FilterQL string:

FILTER AND (country = "US", visitct > 5) FROM user ALIAS us_active_visitors

Date Math Reference

PeriodSyntaxExample
Hours"now-Nh""now-24h" = 1 day ago
Days"now-Nd""now-30d" = 30 days ago
Weeks"now-Nw""now-4w" = 4 weeks ago
Months"now-NM""now-6M" = 6 months ago
Years"now-Ny""now-1y" = 1 year ago

Common conversions:

  • 1 year = "now-1y" or "now-8760h" or "now-365d"
  • 90 days = "now-90d" or "now-2160h"
  • 1 week = "now-1w" or "now-7d" or "now-168h"

Error Handling

  • If a field type is incompatible with the requested operator, suggest the correct operator
  • If values contain quotes, escape them
  • If the FilterQL is syntactically invalid, identify and fix the issue

Dependencies

  • References: ../references/filterql-grammar.md, ../references/field-types.md

Add the canonical catalog link to the repository README so users can inspect current installs and available audits. The publishing guide covers the complete discovery path.

<a href="https://skillzs.dev/skills/lytics/agent-skills/filterql-builder">View filterql-builder on skillZs</a>