Skip to main content
skill CX Codex

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

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

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

2Manually: put the files in place

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

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

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.

Similar skills

All skills for Data and databases →

From the same set98

The whole set →
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-context-layer 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. CX Codex +1 157installs 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 ktx-context-layer-data-agents The ktx-context-layer-data-agents skill sets up ktx as a context layer for data agents, covering semantic metrics, a searchable wiki, and MCP access to warehouse context. CX Codex +1 133installs

Project sponsors

Companies that keep this analytics open