db-migration-safety SKILL.md skillA

This file is byte-identical to the first copy the registry indexed. Same content hash, so the same checks give both the same grade.

db-migration-safety from khaledsaeed18/dotclaude is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add khaledsaeed18/dotclaude/db-migration-safety@git:20260921.4ccfb75

Pins git:20260921.4ccfb75 in mdr.lock. Pin the fingerprint instead.

Audit grade
A, 17 of 17 checks passed
Kind
SKILL.md skill
Repository
khaledsaeed18/dotclaude
Path
.claude-plugin/plugins/engineering/skills/db-migration-safety/SKILL.md
Versions recorded
3
Latest version
git:20260921.4ccfb75, committed Sep 21, 2026
First version recorded
Jul 4, 2026
Size
4,475 bytes
Repository stars
5
License
MIT

Review or write a database schema migration with production safety as the bar, checking locks, table rewrites, backfills, expand-contract deploy order, index creation, and rollback for Postgres, MySQL, and common ORMs. Use when adding or reviewing a migration, dropping or renaming columns, or adding constraints or indexes to large tables.

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

A migration that is correct on an empty dev database can still take a production table offline. Judge every migration by what it does under load on the largest table it touches: what lock it takes, for how long, and what the old application version does while the new schema is live. When any answer is "depends", assume the worst table and the slowest query.

## Step 1: Establish the blast radius

- Read the migration and identify every table it touches, then find out (or ask) roughly how large and how hot each one is. A pattern that is fine on 10k rows is an outage on 100M.
- Identify the engine and version (Postgres, MySQL 8, SQLite, ...) from config; lock behavior differs materially between them, and between versions.
- Identify the deploy model: is the old app version still running while this migration executes (rolling deploy, multiple replicas)? Almost always yes; review under that assumption.

## Step 2: Check the dangerous patterns

Flag any of these, with the safe alternative:

**Locking and rewrites**
…

Read the whole file at its exact version.

How to install

The exact contents, by fingerprint
mdr add khaledsaeed18/dotclaude/db-migration-safety@sha256:af006da036ac64a2

The line at the top of this page pins the label git:20260921.4ccfb75, 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_u24cy6ikqredsk6m.svg)](https://markdownregistry.com/a/art_u24cy6ikqredsk6m)

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

Versions

The registry has recorded 3 versions of this file, between Jul 4, 2026 and Sep 21, 2026, about one every 40 days.

versioncommittedcommitsizeaudit
git:20260921.4ccfb75 latest2026-09-21 4ccfb75 4,475 BA view · diff
git:20260921.b1a46522026-09-21 b1a4652 4,546 BA view · diff
git:20260704.3370b832026-07-04 3370b83 4,519 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 (4475 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

khaledsaeed18/dotclaude · 5 stars · license MIT · pushed 2026-11-05 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_u24cy6ikqredsk6m
GET https://markdownregistry.com/api/v1/resolve?ref=khaledsaeed18/dotclaude/db-migration-safety
GET https://markdownregistry.com/api/v1/blob/af006da036ac64a2f12af312a656d9845372d90b553ff7861220484a427b28ca

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 khaledsaeed18/dotclaude

improve SKILL.md skill
khaledsaeed18/dotclaude · .agents/skills/improve/SKILL.md · Survey any codebase as a senior advisor and produce prioritized, self-contained implementation plans for OTHER…
v1.0.0 · audit B · 5 stars
coolify-image-app SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/coolify-image-app/SKILL.md · Create and configure a Coolify application that runs a prebuilt image from a registry. Use when adding an app to…
git:20261005.5100bf0 · audit A · 5 stars
coolify-vps-baseline SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/coolify-vps-baseline/SKILL.md · Prepare a Linux VPS to run production containers under Coolify. Use when setting up a new server, auditing an existing…
git:20261005.5100bf0 · audit A · 5 stars
deploy-verification SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/deploy-verification/SKILL.md · Prove a deployment from the server side. Use when a deploy finished and needs sign-off, when a rolling update may have…
git:20261005.5100bf0 · audit A · 5 stars
express-prisma-coolify-image SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/express-prisma-coolify-image/SKILL.md · Package an Express and Prisma API as a runtime-only image that migrates its Postgres database at start. Use when…
git:20261005.5100bf0 · audit A · 5 stars
ghcr-coolify-pipeline SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/ghcr-coolify-pipeline/SKILL.md · Write the single GitHub Actions workflow that takes a repository from pull request to production through GHCR and…
git:20261005.5100bf0 · audit A · 5 stars
live-domain-cutover SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/live-domain-cutover/SKILL.md · Move a live domain from one host to another without downtime or lost sessions, with a rehearsal, a timed DNS switch, a…
git:20261005.5100bf0 · audit A · 5 stars
nextjs-coolify-image SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/nextjs-coolify-image/SKILL.md · Package a Next.js app as a runtime-only container image with a health probe and a fast shutdown. Use when…
git:20261005.5100bf0 · audit A · 5 stars
proxy-client-address SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/proxy-client-address/SKILL.md · Forward the real client address from a server-side proxy to a backend without trusting forgeable headers. Use when an…
git:20261005.5100bf0 · audit A · 5 stars
vps-ops-toolkit SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/deploy/skills/vps-ops-toolkit/SKILL.md · Install host operations on a VPS, with a cron health check that alerts on change, restore-verified encrypted database…
git:20261005.5100bf0 · audit A · 5 stars
adr-writing SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/docs/skills/adr-writing/SKILL.md · Write Architecture Decision Records that a future engineer can act on: a numbered, immutable record with the context…
git:20260921.b628018 · audit A · 5 stars
openapi-spec SKILL.md skill
khaledsaeed18/dotclaude · .claude-plugin/plugins/docs/skills/openapi-spec/SKILL.md · Write, generate, or review an OpenAPI 3.1 specification for an HTTP API so that it is accurate to the implementation…
git:20260921.b628018 · audit A · 5 stars

Every file in khaledsaeed18/dotclaude

Other files named db-migration-safety

db-migration-safety SKILL.md skill
khaledsaeed18/dotclaude · skills/engineering/db-migration-safety/SKILL.md · Review or write a database schema migration with production safety as the bar, checking locks, table rewrites…
git:20260921.4ccfb75 · audit A · 5 stars

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