Execute qualquer Skill no Manus
com um clique

Execute qualquer Skill no Manus com um clique

Começar

create-migration

Estrelas3

Forks2

Atualizado21 de maio de 2026 às 08:52

Create versioned SQL migration files for database schema changes, following project conventions

Instalação

Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.

Executar no Manus

Fonte

lucaswang420

lucaswang420/authforge

Abrir repositório GitHub Ver repositórios do creator

Download

Executar no Manus

Ocupações relacionadasSOC

Baseado na classificação ocupacional SOC

Arquitetos de banco de dadosInformática e Matemática·SOC 15-1243

SKILL.md

readonly

name	create-migration
description	Create versioned SQL migration files for database schema changes, following project conventions
disable-model-invocation	true

SQL Migration Skill

Create versioned SQL migration files for the OAuth2 database schema.

When to Use

When adding, modifying, or dropping database tables/columns/indexes. Triggered by /create-migration.

Migration Naming

Pattern: OAuth2Server/sql/migrations/V{NNN}__descriptive_name.sql

Current latest: V018__webauthn.sql -- next migration starts at V019.

Check existing migrations before creating:

ls -la OAuth2Server/sql/migrations/

File Template

-- Migration: V{NNN}__{description}
-- Created: {date}
-- Purpose: {why this change is needed}

-- === UP ===
-- Forward migration: apply changes
{SQL statements here}

-- === DOWN ===
-- Rollback migration: revert changes
-- (optional but recommended for production)
{ROLLBACK SQL here}

Validation Checklist

Before finalizing, verify:

Naming: Follows V{NNN}__snake_case.sql pattern
Numbering: Next number after latest existing migration
Idempotent: Uses IF NOT EXISTS / IF EXISTS where appropriate
No data loss: ALTER COLUMN preserves existing data; DROP has DOWN section
Schema consistency: Matches ORM model expectations in model.json
CMakeLists: No update needed (migrations are loaded at runtime by SchemaManager)

Common Patterns

Add Table

CREATE TABLE IF NOT EXISTS new_table (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Add Column

ALTER TABLE existing_table ADD COLUMN IF NOT EXISTS new_column VARCHAR(50);

Add Index

CREATE INDEX IF NOT EXISTS idx_table_column ON existing_table(column);

Add Foreign Key

ALTER TABLE child_table
    ADD CONSTRAINT fk_child_parent
    FOREIGN KEY (parent_id) REFERENCES parent_table(id) ON DELETE CASCADE;

After Creating

Test the migration: /build-and-test or run SchemaManager
If ORM models need updating: /orm-gen
Update model.json if new tables added
Update OpenAPI spec if API affected: /openapi-update

Mais deste repositório

mesmo repositório

wechat-notify

lucaswang420/authforge

通过微信机器人发送通知消息（文本、图片、文件、视频）

2026-07-013

orm-gen

lucaswang420/authforge

重新生成 Drogon ORM 模型类（基于当前数据库表结构）

2026-06-043

build-and-test

lucaswang420/authforge

构建和测试C++ OAuth2后端，包含正确的依赖管理

2026-05-263

db-reset

lucaswang420/authforge

重置测试数据库（清空并重新初始化所有表结构和数据）

2026-05-263

e2e-test

lucaswang420/authforge

执行OAuth2系统的完整端到端(E2E)测试，验证用户登录、授权码流程、token交换、RBAC权限控制和受保护API访问的完整功能。当用户需要在代码变更后验证整个OAuth2认证流程、测试用户登录和权限管理、验证修复后的安全功能、或在生产部署前进行完整的功能验证时使用此技能。

2026-05-263

docker-integration-test

lucaswang420/authforge

在Docker Compose环境中执行OAuth2系统的完整集成测试和健康检查。当用户需要在代码变更后验证功能、运行端到端测试、检查Docker环境健康状态、或需要验证整个OAuth2系统（前端+后端+数据库+缓存）的集成时使用此技能。确保在Docker环境中测试所有组件的集成，包括健康检查、OAuth2流程、API端点、数据库连接、Redis缓存和前后端通信。

2026-05-223

name	create-migration
description	Create versioned SQL migration files for database schema changes, following project conventions
disable-model-invocation	true

SQL Migration Skill

Create versioned SQL migration files for the OAuth2 database schema.

When to Use

When adding, modifying, or dropping database tables/columns/indexes. Triggered by /create-migration.

Migration Naming

Pattern: OAuth2Server/sql/migrations/V{NNN}__descriptive_name.sql

Current latest: V018__webauthn.sql -- next migration starts at V019.

Check existing migrations before creating:

ls -la OAuth2Server/sql/migrations/

File Template

-- Migration: V{NNN}__{description}
-- Created: {date}
-- Purpose: {why this change is needed}

-- === UP ===
-- Forward migration: apply changes
{SQL statements here}

-- === DOWN ===
-- Rollback migration: revert changes
-- (optional but recommended for production)
{ROLLBACK SQL here}

Validation Checklist

Before finalizing, verify:

Naming: Follows V{NNN}__snake_case.sql pattern
Numbering: Next number after latest existing migration
Idempotent: Uses IF NOT EXISTS / IF EXISTS where appropriate
No data loss: ALTER COLUMN preserves existing data; DROP has DOWN section
Schema consistency: Matches ORM model expectations in model.json
CMakeLists: No update needed (migrations are loaded at runtime by SchemaManager)

Common Patterns

Add Table

CREATE TABLE IF NOT EXISTS new_table (
    id SERIAL PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Add Column

ALTER TABLE existing_table ADD COLUMN IF NOT EXISTS new_column VARCHAR(50);

Add Index

CREATE INDEX IF NOT EXISTS idx_table_column ON existing_table(column);

Add Foreign Key

ALTER TABLE child_table
    ADD CONSTRAINT fk_child_parent
    FOREIGN KEY (parent_id) REFERENCES parent_table(id) ON DELETE CASCADE;

After Creating

Test the migration: /build-and-test or run SchemaManager
If ORM models need updating: /orm-gen
Update model.json if new tables added
Update OpenAPI spec if API affected: /openapi-update