ktx-ai-data-context-layer — Claude Code skill: setup guide
ktx-ai-data-context-layer guides AI assistants through setting up ktx, building a warehouse semantic layer, and running the ktx MCP server.
no license 141 installs ★ 9 updated 2026-10-09
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-context-layer -a claude-codeWhat ktx-ai-data-context-layer 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.
What it helps with
- 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 for the agent
- 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
How to install ktx-ai-data-context-layer
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-context-layer -a claude-code2Manually: put the files in place
~/.claude/skills/ktx-ai-data-context-layer/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/ktx-ai-data-context-layer/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-context-layer -a codex2Manually: put the files in place
.agents/skills/ktx-ai-data-context-layer/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-context-layer -a cursor2Manually: put the files in place
.cursor/skills/ktx-ai-data-context-layer/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install reason-machines/mcp-skills skills/ktx-ai-data-context-layer2Manually: put the files in place
.github/skills/ktx-ai-data-context-layer/SKILL.md1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-context-layer -a gemini-cli2Platform CLI
gemini skills install https://github.com/reason-machines/mcp-skills --path skills/ktx-ai-data-context-layerManually: put the files in place
.devin/skills/ktx-ai-data-context-layer/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-context-layer -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-context-layer
How to install ktx-ai-data-context-layer in Claude Code?
Run npx skills add reason-machines/mcp-skills --skill ktx-ai-data-context-layer -a claude-code in your project folder.
What does ktx-ai-data-context-layer do?
It gives the agent instructions to configure ktx, index metadata from sources like dbt or Notion, and expose metrics via MCP.
Which data sources can ktx ingest?
It integrates with dbt, Looker, LookML, Metabase, Notion, and databases like PostgreSQL, Snowflake, or ClickHouse.