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

データベース管理

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.

主な機能

Intelligent SQL syntax normalization (e.g., NULL to DEFAULT NULL)
Tab-separated OSC format generation
0 GitHub stars
Automated Flyway SQL parsing and transformation
Batch processing of multiple ALTER and INDEX statements
Automatic file generation with standard timestamp naming conventions

ユースケース

Converting local Flyway migrations to production-ready OSC scripts
Standardizing database schema changes across multiple microservices
Automating the generation of osc.txt files for CI/CD pipelines

概要

主な機能

Intelligent SQL syntax normalization (e.g., NULL to DEFAULT NULL)
Tab-separated OSC format generation
0 GitHub stars
Automated Flyway SQL parsing and transformation
Batch processing of multiple ALTER and INDEX statements
Automatic file generation with standard timestamp naming conventions

ユースケース

Converting local Flyway migrations to production-ready OSC scripts
Standardizing database schema changes across multiple microservices
Automating the generation of osc.txt files for CI/CD pipelines