
sql-to-osc
將 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-twRun it inside Claude Code after adding the marketplace with /plugin marketplace add DennisLiuCk/claude-plugin-marketplace.
Contents
Discovered from sourceSkills 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};
| 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
USEandALTER TABLEwrappers - Convert
NULL→DEFAULT NULL - Convert
CREATE INDEX...ON table→ADD INDEX... - Uppercase data types
- Remove
- 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}
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- agent-sdk-devv1.0.0
- claude-opus-4-5-migrationv1.0.0
- code-reviewv1.0.0
- code-simplifierv1.0.0
- commit-commandsv1.0.0
- community-code-reviewv1.0.0
- explanatory-output-stylev1.0.0
- feature-devv1.0.0
- frontend-designv1.0.0
- hookifyv0.1.0
- issue-reviewv1.0.0
- java-code-simplifierv1.0.0
- learning-output-stylev1.0.0
- legacy-analyzerv1.4.0
- plugin-devv1.1.0
- pr-review-toolkitv1.0.0
- ralph-loopv1.0.0
- security-guidancev1.0.0
- skill-creatorv1.0.0