Maintain

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

136 stars 69 forksDatabases

Install

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

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

From the SKILL.md

# 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.

## 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
Read the full skill on GitHub

Details

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

FAQ

What does the Maintain skill do?

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

How do I install the Maintain skill?

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

Is Maintain 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

Transform

136

exmergo/dex

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

AI, LLMs & AgentsIn 1 list69

Databricks Data Discovery

407

databricks/databricks-agent-skills

Discover, explore, and query Databricks data via Genie — the CLI equivalent of the Genie One MCP. MUST be invoked whenever the user asks to find or locate data ('what tables are in X', 'where does X live', 'which catalog/schema has Y'), answer a natural-language question about the data, or write a SQL query.

Databases103

Databricks Dbsql

407

databricks/databricks-agent-skills

Databricks SQL (DBSQL) advanced features and SQL warehouse capabilities. This skill MUST be invoked when the user mentions: "DBSQL", "Databricks SQL", "SQL warehouse", "SQL scripting", "stored procedure", "CALL procedure", "materialized view", "CREATE MATERIALIZED VIEW", "pipe syntax", "|>", "geospatial", "H3", "ST_", "spatial SQL", "collation", "COLLATE", "ai_query", "ai_classify", "ai_extract", "ai_gen", "AI function", "http_request", "remote_query", "read_files", "Lakehouse Federation", "recursive CTE", "WITH RECURSIVE", "multi-statement transaction", "temp table", "temporary view", "pipe o

Databases103

Mongodb

299

hoodini/ai-agents-skills

Work with MongoDB databases using best practices. Use when designing schemas, writing queries, building aggregation pipelines, or optimizing performance. Triggers on MongoDB, Mongoose, NoSQL, aggregation pipeline, document database, MongoDB Atlas.

Databases76

Databricks Execution Compute

407

databricks/databricks-agent-skills

Execute code and manage compute on Databricks: run Python/Scala/SQL/R via serverless, classic, or interactive clusters, and create/resize/delete clusters and SQL warehouses.

Databases103

Browse the most popular Claude skills, all databases skills, or write your own with the skills generator.