🗃️
DataTypeScript

Historic SQL Table Digest

by Kaelio

Historic SQL Table Digest is a Data skill for Claude Code, published by Kaelio in ktx.

1.5K stars99 forkson Kaelio/ktxAdded 2026/08/19+1% in starsRepository updated 2026/07/19
agentagent-skillsagentsai-agentai-agentsanalyticsanalytics-engineeringbusiness-intelligenceclaudeclaude-codeclaude-skillscodexcontext-layerdata-analysisdata-engineeringllmmcpmemorysemantic-layerskills
Install in seconds
Install Historic SQL Table Digest
Copy Historic SQL Table Digest into your Claude Code skills folder. Run the command in your terminal, or review the source on GitHub before installing.
terminal
npx degit https://github.com/Kaelio/ktx/tree/main/packages/cli/src/skills/historic_sql_table_digest ~/.claude/skills/historic_sql_table_digest

Requires Node.js. Downloads this skill only — not the rest of the repository — into your Claude Code skills folder.

Without Node.js

git clone https://github.com/Kaelio/ktx.git

Clones the whole repository, then copy the skill’s own directory into your skills folder yourself.

In this catalog

Source file
packages/cli/src/skills/historic_sql_table_digest/SKILL.md in Kaelio/ktx
Installs to
~/.claude/skills/historic_sql_table_digest
Collection
One of 17 skills cataloged from this repository
Category
Data668 skills

What Historic SQL Table Digest does

Historic SQL Table Digest converts a changed historic-SQL table usage bucket into typed table usage evidence for deterministic schema projection. Use it when a WorkUnit raw file is a tables/<schema>.<name>.json from the historic-sql adapter.

Historic SQL Table Digest is cataloged under Data on DirSkills. Historic SQL Table Digest comes from a repository tagged agent, agent-skills, agents, ai-agent and ai-agents.

Documentation

README

Historic SQL Table Digest

Use this skill when the WorkUnit raw file is one tables/<schema>.<name>.json file from the historic-sql adapter.

Required Workflow

  1. Read the WorkUnit notes first.
  2. Call read_raw_file for the single tables/<schema>.<name>.json raw file.
  3. Read manifest.json only if the table JSON omits the dialect or the WorkUnit notes are unclear.
  4. Produce one concise usage narrative for this table from the staged table JSON.
  5. Call emit_historic_sql_evidence exactly once with kind: "table_usage".
  6. Stop after the evidence tool succeeds.

Identifier Verification Protocol

Before writing a wiki page or SL source on any topic:

This is the opening of the README. Read the full README on GitHub.

Frequently asked about Historic SQL Table Digest

  • What else does Kaelio publish alongside Historic SQL Table Digest?

    Historic SQL Table Digest is one of 17 skills that DirSkills catalogs from Kaelio/ktx, the repository it ships in. Its siblings there include Google Drive Doc Synthesis, Historic SQL Patterns and Ingest Triage. Each one is a separate skill with its own page in this directory, installs the same way Historic SQL Table Digest does, and is maintained by Kaelio in that same repository. The rest of the collection is listed on the Kaelio/ktx page.

  • How does Historic SQL Table Digest compare to other Data skills?

    Historic SQL Table Digest ranks #374 by stars among the 668 Data skills in this catalog. The most-starred ones next to it are Benchmark Methodology, Jupyter Notebook and Solana. DirSkills ranks by the star count of the repository each skill ships in, so that order reflects how popular those repositories are rather than any review of Historic SQL Table Digest against them. Open each page to compare what they document and how they install.

More from Kaelio/ktx

Historic SQL Table Digest is one of 17 skills cataloged on DirSkills from Kaelio/ktx.

See all 17 skills
📚
2w ago

Google Drive Doc Synthesis

Google Drive Doc Synthesis reads staged Google Drive documents and writes durable wiki pages that capture reusable organizational knowledge. Use it when a WorkUnit contains Google Doc raw files from docs/** and needs search, evidence reconciliation, and semantic-layer verification.
Writing
1.5K99
🔍
2w ago

Historic SQL Patterns

Historic SQL Patterns identifies recurring cross-table analytical intents from historic SQL usage shards and emits typed pattern evidence for deterministic wiki projection. Use it when processing a patterns-input shard from the historic-sql adapter.
Data
1.5K99
🔀
2w ago

Ingest Triage

Ingest Triage classifies and resolves conflicts detected during data bundle ingest, including structural duplicates, definitional contradictions, near-duplicate clusters, re-ingest changes, and evictions. Use it before writes that could collide with existing artifacts in a semantic layer.
Data
1.5K99
📊
2w ago

KTX Analytics

KTX Analytics queries a KTX-connected database using MCP tools for discovery, semantic-layer analysis, and raw read-only SQL to investigate metrics, explore tables, compare periods, and explain findings. Use it for any data-analysis request against a configured KTX connection.
Data
1.5K99
🧠
2w ago

Ktx

Ktx installs and configures the open-source context layer for data agents. Use when an agent needs to add ktx to a project, connect data sources, install agent rules, ingest schema, or troubleshoot a local setup.
DevOps
1.5K99
🗄️
2w ago

Live Database Ingest

Live Database Ingest creates or updates semantic-layer sources from a live database schema snapshot, preserving table and column comments. Use it when an ingest work unit contains raw database table JSON under raw-sources.
Data
1.5K99