# Create Migration

> Create new SQL migration files for multiple database dialects (sqlite, mysql, etc.)

- Skill: `c9s/create-migration` (Agent Skill)
- Install (CLI): `npx skillmds@latest add c9s/create-migration`
- Raw SKILL.md: https://api.skillmd.com/api/skills/c9s/create-migration/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Data & Analytics
- Author: c9s (https://skillmd.com/u/c9s)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/c9s/create-migration

---


Create new migration files named `$ARGUMENTS` for all configured database dialects.

Run the wrapper script:

```bash
bash scripts/create-migration.sh $ARGUMENTS
```

If the script is not found, fall back to finding all `rockhopper_*.yaml` config files and running `rockhopper --config <config> create --type sql $ARGUMENTS` for each.

After creation, list the newly created files and remind the user to edit all migration files since each dialect may need different SQL syntax.

## Migration file format reference

```sql
-- @package packagename
-- +up
CREATE TABLE example (id INT PRIMARY KEY);

-- +down
DROP TABLE example;
```

For multi-statement blocks, use `-- +begin` / `-- +end`. Use `-- !txn` to disable transaction wrapping.