Skip to main content

Migrate Create

Skill Verified Active

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

Purpose

To streamline the process of creating database schema changes by automating migration numbering, SQL file generation, and metadata tracking.

Features

  • Generates sequentially numbered migrations
  • Creates up/down SQL files
  • Selects SQL templates based on migration name
  • Stores migration metadata
  • Automates file path scanning and numbering

Use Cases

  • When needing to create a new database migration for schema changes like creating tables or adding columns.
  • When ensuring consistent, sequential numbering for database migrations.
  • When needing to generate both forward and backward SQL scripts for each migration.
  • When automating the process of adding new migrations to a project.

Non-Goals

  • Executing migrations against a database
  • Managing or applying existing migrations
  • Validating the correctness of the generated SQL syntax beyond basic templating
  • Providing a full schema migration framework

Workflow

  1. Scan migration directory to determine next sequential number
  2. Select appropriate SQL template based on migration name
  3. Generate 'up' migration SQL with idempotency checks
  4. Generate 'down' migration SQL with idempotency checks
  5. Search for similar past migration patterns
  6. Store migration metadata using MCP
  7. Report on created files and patterns found

Practices

  • Database Migration Management
  • Code Generation
  • Developer Workflow Automation

Prerequisites

  • Access to file system for migration directory
  • Claude Code environment with necessary tools (Glob, Bash, MCP)

Installation

First, add the marketplace

/plugin marketplace add ruvnet/ruflo
/plugin install ruflo-migrations@ruflo

Quality Score

Verified
99 /100
Analyzed about 17 hours ago

Trust Signals

Last commitabout 18 hours ago
Stars50.2k
LicenseMIT
Status
View Source

Similar Extensions

Migrate Validate

100

Validate pending migrations for foreign key consistency, rollback safety, and best practices

Skill
ruvnet

Dsql

100

Build with Aurora DSQL — manage schemas, execute queries, handle migrations, diagnose query plans, and develop applications with a serverless, distributed SQL database. Covers IAM auth, multi-tenant patterns, MySQL-to-DSQL migration, DDL operations, query plan explainability, and SQL compatibility validation. Triggers on phrases like: DSQL, Aurora DSQL, create DSQL table, DSQL schema, migrate to DSQL, distributed SQL database, serverless PostgreSQL-compatible database, DSQL query plan, DSQL EXPLAIN ANALYZE, why is my DSQL query slow.

Skill
awslabs

Cli Creator

100

Build a composable CLI for Codex from API docs, an OpenAPI spec, existing curl examples, an SDK, a web app, an admin tool, or a local script. Use when the user wants Codex to create a command-line tool that can run from any repo, expose composable read/write commands, return stable JSON, manage auth, and pair with a companion skill.

Skill
openai

Sql Optimization

100

Universal SQL performance optimization assistant for comprehensive query tuning, indexing strategies, and database performance analysis across all SQL databases (MySQL, PostgreSQL, SQL Server, Oracle). Provides execution plan analysis, pagination optimization, batch operations, and performance monitoring guidance.

Skill
github

DBHub Database Query Guide

100

Guide for querying databases through DBHub MCP server. Use this skill whenever you need to explore database schemas, inspect tables, or run SQL queries via DBHub's MCP tools (search_objects, execute_sql). Activates on any database query task, schema exploration, data retrieval, or SQL execution through MCP — even if the user just says "check the database" or "find me some data." This skill ensures you follow the correct explore-first workflow instead of guessing table structures.

Skill
bytebase

V3 Memory Unification

99

Unify 6+ memory systems into AgentDB with HNSW indexing for 150x-12,500x search improvements. Implements ADR-006 (Unified Memory Service) and ADR-009 (Hybrid Memory Backend).

Skill
ruvnet

© 2025 SkillRepo · Find the right skill, skip the noise.