How do I install the SQL To Osc skill?

Run npx skillmds@latest add aiskillstore/sql-to-osc in your terminal (requires Node.js), paste this page's agent-chat prompt into Claude, Cursor, or any MCP-connected agent, or download the SKILL.md file and copy it into your agent's skills directory.

Is SQL To Osc safe to use?

This skill has not completed SkillMD's automated safety review yet. Capability flags: docs only. SkillMD never runs a skill's scripts for you; review the SKILL.md before installing.

Which AI agents work with SQL To Osc?

This skill is tagged as working with Claude Code, Claude.ai, OpenAI Codex. SKILL.md is an open format, so most agents that read a skills directory can load it too.

Is SQL To Osc free to use?

Yes. Installing skills from SkillMD is free, and the skill stays under its author's original license.

Who published SQL To Osc?

aiskillstore (@aiskillstore) published this skill. Their other Agent Skills are listed on their SkillMD profile.

SQL To Osc by aiskillstore — Agent Skill

Name: SQL To Osc
Rating: 4.5 (4 reviews)
Author: aiskillstore

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.

aiskillstore Updated Sep 8, 2026

File contents

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}

---name: sql-to-oscdescription: 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.---# SQL to OSC Conversion ExpertConvert 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 Workflow1. **Read source SQL** from `src/main/resources/db/migration/`2. **Parse statements**: Extract database, table, operations3. **Transform**: - Remove `USE` and `ALTER TABLE` wrappers - Convert `NULL` → `DEFAULT NULL` - Convert `CREATE INDEX...ON table` → `ADD INDEX...` - Uppercase data types4. **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`):```sqlUSE 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}```

Frequently asked questions