Show HN: Ktx – Open-source executable context layer for data agents Kaelio released Ktx, an open-source context layer that automatically builds and maintains warehouse knowledge for AI data agents. The tool ingests company wikis, maps data stacks, and creates a semantic layer with approved metric definitions, enabling agents like Claude Code and Cursor to query databases accurately without re-exploring schemas or inventing metric logic on each request. Ktx supports PostgreSQL, Snowflake, BigQuery, and other warehouses, and integrates with dbt, Looker, and Notion to resolve join conflicts and flag contradictions across sources. Quickstart https://docs.kaelio.com/ktx/docs/getting-started/quickstart · · https://docs.kaelio.com/ktx/docs/cli-reference/ktx CLI Reference · https://docs.kaelio.com/ktx/docs/ai-resources/agent-quickstart Agent Setup Slack ktx is a self-improving context layer that teaches agents how to query your warehouse accurately - from approved metric definitions, joinable columns, and business knowledge it builds and maintains for you. Note Run ktx with your own LLM API keys or a Claude Pro/Max subscription. No extra usage billing from ktx . General-purpose agents struggle on data tasks. They re-explore your warehouse on every question, invent their own metric logic, and return numbers that don't match approved definitions. Traditional semantic layers don't fix this. They demand constant manual upkeep and don't absorb the rest of your company's knowledge. ktx does both, automatically: Learns from company knowledge. Ingests wiki content, organizes it, removes duplicates, and flags contradictions for human review. Maps the data stack. Samples tables, captures metadata and usage patterns, detects joinable columns, and annotates sources so agents write better queries. Builds a semantic layer. Combines raw tables and high-level metrics through a join graph that automatically resolves chasm and fan traps, so agents fetch metrics declaratively instead of rewriting canonical SQL each time. Serves agents at execution. Exposes CLI and MCP tools with combined full-text and semantic search across wiki and semantic-layer entities. | General-purpose agent | Traditional semantic layer | ktx | | |---|---|---|---| | Builds warehouse context automatically | — | — | ✓ | | Detects joinable columns + resolves fan/chasm traps | — | Manual | ✓ | | Approved, reusable metric definitions | — | ✓ | ✓ | | Absorbs wiki / Notion / team knowledge | — | — | ✓ | | Flags contradictions across sources | — | — | ✓ | | Ships CLI + MCP for agent execution | Partial | — | ✓ | | Read-only by design | n/a | n/a | ✓ | Use ktx if you: - Want agents like Claude Code, Codex, Cursor, or OpenCode to query your warehouse with approved metric definitions - Have business knowledge scattered across dbt, Looker, Metabase, Notion, and team wikis - Need agents to reuse canonical SQL instead of inventing it on every prompt Skip ktx if you: - You don't have a SQL warehouse - ktx sits on top of one - You only need one ad-hoc query - psql or a notebook will do Works with PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, and SQLite. Integrates with dbt, MetricFlow, LookML, Looker, Metabase, and Notion. npm install -g @kaelio/ktx ktx setup ktx status ktx setup creates or resumes a local ktx project, configures providers and connections, builds context, and installs agent integration. Example ktx status after setup: ktx project: /home/user/analytics Project ready: yes LLM ready: yes claude-sonnet-4-6 Embeddings ready: yes text-embedding-3-small Databases configured: yes warehouse Context sources configured: yes dbt main ktx context built: yes Agent integration ready: yes codex:project Tip Already using an agent? Ask Claude Code, Codex, Cursor, or OpenCode from your project directory: Run npx skills add Kaelio/ktx --skill ktx and use the ktx skill to install and configure ktx in this project. Important If ktx status prints ktx mcp start --project-dir ... , run it before opening your agent client. | Command | Purpose | |---|---| ktx setup | Create, resume, or update a ktx project | ktx status | Check project readiness | ktx ingest | Build context for every configured connection | ktx sl "revenue" | Search semantic sources | ktx wiki "refund policy" | Search local wiki pages | ktx mcp start | Start the MCP server for agent clients | See the CLI Reference https://docs.kaelio.com/ktx/docs/cli-reference/ktx for every command, flag, and option. my-project/ ├── ktx.yaml Project configuration ├── semantic-layer/