# Mm

> Create and deploy Prisma database migrations. Use when schema.prisma changes, migration guard fires, or you need to run prisma migrate. NOT for schema design — only for generating and deploying migrations.

- Skill: `majiayu000/mm-2` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/mm-2`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/mm-2/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: DevOps & Infra
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/mm-2

---


# Command: Make Migrations (`/mm`)

Purpose: Create and deploy Prisma migrations for the backend when the schema changes.

## When to use
- You modified `backend/prisma/schema.prisma` and need to generate a migration.
- The pre-commit migration guard indicates a missing migration.

## What it does
1) Generate a migration (files only) with a given or auto-generated name
2) Deploy all pending migrations to the database
3) Regenerate Prisma Client

## Usage

```bash
# From repo root — auto name: auto_YYYYMMDD_HHMMSS
npm --prefix backend run prisma:migrate:dev -- --name "auto_$(date +%Y%m%d_%H%M%S)" --create-only

# Deploy and regenerate client
npm --prefix backend run prisma:migrate:deploy
npm --prefix backend run prisma:generate
```

Or with a custom name:

```bash
npm --prefix backend run prisma:migrate:dev -- --name my_change --create-only
npm --prefix backend run prisma:migrate:deploy
npm --prefix backend run prisma:generate
```

## Requirements
- Environment variables configured as per `backend/docs/migration-structure.md`:
  - `DATABASE_URL` (pooled)
  - `DIRECT_URL` (direct for migrations)
  - `SHADOW_DATABASE_URL` (shadow schema/DB)

## Troubleshooting
- **Generation fails** — Fix schema errors and re-run.
- **Shadow DB error** — Check `SHADOW_DATABASE_URL` in `.env`. Must be a separate DB, not the main one.
- **Migration drift** — Run `npx prisma migrate diff` to inspect. May need `prisma migrate resolve`.
- **Dirty database** — If dev DB has manual changes, consider `prisma migrate reset` (destroys data).

## See also
- Full migration docs: `backend/docs/migration-structure.md`
- Schema file: `backend/prisma/schema.prisma`

## Notes
- This command is non-interactive and safe for CI usage.