squash-table
Squash database table migration versions in server/src/database.ts. Consolidates multiple migrations into a single initial migration while preserving the final schema.
📖 中文导读:Squash database table migration versions in server/src/database.ts. Consolidates multiple migrations into a single initial migration while preserving the final schema. 以下正文为该技能的原始 SKILL.md 内容(英文),上方安装命令可直接使用。
name: squash-table description: Squash database table migration versions in server/src/database.ts. Consolidates multiple migrations into a single initial migration while preserving the final schema.
Squash Database Migrations
Purpose
This skill helps consolidate multiple database migrations into a single migration when the schema has stabilized. This is useful during development to clean up migration history.
Target File
server/src/database.ts
How to Use
Tell Claude what changes to make, for example:
- "Squash all migrations into a single initial migration"
- "Combine migrations 1-3 into one"
- "Reset migrations to version 1 with current schema"
What This Skill Does
- Read
server/src/database.tsto understand current migrations and schema - Consolidate schema into a single migration (version 1)
- Update the MIGRATIONS array with the squashed version
Important Notes
- Data Loss Warning: Squashing migrations requires resetting the database
- After squashing, delete the existing database:
rm ~/.config/lingo/data.db - The new single migration will recreate the schema from scratch