sequelize-postgres-auto-migrations

This package helps you in the boring process of writing migration files by yourself and supports sequelize-typescript with sequelize v6. Tested only with sequelize-typescript.
Npm package is available https://www.npmjs.com/package/sequelize-postgres-auto-migrations
To generate migration file follow the steps below:

1import { AutoMigrations } from 'sequelize-postgres-auto-migrations';
2const sequelize = new Sequelize({
3        dialect: 'postgres',
4        host: 'host',
5        username: 'username',
6        password: 'password',
7        database: 'database',
8        models: [],
9});
10const auto_migrations = new AutoMigrations(sequelize);  
11auto_migrations.generateMigration('migration_name', 'migration_path');

Examples:
Let's imagine we have a new model, defined with sequelize-typescript, which doesn't exist in Postgres database:

1@Table
2export class TestModel extends Model {
3    @Column
4    name!: string
5
6    @Column
7    phone!: string
8}

So we need sequelize migration file to make our DB up to date. What do we need?
Just create script with these three lines:

1import { AutoMigrations } from 'sequelize-postgres-auto-migrations';
2
3const sequelize = new Sequelize({ //or import your Sequelize object
4        dialect: 'postgres',
5        host: 'host',
6        username: 'username',
7        password: 'password',
8        database: 'database',
9        models: [TestModel],
10});
11
12const auto_migrations = new AutoMigrations(sequelize);  
13auto_migrations.generateMigration('migration_name', 'migration_path')

After running script you can see a new migration file in migrations folder, let's check it out:

1module.exports = {
2    up: async (queryInterface, Sequelize) => {
3        await queryInterface.sequelize.transaction(async (t) => {
4            await queryInterface.createTable({
5                tableName: 'TestModels',
6                schema: 'public'
7            }, {
8                id: {
9                    type: Sequelize.INTEGER,
10                    allowNull: false,
11                    primaryKey: true,
12                    autoIncrement: true,
13                },
14                name: {
15                    type: Sequelize.STRING(255),
16                },
17                phone: {
18                    type: Sequelize.STRING(255),
19                },
20            }, {
21                transaction: t,
22                schema: 'public'
23            });
24        });
25    },
26    down: async (queryInterface, Sequelize) => {
27        await queryInterface.sequelize.transaction(async (t) => {
28            await queryInterface.dropTable({
29                tableName: 'TestModels',
30                schema: 'public'
31            }, {
32                transaction: t
33            });
34        });
35    },
36};

You can see generated migration file for creating a new table.
You can use this package for adding, deleting, editing tables, columns, foreign keys and other constraint. This package also supports using different schemes.
Migrations are not created if non-executed migrations exists.
Restrictions:

• Currently available only for postgres
• Currently doesn't support partial indexes