Does this skill handle both SQLite and PostgreSQL?

Yes, it uses a custom DSL and specialized directory structure to ensure migrations work across both supported n8n database types, providing specific guidance for dialect-specific features when necessary.

How are new migration files created using this skill?

The skill guides you to use the generator command `pnpm --filter=@n8n/db migration:new` to ensure proper timestamping, naming, and automatic registration within the codebase.

Why is the MigrationContext API preferred over raw SQL?

The API automatically handles identifier escaping and ensures compatibility across different database engines, preventing manual syntax errors and managing table prefixes correctly.

What is the difference between Reversible and Irreversible migrations?

Reversible migrations are for schema changes with a clear 'down()' method, while Irreversible migrations are used for data transformations where undoing the change would result in data loss.

n8n Database Migrations - Claude Code Skill

This skill provides specialized guidance for creating, modifying, and testing database migrations within the n8n ecosystem. It ensures that schema changes follow strict architectural patterns, maintains parity between PostgreSQL and SQLite, and enforces a rigorous pre-flight checklist to prevent common migration errors. By leveraging a domain-specific language (DSL) and predefined migration types, it simplifies complex database operations like column additions, table creation, and data backfilling while maintaining cross-database integrity and following n8n's specific contribution guidelines.

Características Principales

01Automated migration scaffolding with strict timestamp ordering

02Schema DSL for type-safe table, column, and index management

03Cross-database compatibility management for PostgreSQL and SQLite

04Comprehensive pre-flight checklists for migration quality assurance

05Support for reversible schema changes and irreversible data transformations

06192,340 GitHub stars

Casos de Uso

01Adding new columns, tables, or foreign keys to the n8n database schema

02Performing complex data backfills or transformations across multiple database engines

03Ensuring entity-to-migration parity and proper index management for query optimization

Tieline — product intent grounded in code

n8n Database Migrations

Características Principales

Casos de Uso

PostgreSQL Patterns

Flutter Supabase Cloudflare Global Skill

MySQL Patterns

Características Principales

Casos de Uso