Recreate SQLite tables with foreign key dependencies during schema migrations.
npx skills add https://github.com/lbolanos/emaus --skill sqlite-migrations
Please help me install this Agent Skill. Skill: sqlite-migrations Source: https://github.com/lbolanos/emaus/tree/main/.ruler/skills/sqlite-migrations Command: npx skills add https://github.com/lbolanos/emaus --skill sqlite-migrations
This Skill addresses the challenges of performing complex schema changes in SQLite databases, preventing data loss and maintenance issues during migrations.
Use this Skill when creating a new migration to modify table schemas involving foreign keys, following the prescribed recreate-table pattern for safe execution and validation.
High-intent search queries and answers about installing and using this skill.
Changing primary keys or foreign key constraints in SQLite requires recreating the table. This Skill provides templates for safely copying data, renaming tables, and modifying columns while maintaining data integrity and offering recovery options during schema updates.
Dropping a SQLite column safely requires recreating the table because SQLite lacks full ALTER TABLE support. This Skill provides migration templates to copy data to a new schema, verify consistency, and swap tables without risking data loss.
Modifying foreign keys in SQLite requires recreating the table because SQLite has limited ALTER TABLE functionality and cannot directly change existing foreign key constraints. The recreate-table pattern ensures data integrity during these complex schema updates.
Yes, you can rename a SQLite table with dependent foreign keys, but it requires careful migration execution. This Skill guides you through safe rename operations and table recreations to ensure dependent foreign keys remain intact and data consistency is verified.
SQLite schema migrations face limitations with direct foreign key modifications and complex table alterations. This Skill addresses these constraints by providing decision trees and safe recreate-table patterns to prevent data loss during production database maintenance.
DengNaichenAnalyzes SQLite and GRDB schemas and migration scripts for integrity risks.
paleoterraValidate SQLite migrations and schemas with sqlite_validator.py CLI commands.
xloxn69Generate SQL schemas, migrations, and table definitions with DDL constraints.
686f6c61Generates database schema migration plans with rollback scripts and impact estimates.
