/sequelize

An easy-to-use multi SQL dialect ORM for Node.js

Primary LanguageJavaScriptMIT LicenseMIT

Sequelize

npm version Build Status Windows Build status codecov Bountysource Slack Status npm downloads node License semantic-release Greenkeeper badge

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

v5 Beta Release

We have started v5 beta release process. Hopefully this will cover full v5 milestone. You can find upgrade guide and changelog here

npm install --save sequelize # will install v4
npm install --save sequelize@next # will install v5-beta

Table of Contents

Installation

$ npm install --save sequelize

# And one of the following:
$ npm install --save pg pg-hstore
$ npm install --save mysql2
$ npm install --save mariadb
$ npm install --save sqlite3
$ npm install --save tedious # MSSQL

Sequelize follows SEMVER. Supports Node v4 and above to use ES6 features.

Features

  • Schema definition
  • Schema synchronization/dropping
  • 1:1, 1:M & N:M Associations
  • Through models
  • Promises
  • Hooks/lifecycle events
  • Prefetching/association including
  • Transactions
  • Migrations
  • CLI (sequelize-cli)

Responsible disclosure

If you have any security issue to report, contact project maintainers privately. You can find contact information here

Documentation

Resources

Tools

Learning

Translations