Skip to main content
skill CX Codex

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

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add reason-machines/mcp-skills --skill ktx-ai-data-agents-context-layer -a claude-code
Open on GitHub

What 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-code

2Manually: put the files in place

~/.claude/skills/ktx-ai-data-agents-context-layer/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/ktx-ai-data-agents-context-layer/

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.

Similar skills

All skills for Agent setup: memory, context, orchestration →

From the same set98

The whole set →
mcp-documentation-server The mcp-documentation-server skill indexes documents in a local database and searches by text or meaning. Use it to find relevant passages across files and retrieve their surrounding context. CX Codex +1 166installs monarch-money-mcp-server Runs a Monarch Money MCP server, so an agent can read accounts, transactions, budgets and categories and add new entries. CX Codex +1 161installs mcp-security-hub mcp-security-hub connects Dockerized security assessment utilities and scanners to your coding assistant via MCP. CX Codex +1 160installs ktx-data-agent-context-layer The ktx-data-agent-context-layer skill guides ktx setup so an AI agent can search warehouse context, metric definitions, and wiki knowledge, then use that context in data queries. CX Codex +1 158installs 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. CX Codex +1 156installs ktx-ai-data-agents-context The ktx-ai-data-agents-context skill configures ktx as context for agents querying a data warehouse. Use it to bring schema, metric definitions, and business knowledge into MCP-powered data work. CX Codex +1 145installs 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. CX Codex +1 141installs ida-mcp-headless-reverse-engineering ida-mcp-headless-reverse-engineering connects IDA Pro headless inspection capabilities to coding agents for binary analysis without a GUI. CX Codex +1 134installs

Project sponsors

Companies that keep this analytics open