LIFEHUBBER
Theme

AI Resources

ktx

ktx is a local context layer for data agents, built to help AI coding and agent tools query SQL warehouses with reusable metric definitions, warehouse context, wiki knowledge, and MCP or CLI access.

The repository frames ktx around approved metric definitions, joinable columns, semantic-layer entities, business wiki content, data-stack scanning, local project files, agent setup, and a local MCP daemon for agent clients. Use this as a first read, not a recommendation. Open the original project before trusting details like terms, limits, privacy, cost, setup, or safety.

What it is

Context infrastructure for data agents

ktx is positioned as a layer that helps agents find and reuse warehouse context instead of starting from scratch on every data question, with local project files for semantic sources, wiki notes, and generated context.

Why it stands out

Warehouse context plus agent-facing tools

The README highlights SQL warehouse support, dbt and semantic-layer ingestion, wiki or Notion-style business context, contradiction flags, CLI commands, and MCP tools for agent execution.

Availability

GitHub repo, npm package, and docs

The public materials include a GitHub repository, npm install path, quickstart commands, CLI reference, agent setup docs, MCP startup notes, project-layout guidance, and development instructions.

Why it matters

What makes it useful

ktx is about giving data agents approved warehouse context before they answer. Metrics, joins, semantic-layer entities, wiki knowledge, local project files, CLI search, and MCP tools are treated as reusable context rather than one-off prompt material.

Notable points

What stands out

ktx scans warehouse metadata, stores approved metric definitions and joinable-column context, ingests wiki knowledge, and exposes the result through CLI search and an MCP server while keeping its local `.ktx/` data out of git.

Before using

What to review

Which warehouse, semantic-layer, wiki, and business-context sources the project will be allowed to read.

Which LLM or embedding provider is configured, since the README says provider-bound data depends on the user's chosen setup.

Telemetry, project files, local secrets, and company data rules before connecting internal sources.

Whether the team already has approved metric definitions or data-governance rules that ktx should follow rather than replace.

Reader fit

Who may find it relevant

Data teams exploring how AI agents can query warehouses without inventing metric logic each time.

Builders comparing MCP tools, CLI context search, semantic-layer ingestion, and wiki-backed agent context.

Teams using agents such as Codex, Claude Code, Cursor, or OpenCode around analytics projects.

Less relevant for readers who do not use a SQL warehouse or only need a one-off notebook query.

Editorial note

Why LifeHubber lists it

ktx brings approved metric definitions, joinable-column context, company knowledge, CLI search, and MCP access into one local layer. Data teams can use that shared context instead of rebuilding warehouse logic for every question.

Source links

Source materials

Reader note

Before relying on this entry

LifeHubber lists entries to help readers inspect AI projects, not to endorse them or prove they are safe, suitable, accurate, maintained, or right for a specific use. We do not verify every entry in depth. Before relying on anything listed, review the original materials, terms, privacy practices, limits, and risks that matter for your situation.

What to explore next

Keep data-agent context current and traceable.

ktx gives agents warehouse definitions and business context before they answer. These next steps cover changing source data and the wider ingestion, retrieval, and citation path around AI context.

Advertisements

Advertisements

See what’s moving