Skill

sql-to-osc

SQL to OSC (Online Schema Change) conversion expert for Flyway migration scripts. Use when: (1) Converting SQL migration files to OSC format, (2) User mentions "OSC", "轉換 OSC", "osc.txt", or "Online Schema Change", (3) Working with Flyway ALTER TABLE/CREATE INDEX statements that need OSC conversion.

npx claudepluginhub dennisliuck/claude-plugin-marketplace --plugin sql-to-osc

Popularity

Parent stars

Parent forks

Invocation

How this skill is triggered — by the user, by Claude, or both

Slash command

/sql-to-osc:sql-to-osc

User invocable

Model invocable

Inline context

Default effort

Context Preview

The summary Claude sees in its skill listing — used to decide when to auto-load this skill

Convert Flyway SQL migration scripts to OSC format following project conventions.

SKILL.md

76 lines · ~528 tokens

Similar Skills

memstack-development-migration-planner

332

Plans safe database schema migrations with zero-downtime strategies, rollback procedures, and data validation for PostgreSQL, MySQL, and SQLite.

memstack

flux-migrate

Build zero-downtime database migrations — forward SQL, rollback SQL, deployment sequence. Use when asked to "write migration", "schema change", "add column", "rename table", "drop column", or "migrate safely".

tonone-flux

Generates migration files with rollback scripts, detects breaking schema changes, and validates query parameterization. Supports Prisma, Django ORM, SQLAlchemy, PostgreSQL, MySQL.

1 file

rune

Stats

LanguagePython

Parent stars20

Parent forks4

MaintenanceFair

Last CommitDec 12, 2025

Actions

View Source View Plugin View on GitHub View README

Help us improve

Share bugs, ideas, or general feedback.

Stats

Actions

Help us improve

Share bugs, ideas, or general feedback.

sql-to-osc

SQL to OSC Conversion Expert

Convert Flyway SQL migration scripts to OSC format following project conventions.

Quick Reference

OSC Format: {database}<TAB>{table}<TAB>{operations};

SQL

OSC

USE db;

Remove (db in column 1)

ALTER TABLE tbl

Remove (tbl in column 2)

NULL

DEFAULT NULL

CREATE INDEX idx ON tbl (col)

ADD INDEX idx (col)

varchar

VARCHAR

Multiple operations

Comma-joined, no space

Conversion Workflow

Read source SQL from src/main/resources/db/migration/

Parse statements: Extract database, table, operations

Transform:

Remove USE and ALTER TABLE wrappers
Convert NULL → DEFAULT NULL
Convert CREATE INDEX...ON table → ADD INDEX...
Uppercase data types

Format output: {db}\t{table}\t{op1},{op2},...;

Write to src/main/resources/db/osc/osc-{YYYYMMDD}.txt (e.g., osc-20251212.txt)

Output Requirements

Encoding: UTF-8 (no BOM)

Line ending: LF (\n)

Separator: TAB (\t) between columns

Operations: Comma (,) joined, NO space after comma

Line ending: Semicolon (;)

Example

Input (V1.0__alter_my_table.sql):

USE mydb; ALTER TABLE MY_TABLE ADD COLUMN NEW_COL bigint(20) NULL AFTER EXISTING_COL; CREATE INDEX MY_TABLE_NEW_COL_IDX ON MY_TABLE (NEW_COL);

Output (osc-{YYYYMMDD}.txt):

mydb MY_TABLE ADD COLUMN NEW_COL BIGINT(20) DEFAULT NULL AFTER EXISTING_COL,ADD INDEX MY_TABLE_NEW_COL_IDX (NEW_COL);

Conversion Summary Template

✓ 轉換完成來源: {source_file} 輸出: src/main/resources/db/osc/osc-{YYYYMMDD}.txt 影響資料表: {tables} 操作統計: - ADD COLUMN: {count} - ADD INDEX: {count} - MODIFY COLUMN: {count}

SQL to OSC Conversion Expert

Convert Flyway SQL migration scripts to OSC format following project conventions.

Quick Reference

OSC Format: {database}<TAB>{table}<TAB>{operations};

SQL	OSC
`USE db;`	Remove (db in column 1)
`ALTER TABLE tbl`	Remove (tbl in column 2)
`NULL`	`DEFAULT NULL`
`CREATE INDEX idx ON tbl (col)`	`ADD INDEX idx (col)`
`varchar`	`VARCHAR`
Multiple operations	Comma-joined, no space

Conversion Workflow

Read source SQL from src/main/resources/db/migration/
Parse statements: Extract database, table, operations
Transform:
- Remove USE and ALTER TABLE wrappers
- Convert NULL → DEFAULT NULL
- Convert CREATE INDEX...ON table → ADD INDEX...
- Uppercase data types
Format output: {db}\t{table}\t{op1},{op2},...;
Write to src/main/resources/db/osc/osc-{YYYYMMDD}.txt (e.g., osc-20251212.txt)

Output Requirements

Encoding: UTF-8 (no BOM)
Line ending: LF (\n)
Separator: TAB (\t) between columns
Operations: Comma (,) joined, NO space after comma
Line ending: Semicolon (;)

Example

Input (V1.0__alter_my_table.sql):

USE mydb;

ALTER TABLE MY_TABLE
    ADD COLUMN NEW_COL bigint(20) NULL AFTER EXISTING_COL;

CREATE INDEX MY_TABLE_NEW_COL_IDX ON MY_TABLE (NEW_COL);

Output (osc-{YYYYMMDD}.txt):

mydb	MY_TABLE	ADD COLUMN NEW_COL BIGINT(20) DEFAULT NULL AFTER EXISTING_COL,ADD INDEX MY_TABLE_NEW_COL_IDX (NEW_COL);

Conversion Summary Template

✓ 轉換完成

來源: {source_file}
輸出: src/main/resources/db/osc/osc-{YYYYMMDD}.txt

影響資料表: {tables}
操作統計:
  - ADD COLUMN: {count}
  - ADD INDEX: {count}
  - MODIFY COLUMN: {count}