The Sequelize Command Line Interface (CLI)
Install this globally and you'll have access to the sequelize
command anywhere on your system.
$ npm install -g sequelize-cli
or install it locally to your node_modules
folder
$ npm install --save sequelize-cli
$ sequelize [--HARMONY-FLAGS]
Sequelize [Node: 7.8.0, CLI: 2.7.0, ORM: 3.27.0]
Usage
sequelize [task][options...]
Available tasks
db:migrate Run pending migrations.
db:migrate:old_schema Update legacy migration table
db:migrate:schema:timestamps:add Update migration table to have timestamps
db:migrate:status List the status of all migrations
db:migrate:undo Reverts a migration.
db:migrate:undo:all Revert all migrations ran.
db:seed Run specified seeder.
db:seed:all Run every seeder.
db:seed:undo Deletes data from the database.
db:seed:undo:all Deletes data from the database.
help Display this help text. Aliases: h
init Initializes the project. [init:config, init:migrations, init:seeders, init:models]
init:config Initializes the configuration.
init:migrations Initializes the migrations.
init:models Initializes the models.
init:seeders Initializes the seeders.
migration:create Generates a new migration file. Aliases: migration:generate
model:create Generates a model and its migration. Aliases: model:generate
seed:create Generates a new seed file. Aliases: seed:generate
version Prints the version number. Aliases: v
Available manuals
help:db:migrate The documentation for "sequelize db:migrate".
help:db:migrate:old_schema The documentation for "sequelize db:migrate:old_schema".
help:db:migrate:schema:timestamps:add The documentation for "sequelize db:migrate:schema:timestamps:add".
help:db:migrate:status The documentation for "sequelize db:migrate:status".
help:db:migrate:undo The documentation for "sequelize db:migrate:undo".
help:db:migrate:undo:all The documentation for "sequelize db:migrate:undo:all".
help:db:seed The documentation for "sequelize db:seed".
help:db:seed:all The documentation for "sequelize db:seed:all".
help:db:seed:undo The documentation for "sequelize db:seed:undo".
help:db:seed:undo:all The documentation for "sequelize db:seed:undo:all".
help:init The documentation for "sequelize init".
help:init:config The documentation for "sequelize init:config".
help:init:migrations The documentation for "sequelize init:migrations".
help:init:models The documentation for "sequelize init:models".
help:init:seeders The documentation for "sequelize init:seeders".
help:migration:create The documentation for "sequelize migration:create".
help:model:create The documentation for "sequelize model:create".
help:seed:create The documentation for "sequelize seed:create".
help:version The documentation for "sequelize version".
$ node_modules/.bin/sequelize [--HARMONY-FLAGS]
The manuals will show all the flags and options which are available for the respective tasks.
If you find yourself in a situation where you always define certain flags in order to
make the CLI compliant to your project, you can move those definitions also into a file called
.sequelizerc
. The file will get require
d if available and can therefore be either a JSON file
or a Node.JS script that exports a hash.
var path = require('path')
module.exports = {
'config': path.resolve('config', 'database.json'),
'migrations-path': path.resolve('db', 'migrate')
}
This will configure the CLI to always treat config/database.json
as config file and
db/migrate
as the directory for migrations.
The CLI is compatible with CoffeeScript. You can tell the CLI to enable that support via the --coffee
flag. Please note that you'll need to install js2coffee
and coffee-script
for full support.
By default the CLI will try to use the file config/config.js
and config/config.json
. You can modify that path either via the --config
flag or via the option mentioned earlier. Here is how a configuration file might look like (this is the one that sequelize init
generates):
{
"development": {
"username": "root",
"password": null,
"database": "database_development",
"host": "127.0.0.1",
"dialect": "mysql"
},
"test": {
"username": "root",
"password": null,
"database": "database_test",
"host": "127.0.0.1",
"dialect": "mysql"
},
"production": {
"username": "root",
"password": null,
"database": "database_production",
"host": "127.0.0.1",
"dialect": "mysql"
}
}
The properties can also be combined to a url
:
{
"development": {
"url": "mysql://root:password@mysql_host.com/database_name",
"dialect": "mysql"
}
}
In case of a JS file it obviously needs to module.exports
the object.
Optionally, it's possible to put all the configuration to the url
option. The format is explained in the section below.
As an alternative to the --config
option with configuration files defining your database, you can
use the --url
option to pass in a connection string. For example:
sequelize db:migrate --url 'mysql://root:password@mysql_host.com/database_name'
Another possibility is to store the URL in an environment variable and to tell
the CLI to lookup a certain variable during runtime. Let's assume you have an
environment variable called DB_CONNECTION_STRING
which stores the value
mysql://root:password@mysql_host.com/database_name
. In order to make the CLI
use it, you have to use declare it in your config file:
{
"production": {
"use_env_variable": "DB_CONNECTION_STRING"
}
}
With v2.0.0 of the CLI you can also just directly access the environment variables inside the config/config.js
:
module.exports = {
"production": {
"hostname": process.env.DB_HOSTNAME
}
}
There are three types of storage that you can use: sequelize
, json
, and none
.
sequelize
: stores migrations and seeds in a table on the sequelize databasejson
: stores migrations and seeds on a json filenone
: does not store any migration/seed
By default the CLI will create a table in your database called SequelizeMeta
containing an entry
for each executed migration. To change this behavior, there are three options you can add to the
configuration file. Using migrationStorage
, you can choose the type of storage to be used for
migrations. If you choose json
, you can specify the path of the file using migrationStoragePath
or the CLI will write to the file sequelize-meta.json
. If you want to keep the information in the
database, using sequelize
, but want to use a different table, you can change the table name using
migrationStorageTableName
.
{
"development": {
"username": "root",
"password": null,
"database": "database_development",
"host": "127.0.0.1",
"dialect": "mysql",
// Use a different storage type. Default: sequelize
"migrationStorage": "json",
// Use a different file name. Default: sequelize-meta.json
"migrationStoragePath": "sequelizeMeta.json"
// Use a different table name. Default: SequelizeMeta
"migrationStorageTableName": "sequelize_meta"
}
}
NOTE: The none
storage is not recommended as a migration storage. If you decide to use it, be
aware of the implications of having no record of what migrations did or didn't run.
By default the CLI will not save any seed that is executed. If you choose to change this behavior (!),
you can use seederStorage
in the configuration file to change the storage type. If you choose json
,
you can specify the path of the file using seederStoragePath
or the CLI will write to the file
sequelize-data.json
. If you want to keep the information in the database, using sequelize
, you can
specify the table name using seederStorageTableName
, or it will default to SequelizeData
.
{
"development": {
"username": "root",
"password": null,
"database": "database_development",
"host": "127.0.0.1",
"dialect": "mysql",
// Use a different storage. Default: none
"seederStorage": "json",
// Use a different file name. Default: sequelize-data.json
"seederStoragePath": "sequelizeData.json"
// Use a different table name. Default: SequelizeData
"seederStorageTableName": "sequelize_data"
}
}
In order to pass options to the underlying database connectors, you can add the property dialectOptions
to your configuration like this:
var fs = require('fs');
module.exports = {
development: {
dialect: 'mysql',
dialectOptions: {
ssl: {
ca: fs.readFileSync(__dirname + '/mysql-ca.crt')
}
}
}
};
Since v1.0.0 the CLI supports a new schema for saving the executed migrations. It will tell you about that when you run a migration while having the old schema. You can opt-in for auto migrating the schema by adding a special property to your config file:
{
"development": {
"autoMigrateOldSchema": true
}
}
Since v2.8.0 the CLI supports a adding timestamps to the schema for saving the executed migrations. You can opt-in for timestamps by running the following command:
$ sequelize db:migrate:schema:timestamps:add
The CLI uses umzug and its migration schema. This means a migration has to look like this:
"use strict";
module.exports = {
up: function(queryInterface, Sequelize, done) {
done();
},
down: function(queryInterface) {
return new Promise(function (resolve, reject) {
resolve();
});
}
};
Please note that you can either return a Promise or call the third argument of the function once your asynchronous logic was executed. If you pass something to the callback function (the done
function) it will be treated as erroneous execution.
Additional note: If you need to access the sequelize instance, you can easily do that via queryInterface.sequelize
. For example queryInterface.sequelize.query('CREATE TABLE mytable();')
.
Read the manuals via sequelize help:<task-name>
for further information.