Skills

Historic SQL Table Digest

Convert one changed historic-SQL table usage bucket into typed table usage evidence for...

Install

npx skills add Kaelio/ktx --skill historic_sql_table_digest -g -a claude-code -y
Repository
Kaelio/ktx1.6k
Category
Data and ML
Updated
13d ago
License
Apache-2.0
Context cost
Lightabout 896 tokens
Runs scripts
No, instructions only

What it does

Convert one changed historic-SQL table usage bucket into typed table usage evidence for deterministic _schema projection.

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:

  1. discover_data({query: "<topic>"}) - see what wikis, SL sources, and raw tables already exist. Prefer updating existing pages over creating new ones.

Before emitting any schema.table or schema.table.column into a wiki body, SL source, tables: frontmatter, sl_refs, or emit_unmapped_fallback:

Read the whole SKILL.md on GitHub

More in Data and ML