Sql to osc

Skill ComeOnOliver/skillshub/skills/aiskillstore/marketplace/dennisliuck/sql-to-osc

🧠 The right skill, one API call. AI agent skills registry with token-efficient skill resolution. 5,000+ skills from 500+ top repos.

Install

npx -y skills add ComeOnOliver/skillshub --skill sql-to-osc

Assembled from the repository path, not quoted from the project. Check it against their README if it does not work.

What its author says it does

Copied from the file, not written here

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.

SKILL.md

2.1 KB, 546 tokens by cl100k_base, as published. Nobody here has run it

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}

Gives 0 of the 12 instructions most databases sql skills give in 546 tokens

Counted across 589 of the 662 authors here whose files we hold, read 2026-08-06

use parameterized queriesin 36 of 589, across 32 files
use timestamptz for timestampsin 30 of 589, across 12 files
create indexes concurrentlyin 29 of 589, across 23 files
index foreign keysin 28 of 589, across 17 files
use numeric type for moneyin 25 of 589, across 8 files
select only required columnsin 24 of 589, across 19 files
use cursor pagination instead of OFFSETin 23 of 589, across 15 files
add indexes manually on foreign key columnsin 22 of 589, across 11 files
read individual rule files for detailed explanationsin 18 of 589, across 4 files
configure connection poolingin 18 of 589, across 16 files
put equality columns before range columns in indexesin 17 of 589, across 9 files
normalize to third normal formin 17 of 589, across 8 files

Grouped from the skills themselves: near-identical wordings counted once, and counted by distinct author, so one author publishing three of these counts once. Length counted with cl100k_base; the agent that loads this file may tokenize it differently.