Does it support multiple SQL operations in one file?

Yes, it can parse multiple ALTER TABLE or CREATE INDEX statements and join them into a single OSC entry per table.

Does it handle data type formatting?

Yes, it automatically converts data types to uppercase and transforms standard NULL constraints to 'DEFAULT NULL' to match OSC requirements.

What is the primary format used by the SQL to OSC skill?

The skill generates a tab-separated format consisting of the database name, table name, and a comma-separated list of operations ending in a semicolon.

Where does the skill output the converted files?

Converted files are saved to the src/main/resources/db/osc/ directory with a timestamp-based filename like osc-YYYYMMDD.txt.

Is this skill compatible with Flyway?

Yes, it is specifically designed to work with Flyway migration scripts located in the standard resources directory.

SQL to OSC Converter

Name: SQL to OSC Converter
Author: DennisLiuCk

byDennisLiuCk

0•

데이터베이스 관리

Converts Flyway SQL migration scripts into Online Schema Change (OSC) format for seamless, zero-downtime database updates.

This skill automates the transformation of standard SQL migration files into the specialized Online Schema Change (OSC) format required for production database deployments. It intelligently parses Flyway scripts, extracts database and table metadata, and re-formats ALTER TABLE and CREATE INDEX statements into the specific tab-separated structure used by OSC tools. By standardizing data types and consolidating multiple operations into a single line, it ensures project-wide consistency and reduces the risk of manual formatting errors during the migration lifecycle.

주요 기능

01Intelligent SQL syntax normalization (e.g., NULL to DEFAULT NULL)

02Tab-separated OSC format generation

030 GitHub stars

04Automated Flyway SQL parsing and transformation

05Batch processing of multiple ALTER and INDEX statements

06Automatic file generation with standard timestamp naming conventions

사용 사례

01Converting local Flyway migrations to production-ready OSC scripts

02Standardizing database schema changes across multiple microservices

03Automating the generation of osc.txt files for CI/CD pipelines

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add dennisliuck/claude-plugin-marketplace sql-to-osc

For use in Claude.ai and ChatGPT

Download Skill