Updated 1mo ago
by Kaelio
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
1.6k GitHub stars (1,617)
+14 in 20 days
| Period | New stars |
|---|---|
| Sep 27 | 0 |
| Sep 28 | 0 |
| Sep 29 | +1 |
| Sep 30 | +1 |
| Oct 1 | 0 |
| Oct 2 | +3 |
| Oct 3 | +1 |
| Oct 4 | −1 |
| Oct 5 | +2 |
| Oct 6 | −1 |
| Oct 7 | +1 |
| Oct 8 | +2 |
| Oct 9 | +1 |
| Oct 10 | +1 |
| Oct 11 | +2 |
| Oct 12 | 0 |
| Oct 13 | 0 |
| Oct 14 | 0 |
| Oct 15 | +1 |
| Oct 16 | 0 |
- 17 skills (17 skills found in its SKILL.md files)
- 113 forks (113 forks)
- 1mo ago last update (Last updated 1mo ago)
Install
Skills CLI
npx skills add Kaelio/ktx
Asks which skills and agents to install. Just one: npx skills add Kaelio/ktx --skill ktx — add -g for every project.
Claude Code
git clone https://github.com/Kaelio/ktxcp -r "ktx/skills/ktx" ~/.claude/skills/
Copies the ktx skill into ~/.claude/skills/ for every project (use .claude/skills/ for one project). Repeat for the other skills listed below.
Plugin
/plugin marketplace add Kaelio/ktx
Run inside Claude Code if the repository ships a plugin marketplace, then pick plugins from /plugin.
Skills can run code on your machine — read the SKILL.md first.
What it does
In the author's own words, from each skill's SKILL.md.
-
ktx
Installs and configures ktx, the open-source context layer for data agents — runs ktx setup non-interactively with hidden CLI flags, configures database connections and embeddings, installs agent integration, and verifies readiness. Use when the user asks an agent to add ktx to a project, connect data sources, install agent rules, ingest schema, or troubleshoot a local ktx install.
skills/ktx/SKILL.md on GitHub (opens in a new tab) -
ktx-analytics
Use when answering a question that needs data from a ktx-connected database - investigating, analyzing, "how many", "show me", "what's the breakdown of", finding records by value, exploring tables, comparing periods, explaining metrics, or any data-analysis request. Triggers even when the user does not say "analytics"; if the answer requires querying a configured ktx connection, this skill applie…
packages/cli/src/skills/analytics/SKILL.md on GitHub (opens in a new tab) -
dbt_ingest
Map dbt `schema.yml` / `properties.yml` models and sources into ktx semantic-layer overlays and column notes. Covers `sources:` vs `models:`, column `data_tests` (not_null, unique, accepted_values, relationships), and how bundle-time writes complement manifest backfill from git sync. Load when the WorkUnit's `skillNames` includes `dbt_ingest` or when raw files are dbt YAML under `models/` / `sour…
packages/cli/src/skills/dbt_ingest/SKILL.md on GitHub (opens in a new tab) -
gdrive_synthesize
Synthesize durable KTX wiki pages from staged Google Drive document pulls. Load when a WorkUnit contains Google Doc raw files from `docs/**`.
packages/cli/src/skills/gdrive_synthesize/SKILL.md on GitHub (opens in a new tab) -
historic_sql_patterns
Identify recurring cross-table historic-SQL analytical intents from a bounded pattern shard and emit typed pattern evidence for deterministic wiki projection.
packages/cli/src/skills/historic_sql_patterns/SKILL.md on GitHub (opens in a new tab) -
historic_sql_table_digest
Convert one changed historic-SQL table usage bucket into typed table usage evidence for deterministic _schema projection.
packages/cli/src/skills/historic_sql_table_digest/SKILL.md on GitHub (opens in a new tab) -
ingest_triage
Classify and resolve conflicts detected during bundle ingest (structural duplicates, definitional contradictions, near-duplicate clusters, re-ingest changes, evictions).
packages/cli/src/skills/ingest_triage/SKILL.md on GitHub (opens in a new tab) -
live_database_ingest
Capture semantic-layer and knowledge updates from a live database schema snapshot.
packages/cli/src/skills/live_database_ingest/SKILL.md on GitHub (opens in a new tab) -
looker_ingest
Extract durable ktx knowledge and semantic-layer contribution proposals from staged Looker runtime dashboard, Look, and explore JSON. Load for WorkUnits whose raw files are under explores/, dashboards/, or looks/.
packages/cli/src/skills/looker_ingest/SKILL.md on GitHub (opens in a new tab) -
lookml_ingest
Map a LookML view/model/explore into ktx semantic layer sources. Covers the LookML to ktx primitive table, provenance tagging, and three worked examples (overlay, standalone from derived_table, standalone with sql_always_where). Load when the turn contains `.lkml` content.
packages/cli/src/skills/lookml_ingest/SKILL.md on GitHub (opens in a new tab) -
metabase_ingest
Convert Metabase questions, models, and metrics into ktx Semantic Layer source definitions. Covers result-metadata to KSL column type mapping, FK/PK detection, near-duplicate deduplication, pre-aggregation decomposition, join-graph connectivity, and how to react to priorProvenance from earlier ingest syncs. Load when the WorkUnit contains `cards/<id>.json` files under a Metabase bundle.
packages/cli/src/skills/metabase_ingest/SKILL.md on GitHub (opens in a new tab) -
metricflow_ingest
Map a MetricFlow semantic_model or metric into ktx semantic layer sources. Covers the MetricFlow to ktx primitive table, `extends:` inheritance flattening, metric-type handling (simple / derived / ratio / cumulative / conversion), `model: ref('x')` resolution, and four worked examples. Load when the turn contains `.yml`/`.yaml` files with top-level `semantic_models:` or `metrics:`.
packages/cli/src/skills/metricflow_ingest/SKILL.md on GitHub (opens in a new tab) -
notion_synthesize
Synthesize durable ktx wiki pages and semantic-layer sources from staged Notion pages, databases, data-source rows, and clustered Notion evidence. Load when a WorkUnit contains Notion raw files or Notion evidence chunks.
packages/cli/src/skills/notion_synthesize/SKILL.md on GitHub (opens in a new tab) -
sigma_ingest
Extract durable ktx wiki knowledge from staged Sigma data model specs and workbook summaries. Load for WorkUnits with unitKey sigma-data-models or sigma-workbooks.
packages/cli/src/skills/sigma_ingest/SKILL.md on GitHub (opens in a new tab) -
sl
ktx's semantic layer - a structured catalog of sources (tables/views), measures, joins, and segments expressed as YAML. Covers the schema and how to query it via `sl_query`. Use when the task involves querying pre-defined metrics (ARR, churn, retention, LTV, MAU) or reading SL source YAML to understand the catalog. Capture is handled by the `sl_capture` skill (memory-agent only).
packages/cli/src/skills/sl/SKILL.md on GitHub (opens in a new tab) -
sl_capture
How to capture new reusable patterns into ktx's semantic layer - when a measure, segment, or join belongs in the catalog and how to write it generically so it stays small and useful over time. Loaded by the post-turn memory-agent only. The research agent does not write to the SL.
packages/cli/src/skills/sl_capture/SKILL.md on GitHub (opens in a new tab) -
wiki_capture
ktx's knowledge base - wiki pages for durable, reusable business knowledge. Covers capture workflow for user preferences, metric definitions, organizational conventions, and cross-references between wiki pages and semantic-layer sources. Loaded by the post-turn memory-agent only. The research agent reads wiki via `wiki_read`/`wiki_search` but does not write it.
packages/cli/src/skills/wiki_capture/SKILL.md on GitHub (opens in a new tab)
No skill matches that filter.
Review before you install
A skill is a set of instructions and scripts your agent will follow, and it can run code on your machine. Read the SKILL.md and any scripts first — this listing is not a security review.
Similar skills
-
distillyby titanwings Distilly — Distill how they think into reusable Skills for any Agent or Bot. Formerly Colleague Skill（原同事 Skill）.
-
awesome-design-skillsby bergside List of 67 awesome DESIGN.md and SKILL.md design skill files for agentic tools like Claude Design, Google Stitch, Codex, Cursor, and other…
-
J-Space-Cognition-Suiteby Tiger3807861189 J-Space Cognition Suite — a model-agnostic inference-time control suite for deep reasoning, long-horizon work, verification, and recovery.…
-
agents-best-practicesby DenisSergeevitch Provider-neutral Agent Skill for Codex, Claude Code, and agentic harness design.
-
pm-claude-skillsby mohitagw15856 1255 professional Agent Skills for Claude, ChatGPT, Gemini, Cursor & Codex — PRDs, postmortems, leases, medical bills, layoffs, go-bags, ne…
-
reaby morluto Reverse engineer anything with agents, from app behavior down to native binaries.