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
npx skills add Kaelio/ktx -a claude-code
npx skills add Kaelio/ktx -a claude-code -g
Or copy the skill folder into .claude/skills/ (project) or ~/.claude/skills/ (all projects).
npx skills add Kaelio/ktx -a codex
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
-
rea
Lets your agent reverse engineer an app from the outside, down to native binaries, and then build its own version.
-
superpowers
A set of development habits for your agent: test first, debug systematically, and plan before you code.
-
skills
The skills Matt Pocock uses in his own day-to-day engineering work.
-
ECC
A ready-made setup for coding agents that adds skills, persistent memory and security checks.