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, providing scaffolding for models, migrations, and seed files. The init command creates the standard project structure with config, models, migrations, and seeders directories.
Models define database table mappings with typed attributes, and the CLI generates both the model file and an initial migration. Migrations version the database schema using up and down functions, allowing incremental schema changes that can be applied or reverted. Seeds populate tables with initial or test data.
The CLI supports PostgreSQL, MySQL, MariaDB, SQLite, and Microsoft SQL Server through Sequelize's database abstraction layer.

init

Initialize project.

Create model.

Run migrations.

Revert migration.

Create seed file.

Run all seeds.

Create migration.

Model/migration name.

Model attributes.

config/config.json

Database connection configuration for development, test, and production environments, specifying host, port, username, password, dialect, and database name.

Project-level configuration file overriding default paths for models, migrations, seeders, and config directories.

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)