# ktx-ai-data-context-layer

ktx-ai-data-context-layer guides AI assistants through setting up ktx, building a warehouse semantic layer, and running the ktx MCP server.

- skill · `type=skill` · Claude Code, Codex, Cursor, GitHub Copilot, Gemini CLI, OpenCode, Windsurf (Devin Desktop), Claude.ai · 141 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-context-layer/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-context-layer

## What it does

This skill teaches your coding agent how to use the ktx context layer. The framework indexes data warehouses, imports metadata from dbt or Looker, handles table join traps, and exposes context via terminal commands or an MCP interface.

It connects to PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, and SQLite. Project settings live in `ktx.yaml`, while shared business definitions sit in the `wiki/` and `semantic-layer/` directories.

You need Node.js to install `@kaelio/ktx` globally or locally, alongside valid API credentials for your chosen LLM and embedding providers.

## Install

### Claude Code (native platform)

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

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

### Codex

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

2. **Manually: put the files in place**
- File: `.agents/skills/ktx-ai-data-context-layer/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-context-layer -a cursor
```

2. **Manually: put the files in place**
- File: `.cursor/skills/ktx-ai-data-context-layer/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-context-layer
```

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

### Gemini CLI

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

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

### Windsurf (Devin Desktop)

**Manually: put the files in place**
- File: `.devin/skills/ktx-ai-data-context-layer/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-context-layer -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-context-layer/SKILL.md

## When to use it
- connect warehouse schemas to coding assistants using ktx
- configure dbt manifest ingestion for data agents
- launch and verify the ktx MCP server daemon
- query semantic layer metrics via terminal commands

## Example prompts
- Set up ktx for my warehouse database connection
- Configure ktx to ingest my dbt manifest and catalog
- Troubleshoot ktx MCP server connection for my project

## Similar
- [building-dbt-semantic-layer](https://affpapa.org/en/nevibecode/skills/building-dbt-semantic-layer.md) — skill · 1100 installs
- [answering-natural-language-questions-with-dbt](https://affpapa.org/en/nevibecode/skills/answering-natural-language-questions-with-dbt.md) — skill · 1100 installs
- [create-data-context](https://affpapa.org/en/nevibecode/skills/create-data-context.md) — skill · 1 install
- [data-context-extractor](https://affpapa.org/en/nevibecode/skills/data-context-extractor.md) — skill · 3300 installs
- [dbt-data-transformation](https://affpapa.org/en/nevibecode/skills/dbt-data-transformation.md) — skill · 443 installs
- [setting-up-data-catalog](https://affpapa.org/en/nevibecode/skills/setting-up-data-catalog.md) — skill · 182 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
