ktx

ktx is an executable context layer for data and analytics agents πŸ™ Allow Claude Code, Codex, or other AI agents to query analytical databases accurately and wi

What is ktx?

ktx is an executable context layer for data and analytics agents πŸ™ Allow Claude Code, Codex, or other AI agents to query analytical databases accurately and with full context of your company

Overview of ktx

What it is

ktx is an executable context layer for data and analytics agents. It teaches agents how to query a data warehouse accurately by providing approved metric definitions, joinable columns, and business knowledge. It runs locally and is designed to be read-only, never writing to the database.

Key features

  • Learns from company knowledge by ingesting wiki content, organizing it, removing duplicates, and flagging contradictions for human review
  • Maps the data stack by sampling tables, capturing metadata and usage patterns, detecting joinable columns, and annotating sources
  • Builds a semantic layer that combines raw tables and high-level metrics through a join graph that automatically resolves chasm and fan traps
  • Serves agents at execution by exposing CLI and MCP tools with combined full-text and semantic search across wiki and semantic-layer entities
  • Integrates with PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, SQLite, DuckDB, Amazon Athena, and MongoDB, as well as dbt, MetricFlow, LookML, Looker, Metabase, Sigma, Notion, and Google Drive

Use cases

  • Allowing agents like Claude Code, Codex, Cursor, or OpenCode to query a warehouse with approved metric definitions
  • Consolidating business knowledge scattered across dbt, Looker, Metabase, Notion, and team wikis
  • Enabling agents to reuse canonical SQL instead of inventing it on every prompt

Getting started

npm install -g @kaelio/ktxktx setupktx status

License and pricing

ktx is licensed under the Apache License, Version 2.0. It is open source and has no extra usage billing from ktx itself; users provide their own LLM API keys or agent subscriptions.

Based on the project's public README and repository metadata.

Add this badge to your README

Featured on YunoDB Badge styles & help

Maintain this project? Show that it is featured on YunoDB.

Markdown[![Featured on YunoDB](https://yunodb.com/badge/kaelioktx.svg)](https://yunodb.com/tools/kaelioktx?utm_source=github&utm_medium=badge)
HTML<a href="https://yunodb.com/tools/kaelioktx?utm_source=github&utm_medium=badge"><img src="https://yunodb.com/badge/kaelioktx.svg" alt="Featured on YunoDB" height="20"></a>