AI for Developers
Agent skill (SKILL.md) Open source Apache-2.0 1.6k

Ktx

ktx is an executable context layer for data and analytics agents 🐙 Allow Claude Code, Codex, or other AI agents to query analytical databases accurately and with full context of your company

Install

For this project
$ npx skills add Kaelio/ktx -a claude-code
For every project
$ npx skills add Kaelio/ktx -a claude-code -g

Or copy the skill folder into .claude/skills/ (project) or ~/.claude/skills/ (all projects).

For this project
$ npx skills add Kaelio/ktx -a codex
For every project
$ npx skills add Kaelio/ktx -a codex -g

Or copy the skill folder into .agents/skills/ (project) or ~/.agents/skills/ (all projects).

See the repository README for installation instructions.

When to use

Use it when an agent answers questions from your data warehouse and the numbers don't match your approved metric definitions.

ktx is a context layer for data and analytics agents, built by Kaelio. It teaches an agent how to query your warehouse accurately, from approved metric definitions, joinable columns and business knowledge that it builds and maintains for you. The README's complaint is that general agents re-explore the warehouse on every question, invent their own metric logic and return numbers that don't match approved definitions, while traditional semantic layers need constant manual upkeep.

It ingests wiki content, removes duplicates and flags contradictions for human review. It samples tables, captures metadata and usage, detects joinable columns and builds a semantic layer with a join graph that resolves fan and chasm traps. It serves agents through CLI and MCP tools with full-text and semantic search. It's read-only by design, and you use your own LLM API keys or a local Claude Code or Codex sign-in.

Related skills

All skills