All 64 Dependencies

Every package ktx depends on, ranked by repo health score.

ktx is an executable context layer for data and analytics agents. Instead of letting a general-purpose AI agent re-explore a warehouse schema on every question, invent its own metric logic, and return numbers that don't match approved definitions, ktx builds and continuously maintains that context up front: it samples tables, detects joinable columns, ingests wiki and documentation knowledge, and compiles all of it into a searchable semantic layer that agents can query declaratively.

The project is a pnpm + uv monorepo split into a TypeScript CLI (`packages/cli`) and two Python packages: `ktx-sl`, a semantic-layer engine that loads YAML source definitions, builds a join graph, and compiles semantic queries into dialect-specific SQL, and `ktx-daemon`, a portable compute service the CLI talks to. The standout technical piece is the join graph's explicit detection and resolution of fan-out and chasm traps — the classic semantic-layer bug where a one-to-many join silently double-counts a metric — backed by real regression tests, not just a README claim.

On the serving side, ktx ships both a CLI (`ktx setup`, `ktx ingest`, `ktx sl`, `ktx wiki`) and an MCP server (`ktx mcp start`) exposing tools like `entity_details`, `discover_data`, and `wiki_search` that Claude Code, Codex, Cursor, or OpenCode can call directly. It supports PostgreSQL, Snowflake, BigQuery, ClickHouse, MySQL, SQL Server, SQLite, DuckDB, Amazon Athena, and MongoDB as data sources, plus integrations with dbt, MetricFlow, LookML, Looker, Metabase, Sigma, Notion, and Google Drive for absorbing existing business knowledge.

ktx is Apache-2.0 licensed, runs entirely locally against a self-supplied LLM key or an existing Claude Code/Codex session (no hosted service and no extra usage billing), and enforces read-only warehouse connections by design. The project is built by Kaelio (Y Combinator P25) and is under very active early-stage development, with 21 releases and a fast-growing star count in its first months on GitHub.

42 lkml >=1.3.7 44 fflate ^0.8.3 53 Commander Extra Typings 14.0.0 outdated 55 html-to-image 1.11.11 outdated 56 minimatch ^10.2.5 56 PyYAML >=6 61 p-limit ^7.3.0 62 Commander.js 14.0.3 outdated 64 simple-git 3.36.0 65 Handlebars.js ^4.7.9 66 Ajv 8.20.0 69 orjson >=3.11.9 69 semver ^7.8.1 74 pino-pretty ^13.1.3 78 Ink ^7.0.3 79 @clack/prompts 1.4.0 outdated 79 node-postgres ^8.21.0 80 SQLGlot >=30 81 duckdb >=1.0 81 posthog >=7.16.1 81 Psycopg >=3.3.4 82 yaml ^2.9.0 83 better-sqlite3 ^12.10.0 outdated 83 Requests >=2.34.2 84 Pino ^10.3.1 85 PGlite ^0.4.5 outdated 88 snowflake-sdk ^2.4.2 outdated 89 openai-codex-cli-bin ^0.133.0 outdated 90 MCP TypeScript SDK ^1.29.0 90 Tailwind CSS ^4 90 Fumadocs Core 16.8.10 outdated 90 Ruff 90 Tailwind CSS ^4 90 Uvicorn >=0.48.0 90 Zod ^4.4.3 91 @clickhouse/client ^1.18.5 91 React Flow ^12.10.2 91 FastAPI >=0.136.3 92 AI SDK 3.0.78 outdated 92 AI SDK 0.0.18 outdated 92 AI SDK ^4.0.134 outdated 92 Vitest ^4.1.7 outdated 92 AI SDK ^6.0.188 outdated 92 Pydantic >=2.13.4 92 sentence-transformers >=5.1.1 92 Vitest ^4.1.7 outdated 93 AWS SDK for JavaScript (S3 Client) ^3.1068.0 93 AWS SDK for JavaScript (S3 Client) ^3.1068.0 93 @notionhq/client ^5.22.0 93 posthog-js ^5.34.9 outdated 94 node-mssql ^12.5.4 94 MySQL2 ^3.22.3 95 OpenAI ^6.38.0 outdated 96 node-mongodb-native ^6.12.0 outdated 96 Next.js ^16 96 NumPy >=2.4.6 96 pytest >=8 96 PyTorch >=2.2.0 96 TypeScript ^6.0 outdated 97 React 19.2.6 outdated 97 React DOM 19.2.6 outdated 98 Google Cloud Storage ^8.3.1 outdated 98 Google Cloud Storage 10.6.2 outdated 98 pandas >=3.0.3

Join founders buildingwith open source

Opinionated takes, migration guides, cost-saving tips, and insights from the open source ecosystem.

Subscribe on Substack
Join 750+ subscribers

Search