n8n:db-migrations

You can automate database migrations for n8n by generating structured migration files with TypeScript and applying them via the n8n framework. This Skill streamlines the process, reducing manual effort and potential errors while ensuring cross-database compatibility.

Yes, n8n database migration supports both PostgreSQL and SQLite. The Skill ensures cross-database compatibility by verifying that migrations work correctly across different database systems, allowing you to maintain consistency regardless of the underlying database engine.

Reversible database migrations in n8n provide a rollback mechanism to undo schema or data changes, while irreversible migrations apply changes permanently. This Skill supports both types, allowing you to choose the appropriate migration strategy based on your specific database modification needs.

To generate a new database migration file in n8n, you use the `n8n db-migrations` command. This Skill automatically creates a structured migration file that you can use to add a new database column or perform other schema and data modifications within the n8n workflow management system.

You need a schema migration in n8n when altering the database structure, such as adding a new column, and a data migration when modifying existing records. This Skill supports both types, ensuring you can handle structural changes and data updates comprehensively.

The primary limitation of using n8n for database migrations is that it is confined to the n8n workflow management system's database operations and relies on TypeScript. While it provides a pre-flight checklist to ensure quality, it is specifically tailored for PostgreSQL and SQLite compatibility rather than general-purpose database management.