Automatically generate bare sequelize models from your database.

npm install sequelize-auto
2 downloads in the last day
41 downloads in the last week
75 downloads in the last month


Build Status Dependency Status

Automatically generate models for SequelizeJS via the command line.


npm install -g sequelize-auto


sequelize-auto -h <host> -d <database> -u <user> -x [password] -p [port]  --dialect [dialect] -c [/path/to/config] -o [/path/to/models]

  -h, --host      IP/Hostname for the database.                                      [required]
  -d, --database  Database name.                                                     [required]
  -u, --user      Username for database.                                             [required]
  -x, --pass      Password for database.
  -p, --port      Port number for database.
  -c, --config    JSON file for sending additional options to the Sequelize object.
  -o, --output    What directory to place the models.
  -e, --dialect   The dialect/engine that you're using: postgres, mysql, sqlite


sequelize-auto -o "./models" -d sequelize_auto_test -h localhost -u daniel -p 5432 -x my_password -e postgres

Produces a file/files such as ./models/Users.js which looks like:

/* jshint indent: 2 */

module.exports = function(sequelize, DataTypes) {
  return sequelize.define('Users', {
    username: {
      type: DataTypes.STRING,
      allowNull: true,
      defaultValue: null
    touchedAt: {
      type: DataTypes.DATE,
      allowNull: true,
      defaultValue: null
    aNumber: {
      type: DataTypes.INTEGER,
      allowNull: true,
      defaultValue: null
    id: {
      type: DataTypes.INTEGER,
      primaryKey: true
    createdAt: {
      type: DataTypes.DATE,
      allowNull: false,
      defaultValue: null
    updatedAt: {
      type: DataTypes.DATE,
      allowNull: false,
      defaultValue: null

Which makes it easy for you to simply Sequelize.import it.


You must setup a database called "sequelize_auto_test" first, edit the spec/config.js file accordingly, and then enter in any of the following:

# for all
npm run test-buster

# mysql only
npm run test-buster-mysql

# postgres only
npm run test-buster-postgres
npm loves you