Agent skill · software engineering · 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.
Why this skill is useful
Adds a specific conversion workflow and format for Flyway migration scripts to OSC that the AI wouldn't reliably generate on its own.
What it needs
About 1k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
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 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.0altermytable.sql): Output (osc-{YYYYMMDD}.txt): Conversion Summary Template
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/sql-to-osc