sequelize

Initialize sequelize

$ npx sequelize-cli init

$ npx sequelize-cli model:generate --name [User] --attributes [name:string,email:string]

$ npx sequelize-cli db:migrate

$ npx sequelize-cli db:migrate:undo

$ npx sequelize-cli seed:generate --name [demo-user]

$ npx sequelize-cli db:seed:all

$ npx sequelize-cli migration:generate --name [add-column]

sequelize-cli command [options]

sequelize-cli manages Sequelize ORM projects. It handles models, migrations, and seeds.
Initialization creates project structure. Config, models, migrations, and seeders directories.
Models define database tables. Attributes specify columns and types.
Migrations version database schema. Up and down functions for changes.
Seeds populate initial data. Development and testing data setup.

init

Initialize project.

Create model.

Run migrations.

Revert migration.

Create seed file.

Run all seeds.

Create migration.

Model/migration name.

Model attributes.

Node.js ORM. Database-specific syntax may vary. Migration ordering is important.

Sequelize is a Node.js ORM supporting PostgreSQL, MySQL, SQLite, and others. The CLI provides scaffolding and migration tools.

node(1), npm(1), knex(1)