Historic SQL Patterns

Historic SQL Patterns 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 Patterns

Copy Historic SQL Patterns 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_patterns ~/.claude/skills/historic_sql_patterns

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_patterns/SKILL.md in Kaelio/ktx
Installs to: ~/.claude/skills/historic_sql_patterns
Collection: One of 17 skills cataloged from this repository
Category: Data — 668 skills

What Historic SQL Patterns does

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.

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

Documentation

README

Excerpt

Historic SQL Patterns

Use this skill when the WorkUnit raw file is a patterns-input/part-0001.json style shard from the historic-sql adapter. Older staged bundles may still provide root patterns-input.json; when that is the WorkUnit raw file, read it the same way.

Required Workflow

Read the WorkUnit notes first.
Find the single pattern input file listed under the WorkUnit rawFiles section.
Call read_raw_file for that exact raw file path.
Identify recurring analytical intents that span at least two tables and have repeated usage signal.
Emit one pattern evidence object per durable cross-table intent by calling emit_historic_sql_evidence.
Stop after all pattern evidence has been emitted.

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

Frequently asked about Historic SQL Patterns

What else does Kaelio publish alongside Historic SQL Patterns?
Historic SQL Patterns 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 Table Digest and Ingest Triage. Each one is a separate skill with its own page in this directory, installs the same way Historic SQL Patterns 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 Patterns compare to other Data skills?
Historic SQL Patterns ranks #373 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 Patterns against them. Open each page to compare what they document and how they install.