Skip to content
Related Articles
Open in App
Not now

Related Articles

How to use Sequelize in Node.js ?

Improve Article
Save Article
Like Article
  • Difficulty Level : Easy
  • Last Updated : 20 May, 2020
Improve Article
Save Article
Like Article

Sequelize is a promise-based Node.js ORM for Postgres, MySQL, MariaDB, SQLite, and Microsoft SQL Server. Its features are solid transaction support, relations, eager and lazy loading, read replication and many more.

Features of Sequelize:

  • Sequelize is a third-party package to be precise its an Object-Relational Mapping Library(ORM)..
  • Standardization ORMs usually have a single schema definition in the code. This makes it very clear what the schema is, and very simple to change it.
  • No need to learn SQL – queries are written in plain JavaScript.

Setting up a Node.js app:

  • Start Node.js app using the following command:
    npm init -y

Installation of Sequelize:

  1. Sequelize needs MySql module installed in your project. if you have not installed MySql module then make sure before installing Sequelize you need to install MySql2 module. You need to install this module by using the following command.
    npm install mysql2
  2. After installing the MySql2 module, we have to install Sequelize module to install this module by using the following command.
    npm install sequelize

Requiring module:

  • You need to include Sequelize module in your project by using these lines.
    const Sequelize = require('sequelize');

Configuring database.js file:

// Include Sequelize module
const Sequelize = require('sequelize')
// Creating new Object of Sequelize
const sequelize = new Sequelize(
        // Explicitly specifying 
        // mysql database
        dialect: 'mysql',
        // By default host is 'localhost'           
        host: 'localhost'
// Exporting the sequelize object. 
// We can use it in another file
// for creating models
module.exports = sequelize

My Personal Notes arrow_drop_up
Like Article
Save Article
Related Articles

Start Your Coding Journey Now!