# ktx

> Query your warehouse accurately from your agent: ktx is an open-source context layer with approved metrics, joins and business knowledge.

ktx is Kaelio's open-source context layer for data agents. It teaches your agent to query your warehouse accurately from approved metric definitions, joinable columns and the business knowledge it builds and maintains for you. This pack bundles the ktx Agent Skills for installing it, asking questions of your data, and reading its semantic layer.

The three skills in the pack
- ktx: installs and configures ktx in a project, connects your data sources and embeddings, installs the agent integration, ingests your schema and verifies the setup
- ktx-analytics: answers a question that needs data from a ktx-connected database, from "how many" and "show me" to breakdowns, record lookups, period comparisons and metric explanations
- sl: reads and queries ktx's semantic layer, a YAML catalog of sources, measures, joins and segments, so predefined metrics like ARR, churn, retention and MAU come back consistently

How it works
- ktx ingests your data stack and docs into a version-controlled knowledge base, then resolves grains, validates joins and compiles read-only SQL against the warehouse.
- Install the skills with npx skills add Kaelio/ktx. ktx also exposes a CLI and an MCP server.
- Run ktx with your own LLM API keys or a local agent sign-in, such as Claude Code or Codex; ktx adds no usage billing of its own.

Good to know
- It documents connectors for Snowflake, dbt, LookML and Notion, with cloud-hosted and self-managed deployments.
- Queries it compiles are read-only.
- Open source under the Apache 2.0 license.

- Type: Skill
- Made by: Kaelio
- Category: Data & analytics
- Formats: Skills
- Version: latest
- Website: https://www.kaelio.com
- Source: https://github.com/Kaelio/ktx
- Page: https://pluginboard.ai/skills/ktx-skills

## Works with

- ChatGPT
- Claude
- Gemini
- GitHub Copilot
- Cursor
- Claude Code
- Codex
- Antigravity
- Gemini CLI
- Replit
- OpenClaw
- OpenCode
- Hermes Agent

## Install

### ChatGPT

In ChatGPT: Download the ktx folder and zip it, then Plugins → Skills → Create → Upload from your computer. Business and Enterprise plans.

View the skills on GitHub: https://github.com/Kaelio/ktx

### Claude

In Claude (web or desktop): Download each skill’s folder and zip it, then upload them one at a time in Customize → Skills.

View the skills on GitHub: https://github.com/Kaelio/ktx

### Gemini

In Gemini: Download the ktx folder, then at gemini.google.com click Customize → Skills → Create → Upload and pick the folder (or a .zip of it).

View the skills on GitHub: https://github.com/Kaelio/ktx

### GitHub Copilot

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.copilot/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.copilot/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.copilot/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### Cursor

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.cursor/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.cursor/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.cursor/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### Claude Code

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.claude/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.claude/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.claude/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### Codex

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.agents/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.agents/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.agents/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### Antigravity

In Antigravity: Copy the ktx folder into ~/.gemini/config/skills (Antigravity app and IDE) or ~/.gemini/antigravity-cli/skills (Antigravity CLI).

View the skills on GitHub: https://github.com/Kaelio/ktx

### Gemini CLI

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.gemini/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.gemini/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.gemini/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### Replit

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx .agents/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics .agents/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl .agents/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### OpenClaw

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.openclaw/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.openclaw/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.openclaw/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### OpenCode

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.config/opencode/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.config/opencode/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.config/opencode/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

### Hermes Agent

Copy all 3 skills, in your terminal:

```shell
npx -y degit Kaelio/ktx/skills/ktx ~/.hermes/skills/ktx
npx -y degit Kaelio/ktx/packages/cli/src/skills/analytics ~/.hermes/skills/analytics
npx -y degit Kaelio/ktx/packages/cli/src/skills/sl ~/.hermes/skills/sl
```

View the skills on GitHub: https://github.com/Kaelio/ktx

---
From Pluginboard (https://pluginboard.ai).
