# sequelize/sequelize

Feature-rich ORM for modern Node.js and TypeScript, it supports PostgreSQL (with JSON and JSONB support), MySQL, MariaDB, SQLite, MS SQL Server, Snowflake, Oracle DB, DB2 and DB2 for IBM i.

Repository: https://github.com/sequelize/sequelize
Canonical: https://ross.abutalabs.com/products/sequelize
Homepage: https://sequelize.org/
Language: TypeScript
License: MIT
License Family: permissive
Topics: javascript, sql, orm, transactions, mysql, postgresql, mssql, sqlite, mariadb, sequelize, microsoft-sql-server, mssql-server, snowflakedb, oracle-db, db2-ibm-i, nodejs, typescript, feature-rich
Last push: 2026-08-26T14:51:41+00:00

## Health v2 (maintenance only)
Score: 86/100 (v2, computed 2026-09-03T02:20:16.233290+00:00)
- activity 99, release rhythm 62, longevity 100
- inputs: {"age_days": 5886, "days_push": 7, "days_rel": 179, "gap_med": 76.5, "n_releases_24m": 5}
- flags: none
- formula: round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10)

## Adoption (not part of the score)
Stars 30377, forks 4341 (observed 2026-08-28T04:11:54.445068+00:00)

## What it is
Sequelize is a feature-rich, promise-based ORM for Node.js and TypeScript supporting PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, Snowflake, Oracle DB, and DB2. It provides model definitions, associations, transactions, eager/lazy loading, migrations, and read replication.

## Use cases
- map javascript objects to sql database tables in node.js
- manage database migrations for a node app
- query postgres or mysql from typescript without raw sql
- define model associations like hasMany and belongsTo
- run multi-statement database transactions safely
- support multiple sql databases with one orm
- soft-delete records with paranoid mode

## When to choose
- you need a mature, battle-tested ORM across many SQL dialects in Node.js
- you want built-in transactions, associations, and migration tooling
- your team uses TypeScript or JavaScript with Sequelize's decorator-based models

## When to avoid
- you prefer writing raw SQL or using a lightweight query builder like Knex
- you need a NoSQL database like MongoDB
- you want a schema-first ORM like Prisma or Drizzle with generated types

## Facets
- artifact type: library
- maturity: stable
- function: orm, database-driver, database
- domain: databases, backend, web-development, developer-tools
- platform: -
- tags: sql, transactions, migrations, multi-dialect, promise-based, model-associations, read-replication, nodejs, typescript, javascript

## Member repositories
- sequelize/sequelize (main) score 86

## Provenance
- Observed fields: from GitHub, fetched 2026-08-28T04:11:54.445068+00:00.
- Health v2: computed from the inputs above; adoption is never an input.
- Inferred fields (summary, facets, guidance): AI-extracted, prompt v1, taxonomy v1, on 2026-08-29T16:52:46.491983+00:00, confidence not recorded.
  - readme: https://github.com/sequelize/sequelize (fetched 2026-08-28T04:11:54.445068+00:00, sha bef64f728885)
  - homepage: https://sequelize.org/ (fetched 2026-08-29T07:50:14.633416+00:00, sha 626ef8e10d5f)
  - site_page: https://sequelize.org/docs/v6 (fetched 2026-08-29T07:50:14.642959+00:00, sha a8d1aa25c2cc)
  - site_page: https://sequelize.org/docs/v7 (fetched 2026-08-29T07:50:14.645265+00:00, sha 1c84041ec43b)
  - site_page: https://sequelize.org/docs/v6/getting-started (fetched 2026-08-29T07:50:14.647334+00:00, sha 6c1759e11b3d)
  - site_page: https://sequelize.org/docs/v6/other-topics/upgrade (fetched 2026-08-29T07:50:14.649261+00:00, sha bc5781f3d0a6)
  - site_page: https://sequelize.org/docs/v6/core-concepts/model-basics (fetched 2026-08-29T07:50:14.651353+00:00, sha efe390636ef4)
  - site_page: https://sequelize.org/docs/v6/core-concepts/model-querying-basics (fetched 2026-08-29T07:50:14.653351+00:00, sha 8abd1fb26a45)
  - site_page: https://sequelize.org/docs/v6/other-topics/transactions (fetched 2026-08-29T07:50:14.655366+00:00, sha 18461bbf470c)
  - site_page: https://sequelize.org/docs/v6/other-topics/migrations (fetched 2026-08-29T07:50:14.657078+00:00, sha 58c9d343ec99)
- Data as of 2026-08-30T08:39:29.467469+00:00.