How does this prevent 'vibe coding'?

It enforces a disciplined, spec-driven approach where every schema change is documented, tested, and reversible rather than applied haphazardly.

Why does the skill emphasize UP and DOWN sections?

UP sections apply new schema changes, while DOWN sections provide the necessary SQL to revert them, ensuring your database remains manageable and reversible.

What database systems are supported by this skill?

This skill is specifically optimized for SQLite, providing patterns and runners compatible with the better-sqlite3 library.

Does this skill provide an automated runner?

Yes, it includes a reference TypeScript implementation for a migration runner that automatically tracks and applies pending SQL files.

Can I use this with other SQL dialects?

While the logic of atomic migrations applies generally, the specific SQL syntax and runner code are tailored for SQLite.

Database Migrations

Name: Database Migrations
Author: cliangdev

bycliangdev

•

데이터베이스 관리

Manages SQLite schema evolutions using disciplined, reversible migration patterns and TypeScript-based runners.

This skill provides a structured framework for managing SQLite database schemas within the SpecFlux ecosystem. It transitions development from chaotic 'vibe coding' to disciplined engineering by enforcing atomic migration files with explicit UP and DOWN sections. By utilizing a standardized TypeScript migration runner and better-sqlite3, it ensures that all database changes are version-controlled, reproducible, and easily reversible, making it indispensable for developers building robust, spec-driven applications.

주요 기능

01Reversible UP and DOWN migration logic

024 GitHub stars

03TypeScript-based migration runner implementation

04Atomic SQL migration file structures

05Automatic migration tracking via internal tables

06Standardized SQLite index and constraint patterns

사용 사례

01Defining new database tables and indexes in a version-controlled manner

02Implementing a robust schema migration system for Node.js applications

03Performing safe database rollbacks during development and testing

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add cliangdev/specflux database-migrations

For use in Claude.ai and ChatGPT

Download Skill