migrate-create

Original：🇺🇸 English

Translated

Create a new sequentially numbered database migration with up/down SQL files

3installs

Sourceruvnet/ruflo

Added on2026-05-03

NPX Install

npx skill4agent add ruvnet/ruflo migrate-create

SKILL.md Content

View Translation Comparison →

Migrate Create

Generate a new database migration with sequential numbering and up/down SQL file pair.

When to use

When you need to create a new database migration for schema changes such as creating tables, adding columns, creating indexes, or modifying constraints.

Steps

Determine next number -- use
```
Glob
```
to scan the migrations directory for existing migration files and find the highest number, then increment by 1 (zero-pad to 3 digits)
Select template -- based on the
```
<name>
```
, choose the appropriate SQL template:
- Names starting with
```
create_
```
  -> CREATE TABLE template
- Names starting with
```
add_
```
  -> ALTER TABLE ADD COLUMN template
- Names starting with
```
drop_
```
  -> DROP with safety checks
- Names containing
```
index
```
  -> CREATE INDEX template
- Other -> generic migration template with placeholder comments
Generate up migration -- write
```
NNN_<name>.up.sql
```
with the appropriate SQL using IF NOT EXISTS for idempotency
Generate down migration -- write
```
NNN_<name>.down.sql
```
with the reverse operation using IF EXISTS
Search patterns -- call
```
mcp__claude-flow__agentdb_pattern-search
```
to find similar past migrations for reference
Store metadata -- call
```
mcp__claude-flow__agentdb_hierarchical-store
```
to record the migration in
```
migrations
```
namespace with number, name, status (pending), and file paths
Report -- display: migration number, file paths created, template used, any similar past migrations found

CLI alternative

bash

npx @claude-flow/cli@latest memory store --namespace migrations --key "migration-NNN_NAME" --value '{"number": NNN, "name": "NAME", "status": "pending"}'