Transform

Use this to author and change a dbt project or a semantic layer: bootstrap a project (`transform init`), write or refactor models from staging to marts, add tests and docs, and define semantic models, entities, dimensions, and metrics in MetricFlow, Apache Ossie or SLayer YAML. Reach for it instead of editing model files by hand whenever a change spans more than one file or must stay consistent with the project: it validates the edit against the real schema, returns a reviewable diff with a plan id, and catches what otherwise fails at `dbt run`, such as wrong columns or broken refs. Bug-fix ti

136 stars 69 forksAI, LLMs & Agents

Install

skills CLI (Claude Code, Cursor, Codex and more)
npx skills add exmergo/dex --skill transform
Manual install
git clone --depth 1 https://github.com/exmergo/dex.git /tmp/dex
mkdir -p ~/.claude/skills
cp -r /tmp/dex/claude/skills/transform ~/.claude/skills/transform

Personal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.

From the SKILL.md

# Transform

Author and refactor the dbt project, both the SQL (staging to marts, tests,
docs) and the semantic layer on top. You write the file content; the engine
validates it, computes the diffs, and stores a plan. Nothing reaches the project
until `transform apply`, and any build runs against a dev target only.

## Procedure

For project setup, run `dex init` (or `init` through an installed skill wrapper).
It creates or adopts a project, installs managed README and agent instructions,
and verifies the connection. It does not explore data or build models. Read its
structured missing inputs and readiness before continuing; installing skills
does not necessarily install a `dex` executable.

Dex works in one loop: explore, transform, maintain. `dex <command>` below is
the `dex` CLI; where it is not installed, run the same command through the
skill's `scripts/run.py` wrapper. Each command prints one JSON envelope: read
it and decide the next step from it. Step 1 only reads. Steps 2 to 5 change the
project, so take them only when the task asks for a change; a question about the
data stops after step 1 and reports what it found. Explore and maintain report
findings and hand repair work to transform; only the transform workflow performs
the project edits, migrations and dev builds described below.

1. **Profile what the change reads.** Before writing or fixing SQL against a
   table whose columns, types, grain or join keys you have not verified in this
Read the full skill on GitHub

Details

Skill name
transform
Repository
exmergo/dex
Path
claude/skills/transform/SKILL.md
License
Apache-2.0
Repo updated
18 November 2026

FAQ

What does the Transform skill do?

Use this to author and change a dbt project or a semantic layer: bootstrap a project (`transform init`), write or refactor models from staging to marts, add tests and docs, and define semantic models, entities, dimensions, and metrics in MetricFlow, Apache Ossie or SLayer YAML. Reach for it instead of editing model files by hand whenever a change spans more than one file or must stay consistent with the project: it validates the edit against the real schema, returns a reviewable diff with a plan id, and catches what otherwise fails at `dbt run`, such as wrong columns or broken refs. Bug-fix ti

How do I install the Transform skill?

skills CLI (Claude Code, Cursor, Codex and more): npx skills add exmergo/dex --skill transform. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.

Is Transform popular?

It lives in exmergo/dex, which has 136 GitHub stars and 69 forks, and is included in 1 curated skill list.

Related skills

Explore

136

exmergo/dex

Use this whenever you need to know what is actually in a database, warehouse, or DuckDB file before you trust it: inventory, column profiles, PII detection, grain and data-quality problems, verified joins, ER diagrams, ad-hoc SQL probes, segmentation, and the semantic layer a repo declares (dbt, Ossie, SLayer, or Cube). Trigger it on an unmet precondition, not on phrasing: if you are about to write or fix SQL against tables whose columns, types, grain, or join keys you have not verified in this session, use this FIRST. That includes dbt work (building a model, fixing one, debugging wrong numbe

DatabasesIn 1 list69

Maintain

136

exmergo/dex

Use this to find out whether an existing dbt project or semantic layer (dbt, Ossie, SLayer or Cube) is correct against its warehouse, and if not, why. `maintain verify` checks the project as it stands; against a .dex/ snapshot, `maintain check` finds schema, volume, grain, and semantic drift and `maintain reconcile` proposes the fix. Reach for it whenever an existing project is suspected wrong, whether or not anything is known to have changed: "this model is wrong, work out why", "the numbers look too high", "some rows are missing", "this column is empty", "duplicates in my fact table", "the p

DatabasesIn 1 list69

Agentation

216

23jmo/jmo-skills

Add Agentation visual feedback toolbar to a Next.js project

AI, LLMs & Agents18

Rsi

198

goodnight000/cstack

Improve an agent's skills, instructions, tools, or working process through bounded before-and-after experiments. Use when asked to run agent self-improvement or test a proposed harness change; ordinary session reviews belong in Reflect.

AI, LLMs & Agents38

Databricks AI Functions

407

databricks/databricks-agent-skills

Use Databricks built-in AI Functions (ai_classify, ai_decide, ai_extract, ai_summarize, ai_mask, ai_translate, ai_fix_grammar, ai_gen, ai_analyze_sentiment, ai_similarity, ai_parse_document, ai_prep_search, ai_query, ai_forecast) to add AI capabilities directly to SQL and PySpark pipelines without managing model endpoints. Also covers document parsing and building custom RAG pipelines (parse → prep_search → index → query).

AI, LLMs & Agents103

Local LLM Router

299

hoodini/ai-agents-skills

Route AI coding queries to local LLMs in air-gapped networks. Integrates Serena MCP for semantic code understanding. Use when working offline, with local models (Ollama, LM Studio, Jan, OpenWebUI), or in secure/closed environments. Triggers on local LLM, Ollama, LM Studio, Jan, air-gapped, offline AI, Serena, local inference, closed network, model routing, defense network, secure coding.

AI, LLMs & Agents76

Browse the most popular Claude skills, all ai, llms & agents skills, or write your own with the skills generator.