Schema and data migrations for node js

Question

Is there any tool that works similar to Django South, but for Node?

Now I'm working with Sequelize. If I got it right, Sequelize does not have an option to create migration files based on existing models. So, to create a new model/table, the steps are:

• Create model with sequelize model:create <model meta>.
• Edit generated migration file - add actual code for creating tables in DB under up section.
• Run migration with sequelize db:migrate.

I'm looking for something that can create migration files based on existing models, manage it similar to what South can do for Django.

Is there any option?

Answer 1

I have written a step-by-step guide on how to auto-create migrations with Sequelize in another post. Here is a summary...

The closest thing with Sequelize is Sequelize Auto Migrations.

It allows you to have an iteration cycle like the following:

1. Create/update model -- by hand or with sequelize-cli)
2. Run makemigrations to auto-generate up and down migrations
3. Repeat as necessary

While this is very helpful, I've found it to be lacking in some critical areas:

1. The down migrations can be created incorrectly. So it may try to drop a table before its dependent tables have been dropped.
2. There are certain configurations around multi-field indexes that it has not correctly output.

There are currently 10 outstanding PRs, so it seems like a few additional contributors are attempting to make it more production-ready... but I've yet to find anything as clean and reliable as Django Migrations (formerly Django South).