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

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