Database Migrations
vanara-agents/skillsHow to write safe, reversible, zero-downtime database schema migrations — additive-first changes, the expand/migrate/contract pattern, batched backfills, concurrent index builds, safe NOT NULL, rollbacks, and the locking pitfalls that cause outages. A deep reference with runnable checks.
At a glance
git clone --depth 1 https://github.com/vanara-agents/skills
cp -r skills/skills/database-migrations ~/.claude/skills/database-migrations
Setup, runtime and requirements describe vanara-agents/skills, the repo this skill ships in.
Also in vanara-agents/skills
View the repoImplement correct, fast API pagination — cursor vs offset trade-offs, opaque cursor encoding, stable sort keys, page-size limits, total-coun...
Deep reference for caching — what to cache, cache-aside vs read/write-through/write-behind, TTLs with jitter, eviction (LRU/LFU/FIFO), inval...
Write Conventional Commits — the type(scope)!: subject + body + footer spec — so history is readable and changelogs and SemVer bumps can be...
How to handle errors explicitly and consistently across an app — validate at boundaries, classify operational vs programmer errors, add cont...
Run git collaboration that scales — trunk-based vs git-flow decided by deploy cadence, branch protection and required checks, PR sizing and...
A deep prevention reference for the OWASP Top 10 web risks — broken access control, injection, crypto failures, insecure design, SSRF and mo...
A deep, practical guide to engineering reliable LLM prompts — role/context, instructions, few-shot, structured output, chain-of-thought, del...
How to write a README that gets a project understood and running fast — lead with what/why, a 60-second quickstart, then usage, config, cont...
Improve code structure without changing behavior — the discipline of small, named, test-backed moves. Extract function/variable, inline, ren...
Conventions for designing clean, consistent, evolvable REST APIs — resource modeling, HTTP semantics, status codes, pagination, filtering, e...
Handle secrets safely across the lifecycle — keep them out of source, load from env or a secret manager, scope to least privilege, encrypt i...
Implement authentication securely — authentication vs authorization, password hashing (argon2id/bcrypt), sessions vs JWT (storage, expiry, r...