# ktx-ai-data-agents

ktx-ai-data-agents guides AI coding agents to configure ktx, build semantic layers from warehouse metadata, and query metrics accurately.

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

## What it does

This skill instructs coding assistants on integrating ktx into analytics workflows. Instead of guessing raw table schemas, agents interact with canonical SQL metrics and curated documentation through semantic search and MCP tools. The underlying utility scans data warehouse catalogs, detects joinable relationships, and resolves fan traps.

Setup creates a local `ktx.yaml` configuration accompanied by `semantic-layer/` and `wiki/` folders. Supported engines include PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, and SQLite. Metadata can be extracted directly from dbt configurations, Looker, Metabase, and Notion workspaces.

Agent integrations require an active local bridge via `ktx mcp start` along with credentials for embedding and LLM providers.

## Install

### Claude Code (native platform)

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

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

### Codex

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

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

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

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

### Gemini CLI

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

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

### Windsurf (Devin Desktop)

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

## When to use it
- configure a warehouse semantic layer for automated agent queries
- ingest metadata from dbt projects and database tables
- retrieve verified metric formulas using `ktx sl`
- test warehouse connections with `ktx validate`

## Example prompts
- Set up ktx for data agent queries against PostgreSQL
- Build ktx context from my dbt repository and warehouse schemas
- Search the ktx semantic layer for monthly active user metrics

## Similar
- [altimate-data-engineering-skills](https://affpapa.org/en/nevibecode/skills/altimate-data-engineering-skills.md) — skill · 2100 installs
- [data-warehouse-experimentation](https://affpapa.org/en/nevibecode/skills/data-warehouse-experimentation.md) — skill · 283 installs
- [dbt-sf-to-bq-translator](https://affpapa.org/en/nevibecode/skills/dbt-sf-to-bq-translator.md) — skill · 2300 installs
- [snowflake-dbt-airbnb-analytics](https://affpapa.org/en/nevibecode/skills/snowflake-dbt-airbnb-analytics.md) — skill · 1700 installs
- [migrating-dbt-project-across-platforms](https://affpapa.org/en/nevibecode/skills/migrating-dbt-project-across-platforms.md) — skill · 531 installs
- [dex](https://affpapa.org/en/nevibecode/plugins/dex.md) — plugin · ★ 1596 repo stars

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
