Is sql-to-osc safe to install?

SaferSkills independently audited sql-to-osc (Agent Skill) and scored it 100/100 (green). The audit ran 55 deterministic rules across Security, Supply Chain, Maintenance, Transparency, and Community; it found 0 high-severity and 0 lower-severity findings. The full rule-by-rule trace and per-finding evidence are below. Free, methodology-open.

CategoryWeightCategory scoreContribution

Securityprompt, exec, net, exfil, eval

35%

100

35.0 pts

Supply chainhash, typosquat, maintainer, lockfile

20%

100

20.0 pts

Maintenancestaleness, pinning, CI

15%

100

15.0 pts

TransparencySKILL.md, perms, README

15%

100

15.0 pts

Communityinstalls, verify, response

15%

100

15.0 pts

Findings & checks · 0 flagged

Securityscore 100 · 0 findings

✓—All security checks passedNo findings in this category for the latest scan.pass

Supply chainscore 100 · 0 findings

✓—All supply chain checks passedNo findings in this category for the latest scan.pass

Maintenancescore 100 · 0 findings

✓—All maintenance checks passedNo findings in this category for the latest scan.pass

Transparencyscore 100 · 0 findings

✓—All transparency checks passedNo findings in this category for the latest scan.pass

Communityscore 100 · 0 findings

✓—All community checks passedNo findings in this category for the latest scan.pass

The primary manifest — the file an agent reads to learn what this artifact does.

plugins/sql-to-osc/skills/sql-to-osc/SKILL.md · 1 file

plugins/sql-to-osc/skills/sql-to-osc/SKILL.md2.1 KB · Markdown

name: sql-to-osc

description: |

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

sql-to-osc— agent skill

Is sql-to-osc safe to install?

SQL to OSC Conversion Expert

Quick Reference

Conversion Workflow

Output Requirements

Example

Conversion Summary Template

Audit the pieces. Scan the whole. Decide.