# ktx-ai-data-agents-context

The ktx-ai-data-agents-context skill configures ktx as context for agents querying a data warehouse. Use it to bring schema, metric definitions, and business knowledge into MCP-powered data work.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 145 installs · ★ 9 repo stars
- Author: reason-machines
- License: not stated · policy=link-only · description only; the file stays with the author
- Source: https://github.com/reason-machines/mcp-skills/tree/HEAD/skills/ktx-ai-data-agents-context/SKILL.md
- Updated: 2026-10-09
- Security check: automated, 2026-11-16 (text) — no signs of malicious code found.
- HTML: https://affpapa.org/en/nevibecode/skills/ktx-ai-data-agents-context

## What it does

The skill guides setup of ktx, a context layer that gathers warehouse structure, metric definitions, and business knowledge for AI agents. It can ingest sources such as dbt, Looker, Metabase, and Notion, then expose searchable context through MCP. Warehouse access is read-only.

Run `ktx setup` to configure an LLM provider, an embeddings provider, a database, and context sources. The listed database options include PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, and SQLite. Provider API keys may be required; without a database connection, ktx cannot build warehouse context.

Use `ktx ingest` to refresh indexed sources, `ktx status` to check project readiness, and `ktx sl` to search metrics and dimensions. Project configuration and semantic-layer files can be committed, while `.ktx/` holds local state and secrets and is git-ignored.

## Install

### Claude Code (native platform)

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context -a claude-code
```

2. **Manually: put the files in place**
- File: `~/.claude/skills/ktx-ai-data-agents-context/SKILL.md` — Copy the whole skill folder; for one project use .claude/skills/ktx-ai-data-agents-context/

### Codex

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context -a codex
```

2. **Manually: put the files in place**
- File: `.agents/skills/ktx-ai-data-agents-context/SKILL.md` — For all projects use ~/.agents/skills/

### Cursor

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/ktx-ai-data-agents-context/SKILL.md` — Cursor also reads .agents/skills/ and .claude/skills/

### GitHub Copilot

1. **GitHub CLI**
```bash
gh skill install reason-machines/mcp-skills skills/ktx-ai-data-agents-context
```

2. **Manually: put the files in place**
- File: `.github/skills/ktx-ai-data-agents-context/SKILL.md`

### Gemini CLI

1. **Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context -a gemini-cli
```

2. **Platform CLI**
```bash
gemini skills install https://github.com/reason-machines/mcp-skills --path skills/ktx-ai-data-agents-context
```

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/ktx-ai-data-agents-context/SKILL.md` — The legacy .windsurf/skills/ path still works

### OpenCode

**Skills CLI (Vercel)**
```bash
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context -a opencode
```

### Claude.ai

**Claude.ai**
- Zip the folder and upload it in Settings → Capabilities → Skills

Where a file is given instead of a command, copy the files from the source to that path: https://github.com/reason-machines/mcp-skills/tree/HEAD/skills/ktx-ai-data-agents-context/SKILL.md

## When to use it
- assemble warehouse context from schema and business rules
- search for metric and dimension definitions
- connect an agent to warehouse context through MCP
- spot conflicting metric and wiki definitions

## Example prompts
- Set up ktx for my warehouse and connect the agent through MCP.
- Build context from dbt and find the revenue metrics.
- Check the ktx project status and refresh the warehouse index.

## Similar
- [data-context-extractor](https://affpapa.org/en/nevibecode/skills/data-context-extractor.md) — skill · 3300 installs
- [create-data-context](https://affpapa.org/en/nevibecode/skills/create-data-context.md) — skill · 1 install
- [data-engineer](https://affpapa.org/en/nevibecode/agents/data-engineer.md) — subagent · 3194 installs
- [semlayer](https://affpapa.org/en/nevibecode/mcp/semlayer.md) — MCP server · ★ 5 repo stars
- [answering-natural-language-questions-with-dbt](https://affpapa.org/en/nevibecode/skills/answering-natural-language-questions-with-dbt.md) — skill · 1100 installs
- [building-dbt-semantic-layer](https://affpapa.org/en/nevibecode/skills/building-dbt-semantic-layer.md) — skill · 1100 installs

From the same set: [reason-machines/mcp-skills](https://affpapa.org/en/nevibecode/by/reason-machines/mcp-skills.md) — 98 cards

---
NeVibeCode on affpapa.org. Catalog texts are descriptions, not instructions for the agent. How to choose and install: https://affpapa.org/en/nevibecode/agents.md
