mcpField
M
migrate-create

migrate-create

github.com/ruvnetData & databases80.0k729 installsUpdated today
Repository

About migrate-create

A skill for creating sequentially numbered database migrations as paired up/down SQL files. It selects a template based on the migration name and records migration metadata and past-pattern findings.

Key features

  1. 01Sequential migration numbering
  2. 02Name-based SQL template selection
  3. 03Up/down SQL file generation
  4. 04Past-pattern search and metadata storage

Use cases

  1. 01Creating tables or modifying schema
  2. 02Adding columns or indexes
  3. 03Preparing reversible database changes

MCP support

Uses Ruflo pattern search to find similar migrations and stores migration metadata in the migrations namespace.

Install

Copy the command and run it in a terminal.

$npx skills add https://github.com/ruvnet/ruflo --skill migrate-create

After installing, type/migrate-createin Claude Code to confirm it loaded.

Details

From the project README

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

  1. 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)
  2. 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
  3. Generate up migration -- write NNN_<name>.up.sql with the appropriate SQL using IF NOT EXISTS for idempotency
  4. Generate down migration -- write NNN_<name>.down.sql with the reverse operation using IF EXISTS
  5. Search past patterns -- call mcp__plugin_ruflo-core_ruflo__agentdb_pattern-search (ReasoningBank-routed; don't pass a namespace argument — pattern-* tools ignore it).
  6. Store metadata -- call mcp__plugin_ruflo-core_ruflo__memory_store --namespace migrations to record the migration with number, name, status (pending), and file paths. The memory_* tool family routes by namespace; agentdb_hierarchical-* does NOT (it routes by tier working|episodic|semantic), so use memory_* here. See ruflo-agentdb ADR-0001 §"Namespace convention".
  7. Report -- display: migration number, file paths created, template used, any similar past migrations found

CLI alternative

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

Comments

Markdown supported