factory-db-migration SKILL.md skillA

factory-db-migration from nonlinear-xyz/factory-kit is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add nonlinear-xyz/factory-kit/factory-db-migration@git:20260716.517fb94

Pins git:20260716.517fb94 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
nonlinear-xyz/factory-kit
Path
skills/factory-db-migration/SKILL.md
Versions recorded
1
Latest version
git:20260716.517fb94, committed Jul 16, 2026
Size
23,727 bytes
Repository stars
9
License
MIT

The operational discipline for running a destructive change against a production database — schema migrations, data backfills, one-shot RPCs, historical seed imports. Adjacent to `factory-data-layer.md` (schema design) and `factory-deployment.md` (where migrations execute in CI) — this skill is about the runbook around the act of mutating prod. Covers the three-stage write contract (preflight → mutate → verify → rollback), idempotency by natural key, layered backup independence…

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

# Factory DB migration

This skill is the runbook discipline for making a destructive database change. It is invoked **before** the first time a migration, backfill, or seed touches prod — and re-invoked on every periodic re-import.

The factory ships `factory-data-layer.md` for *how schemas are designed* and `factory-deployment.md` for *where migrations execute in CI*. This skill is the third leg: **how to run the change safely once both upstream pieces are in place.** Read all three before proposing a non-trivial prod write.

## How to use this skill

- **Before any first-of-its-kind destructive prod write** — read the Principle of each section. If you can't articulate the principle in your own words, you don't yet understand the change well enough to ship it.
- **During design review** — use the section list as a checklist: do we have preflight? Idempotency proof? Rollback? Pre-write snapshot? Human gates?
- **During incident response** — `factory-pitfalls.md` indexes the failure modes here; jump to the one that matches.

## The data is ground truth — the schema accommodates it
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add nonlinear-xyz/factory-kit/factory-db-migration@sha256:c5501bc1b617549e

The line at the top of this page pins the label git:20260716.517fb94, 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_s6m4mlylgm76qzdc.svg)](https://markdownregistry.com/a/art_s6m4mlylgm76qzdc)

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

Versions

The registry has recorded 1 version of this file, committed on Jul 16, 2026.

versioncommittedcommitsizeaudit
git:20260716.517fb94 latest2026-07-16 517fb94 23,727 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 (23727 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

nonlinear-xyz/factory-kit · 9 stars · license MIT · pushed 2026-10-29 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_s6m4mlylgm76qzdc
GET https://markdownregistry.com/api/v1/resolve?ref=nonlinear-xyz/factory-kit/factory-db-migration
GET https://markdownregistry.com/api/v1/blob/c5501bc1b617549e925e4a13a9fa5310ca2b8b322637aba725cc26370deb2e44

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 nonlinear-xyz/factory-kit

factory-animation SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-animation/SKILL.md · Motion discipline distilled across builds. Attention as a fixed per-viewport budget, figure/ground separation (calm the…
git:20260716.517fb94 · audit A · 9 stars
factory-api-route-engineer SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-api-route-engineer/SKILL.md · Use when designing or implementing API endpoints — server actions, tRPC procedures, REST routes for external consumers…
git:20260716.517fb94 · audit A · 9 stars
factory-api SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-api/SKILL.md · API conventions for both server actions and tRPC builds. Covers the decision between them, per-mutation Zod input…
git:20260716.517fb94 · audit A · 9 stars
factory-auth-wiring-specialist SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-auth-wiring-specialist/SKILL.md · Use when wiring auth into a new project, switching auth providers, or adding role/org features. Carries the factory's…
git:20260716.517fb94 · audit A · 9 stars
factory-auth SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-auth/SKILL.md · Auth and authorization conventions distilled across builds with three different auth stacks (Better Auth + orgs…
git:20260716.517fb94 · audit A · 9 stars
factory-ci SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-ci/SKILL.md · CI and pull-request review conventions. One canonical `.github/workflows/ci.yml` is the merge gate (typecheck, lint…
git:20260716.517fb94 · audit A · 9 stars
factory-close SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-close/SKILL.md · Close out a Linear issue — move to Done, add a closing comment, and clean up the local branch/worktree
git:20260716.517fb94 · audit A · 9 stars
factory-code-reviewer SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-code-reviewer/SKILL.md · Use to review a PR, diff, or recently-written code against the factory's conventions. Read-only — outputs structured…
git:20260716.517fb94 · audit A · 9 stars
factory-commits SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-commits/SKILL.md · Commit message and branch convention — Conventional Commits format with a Linear issue reference required in subject or…
git:20260716.517fb94 · audit A · 9 stars
factory-data-layer SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-data-layer/SKILL.md · Database schema, ORM, and migration conventions across builds. Drizzle as default with domain-partitioned schema…
git:20260716.517fb94 · audit A · 9 stars
factory-data-pipeline-engineer SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-data-pipeline-engineer/SKILL.md · Use when designing or implementing data ingestion, CSV imports, time-series storage, Python services that sit alongside…
git:20260716.517fb94 · audit A · 9 stars
factory-data-pipelines SKILL.md skill
nonlinear-xyz/factory-kit · skills/factory-data-pipelines/SKILL.md · Data ingestion and pipeline conventions for projects that import CSVs, run simulations, or operate Python services…
git:20260716.517fb94 · audit A · 9 stars

Every file in nonlinear-xyz/factory-kit

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