migrate-create
Create a new sequentially numbered database migration with up/down SQL files
- License 许可
- MIT
- 最近更新
- 2026-10-08
- Stars
- ★ 11
- Forks
- 3
01 前言 Front Matter
- name
- migrate-create
- description
- Create a new sequentially numbered database migration with up/down SQL files
- allowed-tools
- Read Write Glob Bash mcp__plugin_ruflo-core_ruflo__memory_store mcp__plugin_ruflo-core_ruflo__memory_search mcp__plugin_ruflo-core_ruflo__agentdb_pattern-search
- argument-hint
- <name>
03 SKILL.md 正文
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
Globto 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
- Names starting with
- Generate up migration -- write
NNN_<name>.up.sqlwith the appropriate SQL using IF NOT EXISTS for idempotency - Generate down migration -- write
NNN_<name>.down.sqlwith the reverse operation using IF EXISTS - Search past patterns -- call
mcp__plugin_ruflo-core_ruflo__agentdb_pattern-search(ReasoningBank-routed; don't pass anamespaceargument — pattern-* tools ignore it). - Store metadata -- call
mcp__plugin_ruflo-core_ruflo__memory_store --namespace migrationsto record the migration with number, name, status (pending), and file paths. Thememory_*tool family routes by namespace;agentdb_hierarchical-*does NOT (it routes by tierworking|episodic|semantic), so usememory_*here. See ruflo-agentdb ADR-0001 §"Namespace convention". - 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"}'
04 同仓库更多 Skills
obsidian-clipper-template-creator
Guide for creating templates for the Obsidian Web Clipper. Use when you want to create a new clipping template, understand available variables, or format clipped content.
obsidian-clipper-template-creator
Guide for creating templates for the Obsidian Web Clipper. Use when you want to create a new clipping template, understand available variables, or format clipped content.
python-api
Programmatic Object-Detection-Metrics API guidance for BoundingBox, BoundingBoxes, Evaluator, enums, coordinate conversion, AP/mAP semantics, and source-style import diagnostics.
file-evaluation
Folder-based PASCAL VOC AP/mAP evaluation from ground-truth and detection text files.
object-detection-metrics
Guides legacy Object-Detection-Metrics PASCAL VOC AP/mAP evaluation from detection text folders and direct Python API classes.
nx-workspace-patterns
Configure and optimize Nx monorepo workspaces. Use when setting up Nx, configuring project boundaries, optimizing build caching, or implementing affected commands.