/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, SQLite and Microsoft SQL Server. It features solid transaction support, relations, read replication and more.

Table of Contents

Installation

$ npm install --save sequelize

# And one of the following:
$ npm install --save pg@6 pg-hstore # Note that `pg@7` is not supported yet
$ npm install --save mysql2
$ 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/callbacks/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