Getting it into your agent
One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.
npx skills add hicham-bab/dbt-legacy-migration-skills --skill migrating-matillion-to-dbtgit clone --depth 1 https://github.com/hicham-bab/dbt-legacy-migration-skillsWrote 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.
[](https://agentmods.dev/skills/hicham-bab/dbt-legacy-migration-skills/migrating-matillion-to-dbt)<a href="https://agentmods.dev/skills/hicham-bab/dbt-legacy-migration-skills/migrating-matillion-to-dbt"><img src="https://agentmods.dev/badge/skills/hicham-bab/dbt-legacy-migration-skills/migrating-matillion-to-dbt/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.
<a href="https://agentmods.dev/skills/hicham-bab/dbt-legacy-migration-skills/migrating-matillion-to-dbt"><img src="https://agentmods.dev/badge/skills/hicham-bab/dbt-legacy-migration-skills/migrating-matillion-to-dbt.svg" alt="Reviewed on agentmods" width="80" height="20"></a>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.
| Model | Per session | Once invoked |
|---|---|---|
| Fable 5.1 | $0.00113 | $0.04113 |
| Opus 5 | $0.00056 | $0.02056 |
| Sonnet 5 | $0.00023 | $0.00823 |
| Haiku 4.5 | $0.00011 | $0.00411 |
Grade A, and why
migrating-matillion-to-dbt 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 12d 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.
How it starts
The opening of the file, as written. The whole thing — 286 lines — stays where its author put it; the contents beside it link to each section on GitHub.
Migrating Matillion to dbt
This skill migrates Matillion pipelines/jobs into a governed dbt project — reproducing the transformation logic as dbt models, snapshots, and macros with tests, docs, and contracts, then proving parity against warehouse data.
The core approach: Matillion is a push-down ELT tool — a transformation pipeline is a graph of components (Table Input, Calculator, Filter, Aggregate, Join, Rank, Unite, Rewrite Table…) that Matillion compiles to SQL and executes in the target warehouse. dbt does the same thing. That makes a Matillion transformation pipeline map onto dbt models almost 1:1. We inventory every component, translate using the component answer key, validate each output against the warehouse, and report coverage and cost.
Scope — what maps and what doesn't:
- Transformation pipelines (
.tran.yaml, or transformation jobs in METL JSON) → dbt models. This is the migratable workload and the coverage denominator. - Orchestration pipelines (
.orch.yaml) → mostly out of dbt's scope. Their data-load components (S3 Load, Database/API/connector Query) are EL ingestion (keep in a loader / EL tool);Run Transformationsteps become the dbt DAG/run; scheduling and control flow move to a platform job. Document these; do not force them into models.
Success criteria: Migration is complete when:
dbt compilefinishes with 0 errors and 0 warnings- Every generated model builds (
dbt build) and its tests pass - Data parity is proven for each mart (row-for-row or aggregate baseline — see Step 5)
- ≥95% of the inventoried transformation components are migrated and validated, with the residual (and the out-of-scope orchestration/EL pieces) explicitly listed
Validation cost: dbt compile is the free iteration gate. Only dbt build, dbt test, and
the parity queries touch the warehouse — run those after compile is clean.
This skill shares its workflow with the legacy-to-dbt-migration-foundations skill; steps below
link into its references for the common work. Assume the migrator may be new to dbt — explain each dbt concept (materializations, incremental, snapshots, contracts, Fusion) in plain language as it comes up (foundations → dbt-concepts-explained.md), and explain the reason behind each choice, not just the mechanics.
What ships with it
3 files beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.
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.
- 12d ago First seen · 286 lines · 113 tokens per session scan A 02b5a8e75494
migrating-matillion-to-dbt is a skill published in the GitHub repository hicham-bab/dbt-legacy-migration-skills (2 stars, last pushed 1mo ago), licensed Apache-2.0. It adds 113 tokens to every session and 4,113 once invoked, about $0.0006 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.
Other skills, from other repositories
pinecone
Managed vector DB for production RAG and search.
embeddings
Vector embeddings with HNSW indexing, sql.js persistence, and hyperbolic support. 75x faster with agentic-flow integration. Use when: semantic search, pattern matching, similarity queries, knowledge retrieval. Skip when: exact text matching, simple lookups, no semantic understanding needed.
data-engineer
Build scalable data pipelines, modern data warehouses, and real-time streaming architectures. Implements Apache Spark, dbt, Airflow, and cloud-native data platforms.
graphjin-env
Use when setting up a training or evaluation loop against a GraphJin agent environment — running the container, reading /health, driving episodes hosted or step-by-step or with your own agent over MCP, splitting train from eval, exporting trajectories, and deciding whether two rewards can be compared.
ingesting-into-data-lake
Import data into the AWS data lake from S3 files, local uploads, JDBC databases (Oracle, SQL Server, PostgreSQL, MySQL, RDS, Aurora), Amazon Redshift, Snowflake, BigQuery, DynamoDB, or existing Glue catalog tables (migration). Default target is S3 Tables; standard Iceberg on a general purpose bucket is supported where…
similarity-search-patterns
Implement efficient similarity search with vector databases. Use when building semantic search, implementing nearest neighbor queries, or optimizing retrieval performance.