Tooluck logoTooluck
SKILL.md

ktx-analytics

Agent skill fromKaelio/ktx

Use when answering a question that needs data from a ktx-connected database - investigating, analyzing, "how many", "show me", "what's the breakdown of", finding records by value, exploring tables, comparing periods, explaining metrics, or any data-analysis request. Triggers even when the user does not say "analytics"; if the answer requires querying a configured ktx connection, this skill applies.

How to install ktx-analytics

install ktx-analytics
# install the ktx pack with the skills CLI
npx skills add Kaelio/ktx

# or add only this skill to Claude Code: copy the folder

packages/cli/src/skills/analytics/

# into

~/.claude/skills/analytics/ (all projects)

.claude/skills/analytics/ (one project)

packages/cli/src/skills/analytics/SKILL.md

Apache-2.0Full file
1# ktx Analytics Workflow
2
3You have access to ktx MCP tools for data discovery, semantic-layer analysis, raw read-only SQL, wiki context, and memory ingest. Follow this workflow.
4
5<workflow>
61. **Discover** - call `discover_data` first to see what exists across wiki pages, semantic-layer sources, metrics, dimensions, raw tables, and columns. Returns refs only.
72. **Inspect top hits in parallel** - for each promising ref:
8 - `kind: 'wiki'` -> `wiki_read`
9 - `kind: 'sl_source'`, `kind: 'sl_measure'`, or `kind: 'sl_dimension'` -> `sl_read_source`
10 - `kind: 'table'` or `kind: 'column'` -> `entity_details`
11 - For tables you intend to query, sample a few rows (`entity_details` plus a small `sql_execution` sample) to confirm date encoding, null prevalence in join/filter keys, and the real enum values — see the `<sql_craft>` Schema-discovery rules.
123. **Resolve business values** - if the user named a value such as "Acme Corp", "enterprise", or "status=shipped", call `dictionary_search` to find which column holds it.
13…

Excerpt shown under the repository's Apache-2.0 license.

More skills in ktx

Keep exploring

Similar skill repositories

thedotmack /

claude-mem
116k

Persistent Context Across Sessions for Every Agent – Captures everything your agent does during sessions, compresses it with AI, and injects relevant context back into future sessions. Works with Claude Code, OpenClaw, Codex, Gemini, Hermes, Copilot, OpenCode + More

CCCXGHGM+135 skills

pbakaus /

impeccable
108k

The design vocabulary for your coding agent. Steer with polish and bolder, review with critique and audit, catch AI slop before it ships.

2 skills

Newsletter

Join the Community

Subscribe to our newsletter for the latest news and updates