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