maintain SKILL.md skillA

maintain from exmergo/dex is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add exmergo/dex/maintain@git:20261102.6bd9785

Pins git:20261102.6bd9785 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
exmergo/dex
Path
claude/skills/maintain/SKILL.md
Versions recorded
7
Latest version
git:20261102.6bd9785, committed Nov 2, 2026
First version recorded
Oct 27, 2026
Size
27,697 bytes
Repository stars
109
License
Apache-2.0

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…

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file the same grade.

What the file says

# Maintain

Keep the repository correct as the world underneath it moves, on both of its
axes: the dbt project and the semantic layer. Drift is measured against a
**baseline**, the `.dex/snapshot.json` fingerprint of the warehouse map and of
each project layer. Detection is read-only; only `reconcile` proposes edits, and
`transform apply` is the one door that writes them.

<!-- dex:procedure:begin -->
## Procedure

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.

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
   session, run `dex explore profile <tables>` on every relation the change
   reads (`dex explore map` when you do not yet know which), and
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add exmergo/dex/maintain@sha256:2a5956d0f0d46c9b

The line at the top of this page pins the label git:20261102.6bd9785, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_b3makq2jbowctzzl.svg)](https://markdownregistry.com/a/art_b3makq2jbowctzzl)

2 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 7 versions of this file, between Oct 27, 2026 and Nov 2, 2026, about one every day.

versioncommittedcommitsizeaudit
git:20261102.6bd9785 latest2026-11-02 6bd9785 27,697 BA view · diff
git:20261101.72e405c2026-11-01 72e405c 25,227 BA view · diff
git:20261101.b4e56e32026-11-01 b4e56e3 23,549 BA view · diff
git:20261030.52d08692026-10-30 52d0869 19,842 BA view · diff
git:20261029.c5e03842026-10-29 c5e0384 18,880 BA view · diff
git:20261028.97b2d842026-10-28 97b2d84 18,662 BA view · diff
git:20261027.aec1d782026-10-27 aec1d78 17,431 BA view

Audit of the latest version

A  17 of 17 checks passed. Fixed automatic checks with no AI involved, so the same checks give the same answer every run.
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (27697 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No curl or wget piped into a shell
  • pass: No recursive delete of root, home or parent
  • pass: No instruction to read or print local credentials
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

exmergo/dex · 109 stars · license Apache-2.0 · pushed 2026-11-03 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_b3makq2jbowctzzl
GET https://markdownregistry.com/api/v1/resolve?ref=exmergo/dex/maintain
GET https://markdownregistry.com/api/v1/blob/2a5956d0f0d46c9b4aff6d986353a1df9d5e4865c3076e3604f365ccd64e14ab

Your AI assistant does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from exmergo/dex

dex Cursor rule
exmergo/dex · .cursor/rules/dex.mdc · Drive the dex analytics-engineering engine via its command contract
git:20261031.8808dfd · audit A · 109 stars
AGENTS.md AGENTS.md file
exmergo/dex · AGENTS.md
git:20261103.8d313f0 · audit A · 109 stars
explore SKILL.md skill
exmergo/dex · claude/skills/explore/SKILL.md · Use this whenever you need to know what is actually in a database, warehouse, or DuckDB file before you trust it…
git:20261102.6bd9785 · audit A · 109 stars
transform SKILL.md skill
exmergo/dex · claude/skills/transform/SKILL.md · Use this to author and change a dbt project or a semantic layer: bootstrap a project (`transform init`), write or…
git:20261102.6bd9785 · audit A · 109 stars
explore SKILL.md skill
exmergo/dex · skills/explore/SKILL.md · Use this whenever you need to know what is actually in a database, warehouse, or DuckDB file before you trust it…
git:20261103.8d313f0 · audit A · 109 stars
maintain SKILL.md skill
exmergo/dex · skills/maintain/SKILL.md · Use this to find out whether an existing dbt project or semantic layer (dbt, Ossie, SLayer or Cube) is correct against…
git:20261103.8d313f0 · audit A · 109 stars
transform SKILL.md skill
exmergo/dex · skills/transform/SKILL.md · Use this to author and change a dbt project or a semantic layer: bootstrap a project (`transform init`), write or…
git:20261103.8d313f0 · audit A · 109 stars

Every file in exmergo/dex

Other files named maintain

maintain SKILL.md skill
garrytan/gbrain · plugin-variants/gbrain-coding/skills/maintain/SKILL.md · Brain health checks: back-link enforcement, citation audit, filing validation, stale info detection, orphan pages, and…
v1.1.0 · audit A · 31,463 stars
maintain SKILL.md skill
garrytan/gbrain · skills/maintain/SKILL.md · Brain health checks: back-link enforcement, citation audit, filing validation, stale info detection, orphan pages, and…
v1.1.0 · audit A · 31,463 stars
maintain SKILL.md skill
garrytan/gbrain · plugin/skills/maintain/SKILL.md · Brain health checks: back-link enforcement, citation audit, filing validation, stale info detection, orphan pages, and…
v1.1.0 · audit A · 31,463 stars
maintain SKILL.md skill
exmergo/dex · skills/maintain/SKILL.md · Use this to find out whether an existing dbt project or semantic layer (dbt, Ossie, SLayer or Cube) is correct against…
git:20261103.8d313f0 · audit A · 109 stars

Browse by kind, by grade A, or by owner.