ktx-ai-data-agents — Claude Code skill: setup and features
ktx-ai-data-agents guides AI coding agents to configure ktx, build semantic layers from warehouse metadata, and query metrics accurately.
no license 156 installs ★ 9 updated 2026-10-09
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents -a claude-codeWhat ktx-ai-data-agents 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.
What it helps with
- 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 for the agent
- 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
How to install ktx-ai-data-agents
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents -a claude-code2Manually: put the files in place
~/.claude/skills/ktx-ai-data-agents/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/ktx-ai-data-agents/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents -a codex2Manually: put the files in place
.agents/skills/ktx-ai-data-agents/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents -a cursor2Manually: put the files in place
.cursor/skills/ktx-ai-data-agents/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install reason-machines/mcp-skills skills/ktx-ai-data-agents2Manually: put the files in place
.github/skills/ktx-ai-data-agents/SKILL.md1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents -a gemini-cli2Platform CLI
gemini skills install https://github.com/reason-machines/mcp-skills --path skills/ktx-ai-data-agentsManually: put the files in place
.devin/skills/ktx-ai-data-agents/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents -a opencodeClaude.ai
Zip the folder and upload it in Settings → Capabilities → Skills
Step by step, with commands for each platform: How to install skills in Claude Code: five ways
Questions about ktx-ai-data-agents
How to install ktx-ai-data-agents in Claude Code?
Run npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents -a claude-code. The definition will be placed in ~/.claude/skills/ktx-ai-data-agents/SKILL.md.
What does ktx-ai-data-agents do?
It guides coding agents through setting up @kaelio/ktx, indexing warehouse metadata, and providing canonical metric context via MCP.
Which data engines are supported by ktx?
ktx works with PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, and SQLite.