將 Flyway SQL 遷移腳本轉換為 OSC (Online Schema Change) 格式,支援 ALTER TABLE 和 CREATE INDEX 語句的自動轉換

version
1.0.0
GitHub stars
29

Install

/plugin install sql-to-osc@claude-plugin-marketplace-zh-tw

Run it inside Claude Code after adding the marketplace with /plugin marketplace add DennisLiuCk/claude-plugin-marketplace.

Contents

Discovered from source

Skills 1

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};

SQLOSC
USE db;Remove (db in column 1)
ALTER TABLE tblRemove (tbl in column 2)
NULLDEFAULT NULL
CREATE INDEX idx ON tbl (col)ADD INDEX idx (col)
varcharVARCHAR
Multiple operationsComma-joined, no space

Conversion Workflow

  1. Read source SQL from src/main/resources/db/migration/
  2. Parse statements: Extract database, table, operations
  3. Transform:
    • Remove USE and ALTER TABLE wrappers
    • Convert NULL → DEFAULT NULL
    • Convert CREATE INDEX...ON table → ADD INDEX...
    • Uppercase data types
  4. Format output: {db}\t{table}\t{op1},{op2},...;
  5. 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}

Sponsors

Details

Marketplace
DennisLiuCk/claude-plugin-marketplace
Source
plugins/sql-to-osc
Author
Dennis Liu
Category
Productivity

More from DennisLiuCk/claude-plugin-marketplace

All 20