sequelize-cli

npm install --save-dev sequelize-cli sequelize mysql2 # Initialize a new Sequelize project structure npx sequelize init # Adjust config/config.js to your database settings. For example (using environment variables): # module.exports = { # development: { # username: process.env.DB_USER ?? 'root', # password: process.env.DB_PASSWORD ?? '', # database: process.env.DB_NAME ?? 'my_sequelize_db_dev', # host: process.env.DB_HOST ?? '127.0.0.1', # dialect: 'mysql' # } # }; # Create the database specified in your configuration npx sequelize db:create # Generate a new model and its corresponding migration file npx sequelize model:generate --name User --attributes firstName:string,lastName:string,email:string # Run pending migrations to apply schema changes to the database npx sequelize db:migrate # Generate a seeder file for initial data population npx sequelize seed:generate --name initial-users # Edit the generated seeder file (e.g., seeders/<timestamp>-initial-users.js) to insert data: # module.exports = { # up: async (queryInterface, Sequelize) => { # await queryInterface.bulkInsert('Users', [{ # firstName: 'Jane', lastName: 'Doe', email: 'jane.doe@example.com', # createdAt: new Date(), updatedAt: new Date() # }], {}); # }, # down: async (queryInterface, Sequelize) => { # await queryInterface.bulkDelete('Users', null, {}); # } # }; # Run all seeders to populate the database with initial data npx sequelize db:seed:all