For providing database connection details to Sequelize with NestJs

database.providers.ts

import { Sequelize } from 'sequelize-typescript';

/**
 * SEQUELIZE variable is stored in a file named
 * 'constants' so it can be easily reused anywhere
 * without being subject to human error.
 */
import { SEQUELIZE } from '../utils/constants';
import { User } from '../user/user.entity';

export const databaseProviders = [
  {
    provide: SEQUELIZE,
    useFactory: async () => {
      const sequelize = new Sequelize({
        dialect: 'mysql',
        host: 'remotemysql.com',
        port: 3306,
        username: 'xxxxxxxxxx',
        password: 'xxxxxxxxxx',
        database: 'xxxxxxxxxx',
      });

      /**
       * Add Models Here
       * ===============
       * You can add the models to 
       * Sequelize later on.
       */
      sequelize.addModels([User]);

      await sequelize.sync();
      return sequelize;
    },
  },
];