Seshat-BI: Skill for Claude Code

.claude/skills/dbt-transformation-adapter/SKILL.md

dbt-transformation-adapter is a skill for Claude Code from Kemetra/Seshat-BI. It costs 142 tokens per session (2,398 once invoked), scanned A, original, Apache-2.0.

A governed adapter for running dbt, a tool that builds data models from SQL and tests them, for the silver and gold layers of Seshat BI.

In plain words
What is it for?
Building approved silver and gold tables, running dbt tests, and checking parity with existing gold tables through the Seshat BI workflow.
Why use it?
It keeps dbt runs behind readiness checks and records their results as evidence without letting the tool approve data or make business decisions.

Skill for Claude Code

Written for Claude Code: installed under .claude/.

This is Kemetra/Seshat-BI's own configuration. It tells Claude Code how to work on Seshat-BI itself, so it is not a mod to install elsewhere. Copy it as a starting point and replace the rules that are about this project. Everything Seshat-BI configures →

Reuse

Borrowing it

Nothing to install: this file belongs to Kemetra/Seshat-BI. Take a copy, put it at the same path in your own repository, and replace the rules that are about this project with yours.

Copy the file
curl -O https://raw.githubusercontent.com/Kemetra/Seshat-BI/main/.claude/skills/dbt-transformation-adapter/SKILL.md
Clone the repo
git clone --depth 1 https://github.com/Kemetra/Seshat-BI

Made for: Claude Code.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for dbt-transformation-adapter

README.md
[![agentmods](https://agentmods.dev/badge/skills/kemetra/seshat-bi/dbt-transformation-adapter/github.svg)](https://agentmods.dev/skills/kemetra/seshat-bi/dbt-transformation-adapter)
Your own site
<a href="https://agentmods.dev/skills/kemetra/seshat-bi/dbt-transformation-adapter"><img src="https://agentmods.dev/badge/skills/kemetra/seshat-bi/dbt-transformation-adapter/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for dbt-transformation-adapter

Your own site · 80×15
<a href="https://agentmods.dev/skills/kemetra/seshat-bi/dbt-transformation-adapter"><img src="https://agentmods.dev/badge/skills/kemetra/seshat-bi/dbt-transformation-adapter.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 142 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 2,398 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00142 $0.02398
Opus 5 $0.00071 $0.01199
Sonnet 5 $0.00028 $0.00480
Haiku 4.5 $0.00014 $0.00240

Measured 11d ago against content hash f59dea095fa1, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-11, from the pricing page.

Security

Grade A, and why

dbt-transformation-adapter scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 11d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

.claude/skills/dbt-transformation-adapter/SKILL.md · 146 lines

How it starts

The opening of the file, as written. The whole thing — 146 lines — stays where its author put it; the contents beside it link to each section on GitHub.

dbt-transformation-adapter

  • Authority category (F024): Execution Adapter / DB-connected (NOT publish-capable).
  • Roadmap feature: F029 On-disk spec: specs/023-dbt-transformation-adapter.

dbt is the build ENGINE: it compiles SQL, materializes models, and runs tests. Seshat BI is the brain: it owns the approved source-map, the metric contracts, and the readiness spine, and routes every judgment call to a named human. This skill is how the agent runs dbt without letting it become the brain. You (the agent reading this) ARE the runtime; this skill is procedure, not an engine -- there is no daemon, no scheduler, no auto-approver. See docs/decisions/0009-dbt-is-transformation-adapter.md and templates/dbt-adapter-contract.md.

ACTIVATED: feature 133 added the governed runtime under dbt/, the pinned dbt-core==1.12.0 + dbt-postgres==1.10.2 extra, and the seshat dbt command family. Use that wrapper only; raw dbt commands bypass the accepted-plan, selector, shadow-schema, redaction, lock, and evidence contracts.

Scope boundary (read first)

Invoke-and-record only. This skill runs dbt behind the gate and records its findings as evidence; it does NOT define source mapping, metric contracts, or semantic logic, does NOT publish Power BI, and does NOT move a readiness stage to pass. Three non-negotiables:

This adapter is not the owner of generic dbt competence. Model-authoring advice, generic test design, command syntax, documentation lookup, MCP configuration, and troubleshooting belong to the official dbt Labs agent skills and dbt MCP. Official-skill activation and discovery must be proven by the Spec 148 harness probe before routing to those skills; MCP liveness remains a separate preflight fact. This skill owns only Seshat's governed pre-gate, invocation policy, evidence normalization, parity interpretation, and human-stop seams around the official dbt Core executor; it must not reproduce upstream instructions.

  • The entry gate is the FIRST refusal point (Principle IV). The canonical gate signal is mappings/<table>/readiness-status.yaml -> stages.mapping_ready.status == pass WITH a matching approvals[] entry (RS1); its human-readable mirror unresolved-questions.md Gate status: CLEARED (zero open rows) MUST agree. dbt may run NO staging/silver/gold model unless that canonical signal holds -- a missing readiness-status file, mapping_ready != pass, or a mismatch between the two -> Refuse + record a blocking_reason. The presence of dbt model files is NOT permission to build.
  • A green dbt test is EVIDENCE, never an approval (the governance hinge). Record the pass/fail counts as evidence[] / blocking_reasons[]; Tower readiness + a named human move Silver/Gold Ready to pass, citing that evidence + the approval. There is NO path by which a green run alone writes pass.
  • dbt stops at gold (Principle III). dbt is DB-connected, not publish-capable; materializing/publishing a Power BI model is the parked F016 adapter, gated separately.

Read the full file on GitHub · 146 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 11d ago First seen · 146 lines · 142 tokens per session scan A f59dea095fa1

Subscribe to this mod's changes

dbt-transformation-adapter is a skill published in the GitHub repository Kemetra/Seshat-BI (2 stars, last pushed yesterday), licensed Apache-2.0. It adds 142 tokens to every session and 2,398 once invoked, about $0.0007 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Related

Other skills, from other repositories

metricflow_ingest

Map a MetricFlow semanticmodel 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…

Kaelio/ktx · 0 tokens

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 derivedtable, standalone with sqlalwayswhere). Load when the turn contains .lkml content.

Kaelio/ktx · 63 tokens

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.

Kaelio/ktx · 36 tokens

modeler

Build, validate, and manage semantic models using Sidemantic. Use when asked to create a semantic layer, define metrics/dimensions, model a database schema, generate models from SQL queries, import from Cube/dbt/LookML, or set up analytics definitions. Prioritizes CLI-first workflows, with YAML and optional Python API…

sidequery/sidemantic · 75 tokens

powerbi-data-catalog-lineage

Data catalog and lineage management. Use when the user mentions: data catalog, lineage, data governance, Microsoft Purview, data dictionary, metadata, data discovery, impact analysis, endorsement, certified, promoted, scan, data map, business glossary, column-level lineage, table lineage, sensitivity label, data…

santoshkanthety/powerbi-agent · 71 tokens

powerbi-medallion-architecture

Bronze/Silver/Gold lakehouse design. Use when the user mentions: medallion, bronze, silver, gold, lakehouse, data lake, data architecture, layer design, raw layer, curated layer, semantic layer, OneLake.

santoshkanthety/powerbi-agent · 58 tokens