Query pre-defined business metrics through a YAML semantic layer catalog.
npx skills add https://github.com/Kaelio/ktx --skill sl
Please help me install this Agent Skill. Skill: sl Source: https://github.com/Kaelio/ktx/tree/main/packages/cli/src/skills/sl Command: npx skills add https://github.com/Kaelio/ktx --skill sl
Data agents often write incorrect SQL because they lack knowledge of approved metric definitions, joinable columns, and business logic. This Skill provides a structured semantic layer catalog of sources, measures, joins, and segments so agents can query metrics like ARR, churn, retention, and LTV accurately without hand-writing fragile SQL.
subscriptions.arr, applies the paid_non_refunded segment, groups by month, and produces correct SQL without manual join or aggregation logic.Use the sl skill to query monthly ARR from the subscriptions source filtered to paid non-refunded orders.
High-intent search queries and answers about installing and using this skill.
Pass a structured JSON query with measures, dimensions, filters, and segments to sl_query. The engine resolves join paths automatically, classifies filters as WHERE or HAVING, and generates correct SQL without you specifying a base table.
Prefer sl_query when a pre-defined measure exists, when the question spans multiple sources requiring joins, or when asking for standard metrics like revenue or churn. Use raw sql_execution only for multi-step CTEs or one-off explorations.
Overlay sources enrich manifest-backed tables with measures and computed columns, standalone table sources own their schema with source_type table, and standalone SQL sources derive schema from a frozen SQL query with source_type sql.
No. This skill only reads and queries the semantic layer. Capturing new patterns is handled by the separate sl_capture skill, which runs in the memory-agent in capture mode.
The error occurs when no join path exists between the referenced sources in the catalog. Use discover_data or sl_discover to check which sources are connected through declared joins before combining them in one query.
AradotsoBuild a semantic context layer for AI agents querying data warehouses.
lucaslessachavesDefine governed business metrics in YAML with dimensions and measures.
AltimateAIClassify PII columns and audit query exposure with risk reports.
jwest33Create, edit, and convert SQL into dbt models with config blocks and refs.