ktx-ai-data-agents-context-layer — Claude Code skill: setup
The ktx-ai-data-agents-context-layer skill guides setup of ktx as a context layer for warehouse queries. It connects approved metrics, data structure, and business knowledge for AI agents.
no license 157 installs ★ 9 updated 2026-10-09
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context-layer -a claude-codeWhat ktx-ai-data-agents-context-layer does
The skill walks through configuring ktx for analytics agents: connecting a warehouse, collecting metadata and business context, building a semantic layer, and starting an MCP server. Supported databases include PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, and SQLite. Listed integrations include dbt, Looker, Metabase, and Notion.
Install ktx globally or in a project with npm, then run ktx setup. The interactive setup configures LLM and embedding providers, database connections, and context sources. You’ll need API keys for the providers you choose and database connection credentials; without valid credentials, ktx cannot connect to the warehouse.
Use ktx ingest to refresh context, ktx validate to check configuration, and the search commands to find metrics or wiki content. The .ktx/ directory holds secrets and local state, so keep it out of Git. The project configuration, semantic layer, and wiki can be committed.
What it helps with
- connect an agent to warehouse metrics
- build a semantic layer from tables and measures
- load wiki and dbt knowledge into agent context
- validate ktx configuration and refresh data context
Example prompts for the agent
- Set up ktx so the agent can query our warehouse, then connect its MCP server.
- Build a semantic layer from the database metadata and configured dbt source.
- Validate the ktx setup and refresh its context with
ktx ingest.
How to install ktx-ai-data-agents-context-layer
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context-layer -a claude-code2Manually: put the files in place
~/.claude/skills/ktx-ai-data-agents-context-layer/SKILL.mdCopy the whole skill folder; for one project use .claude/skills/ktx-ai-data-agents-context-layer/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context-layer -a codex2Manually: put the files in place
.agents/skills/ktx-ai-data-agents-context-layer/SKILL.mdFor all projects use ~/.agents/skills/
1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context-layer -a cursor2Manually: put the files in place
.cursor/skills/ktx-ai-data-agents-context-layer/SKILL.mdCursor also reads .agents/skills/ and .claude/skills/
1GitHub CLI
gh skill install reason-machines/mcp-skills skills/ktx-ai-data-agents-context-layer2Manually: put the files in place
.github/skills/ktx-ai-data-agents-context-layer/SKILL.md1Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context-layer -a gemini-cli2Platform CLI
gemini skills install https://github.com/reason-machines/mcp-skills --path skills/ktx-ai-data-agents-context-layerManually: put the files in place
.devin/skills/ktx-ai-data-agents-context-layer/SKILL.mdThe legacy .windsurf/skills/ path still works
Skills CLI (Vercel)
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-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-agents-context-layer
How do I install ktx-ai-data-agents-context-layer in Claude Code?
Run npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context-layer -a claude-code. The skill file is placed at ~/.claude/skills/ktx-ai-data-agents-context-layer/SKILL.md.
What does ktx-ai-data-agents-context-layer do?
It guides setup of ktx as an analytics context layer: ingest warehouse metadata and business knowledge, define semantic relationships, and connect an agent through MCP.
Which databases does ktx support?
The listed databases are PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, and SQLite.