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:20261019.afd1dcf

Pins git:20261019.afd1dcf in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
exmergo/dex
Path
skills/maintain/SKILL.md
Versions recorded
21
Latest version
git:20261019.afd1dcf, committed Oct 19, 2026
First version recorded
Sep 1, 2026
Size
14,117 bytes
Repository stars
88
License
Apache-2.0

Use this to find out whether an existing dbt project or semantic layer (dbt, Ossie or SLayer) 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. Every step runs one engine
command, reads the single JSON envelope it prints, and decides the next step
from that envelope.

1. **Explore before you write.** Before writing or fixing SQL against a table
   whose columns, types, grain, or join keys you have not verified in this
   session, run `explore map` (or `explore profile <tables>` for a few named
   ones) and read its grain, keys, PII flags, and data-quality findings. Answer
   ad-hoc questions with `explore query`, never with a raw database client.
2. **Plan the change.** Author the file content and hand it to `transform plan`
   (or `semantic define|update|plan` for the semantic layer). Nothing is written
…

Read the whole file at its exact version.

How to install

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

The line at the top of this page pins the label git:20261019.afd1dcf, 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_dgkxwweynivpepp3.svg)](https://markdownregistry.com/a/art_dgkxwweynivpepp3)

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

Versions

The registry has recorded 21 versions of this file, between Sep 1, 2026 and Oct 19, 2026, about one every 2 days. Its first recorded version is graded B and its latest A.

versioncommittedcommitsizeaudit
git:20261019.afd1dcf latest2026-10-19 afd1dcf 14,117 BA view · diff
git:20261018.7b1c7bc2026-10-18 7b1c7bc 14,091 BA view · diff
git:20261016.de16d0d2026-10-16 de16d0d 13,486 BA view · diff
git:20261016.d241ff12026-10-16 d241ff1 11,906 BA view · diff
git:20261016.e79fa842026-10-16 e79fa84 12,590 BA view · diff
git:20261014.e918bad2026-10-14 e918bad 11,885 BA view · diff
git:20261012.7f9a0ba2026-10-12 7f9a0ba 12,008 BA view · diff
git:20261012.90a6b122026-10-12 90a6b12 12,615 BA view · diff
git:20261012.32132242026-10-12 3213224 12,012 BA view · diff
git:20261012.32336532026-10-12 3233653 11,961 BA view · diff
git:20261011.8dd6aa22026-10-11 8dd6aa2 11,114 BA view · diff
git:20261008.49fc23d2026-10-08 49fc23d 11,054 BB view · diff
git:20260916.898c8182026-09-16 898c818 18,082 BB view · diff
git:20260908.277fe262026-09-08 277fe26 17,971 BB view · diff
git:20260907.61207492026-09-07 6120749 17,270 BB view · diff
git:20260906.9a46d772026-09-06 9a46d77 14,994 BB view · diff
git:20260905.62f4f7c2026-09-05 62f4f7c 12,245 BB view · diff
git:20260903.dbc25ec2026-09-03 dbc25ec 11,578 BB view · diff
git:20260903.d1f8b042026-09-03 d1f8b04 10,934 BB view · diff
git:20260902.bfe286a2026-09-02 bfe286a 10,572 BB view · diff
git:20260901.3687a822026-09-01 3687a82 10,230 BB 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 (14117 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 · 88 stars · license Apache-2.0 · pushed 2026-10-19 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_dgkxwweynivpepp3
GET https://markdownregistry.com/api/v1/resolve?ref=exmergo/dex/maintain
GET https://markdownregistry.com/api/v1/blob/a9d21172ce6dc6bc86ce8307f3e160d86cd198307ddbca96cbfd403363de80bb

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:20260626.ae43ecc · audit A · 88 stars
AGENTS.md AGENTS.md file
exmergo/dex · AGENTS.md
git:20261019.afd1dcf · audit A · 88 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:20261019.d2d852a · audit A · 88 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:20261019.afd1dcf · audit A · 88 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,074 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,074 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,074 stars

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