sequelize/sequelize

View on GitHub

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.

Stars: 30.4k
Forks: 4.3k
Open beginner issues: 2
Indexed issues: 928
Avg merge: 1d 6h
Merged PRs (30d): 68

Dominant language: TypeScript
License: MIT
Last GitHub push: Sep 20, 2026
Latest indexed: Sep 19, 2026
Contributing guide: Contributing guide
Code of conduct: Code of conduct
Beginner labels: good first issue

Beginner friendly Everything

Open All

928 open issues indexed

Cannot provide partial SSL `dialectOptions` with postgres since #13673 Open

Difficulty 4/5 3-5 days Newbie friendliness 28/100

sequelize/sequelize#15823 · 2 comments · 6 reactions · Opened Mar 22, 2023
Allow using raw SQL in `DO UPDATE SET` generated by `Model.bulkCreate` Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

sequelize/sequelize#15820 · 1 comment · Opened Mar 22, 2023
[Bug] 7.0.0-alpha.23 - Postgres - force sync not updating enum Open

Difficulty 4/5 3-5 days Newbie friendliness 30/100

sequelize/sequelize#15812 · Opened Mar 20, 2023
Count is not working with virtual columns mariadb Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sequelize/sequelize#15790 · 3 reactions · Opened Mar 15, 2023
Unique indexes for paranoid models in Postgres Open

Difficulty 4/5 3-5 days Newbie friendliness 42/100

sequelize/sequelize#15774 · 7 comments · 1 reaction · Opened Mar 13, 2023
Database connection pool waiting time measurement by sentry.io Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15724 · 2 comments · 1 reaction · Opened Feb 28, 2023
Support SQLite STRICT tables Open

good first issue

Difficulty 4/5 3-5 days Newbie friendliness 55/100

sequelize/sequelize#15715 · 6 comments · 1 reaction · Opened Feb 26, 2023
AddForeignKeyConstraintOptions interface is incomplete (QueryInterface.addConstraint method) Open

typescript v6

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

sequelize/sequelize#15681 · 3 comments · 1 reaction · Opened Feb 16, 2023
findByPk - Use parameters behind the scenes for better cache utilization Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

sequelize/sequelize#15664 · 1 comment · 1 reaction · Opened Feb 9, 2023
Support SQL Views Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

sequelize/sequelize#15648 · 8 comments · 12 reactions · Opened Feb 3, 2023
Remapping Postgres minified aliases can result in data loss Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15646 · 5 comments · 2 reactions · Opened Feb 3, 2023
Throw an error if the user tries to register two models with the same name Open

Difficulty 3/5 1-2 days Newbie friendliness 48/100

sequelize/sequelize#15641 · Opened Feb 3, 2023
case insensitive foreign key TypeError Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15606 · 1 comment · Opened Jan 26, 2023
Sequelize does not return columns with the same name as models aliases Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15602 · 1 comment · Opened Jan 25, 2023
Adding support for skipLocked in mysql Open

Difficulty 2/5 1-3 hours Newbie friendliness 35/100

sequelize/sequelize#15589 · 2 comments · Opened Jan 24, 2023
bulkCreate with associations and ignoreDuplicates: true creates duplicate records in child tables Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

sequelize/sequelize#15583 · 15 comments · 1 reaction · Opened Jan 20, 2023
Model.save returns object subtypes instead of saved subtypes Open

breaking change

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15579 · 1 comment · Opened Jan 19, 2023
Index not created when table already exists in diffrent schema (Postgres) Open

v6

Difficulty 4/5 3-5 days Newbie friendliness 45/100

sequelize/sequelize#15543 · 3 comments · Opened Jan 10, 2023
[MySQLv5.7] Updating existing records with no changes breaks when DATEONLY field is '0000-00-00' Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sequelize/sequelize#15541 · 3 comments · Opened Jan 9, 2023
Issue in sync({alter: true}) with snowflake dialect Open

dialect: snowflake

Difficulty 3/5 1-2 days Newbie friendliness 45/100

sequelize/sequelize#15525 · 1 comment · Opened Jan 4, 2023
Models with cyclic foreign keys and ENUM-typed fields can't be synced in Postgres Open

Difficulty 4/5 3-5 days Newbie friendliness 25/100

sequelize/sequelize#15522 · 2 comments · Opened Jan 3, 2023
Using a variable to define multiple fields cause them to become weird Open

v6

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15503 · 1 comment · Opened Dec 26, 2022
Method to check the model definitions is synced to database schema Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

sequelize/sequelize#15500 · 1 comment · 1 reaction · Opened Dec 26, 2022
Validation Rework Open

sequelize/sequelize#15497 · 1 comment · 7 reactions · 1 assignee · Opened Dec 24, 2022
Including a model with scopes using separate: true results in broken queries Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15485 · 1 comment · 1 reaction · Opened Dec 19, 2022
[PostgreSQL] Array of ENUMS returned sometimes as String instead of array Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15466 · 9 comments · 3 reactions · Opened Dec 16, 2022
Make date inputs without timezone offset throw an error Open

breaking change

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15464 · 3 comments · 1 reaction · Opened Dec 16, 2022
Weird bug with $lte after migration to 6.27.0 Open

sequelize/sequelize#15463 · 10 comments · 1 assignee · Opened Dec 16, 2022
`Model.destroyMany` to destroy many instances in one query Open

sequelize/sequelize#15459 · 2 comments · 1 assignee · Opened Dec 15, 2022
bug with recent v6.21.4 minified aliases in ORDER BY clause Open

sequelize/sequelize#15422 · 20 comments · 1 reaction · 1 assignee · Opened Dec 8, 2022
Associations created by `Model.create` can't be typed Open

typescript

Difficulty 5/5 Over a week Newbie friendliness 35/100

sequelize/sequelize#15420 · 4 reactions · Opened Dec 8, 2022
Add the ability to modify the SQL in `beforeQuery` Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15416 · 4 reactions · Opened Dec 8, 2022
Use COPY in bulkCreate for Postgres Open

Difficulty 5/5 Over a week Newbie friendliness 30/100

sequelize/sequelize#15404 · 4 comments · 2 reactions · Opened Dec 6, 2022
Provide defaults for bulkCreate() Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15399 · Opened Dec 5, 2022
Add support for Repositories / Data Mapper Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

sequelize/sequelize#15389 · 5 comments · 6 reactions · Opened Dec 4, 2022
initialAutoIncrement for ALTER TABLE queries Open

dialect: mysql

Difficulty 4/5 3-5 days Newbie friendliness 48/100

sequelize/sequelize#15368 · 3 comments · Opened Dec 1, 2022
With JSON_OBJECT Sequelize / Mariadb result is incorrect Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

sequelize/sequelize#15363 · 3 comments · Opened Nov 30, 2022
Throw when an identifier generated by Sequelize is longer than the maximum identifier length Open

sequelize/sequelize#15362 · 1 reaction · 1 assignee · Opened Nov 30, 2022
Support `minifyAliases` option in `findAll`/`findOne`/`findAndCountAll` Open

sequelize/sequelize#15361 · 4 comments · 2 reactions · 1 assignee · Opened Nov 30, 2022
Temporal Tables Open

sequelize/sequelize#15359 · 1 comment · 2 reactions · 1 assignee · Opened Nov 30, 2022
Upsert (and probably build, create, update, etc.) can miss properties that are not own-properties Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15337 · 4 comments · Opened Nov 26, 2022
Status of merge with sequelize-typescript Open

sequelize/sequelize#15334 · 2 comments · 5 reactions · 1 assignee · Opened Nov 26, 2022
findOne creates subquery if OpTypes are used in "where" property Open

Difficulty 4/5 3-5 days Newbie friendliness 35/100

sequelize/sequelize#15326 · 2 comments · 3 reactions · Opened Nov 23, 2022
Redesign naming Strategies Open

breaking change

Difficulty 5/5 Over a week Newbie friendliness 25/100

sequelize/sequelize#15312 · 5 comments · 7 reactions · Opened Nov 20, 2022
Cannot create two-way BelongsTo association in PostgresSQL Open

Difficulty 4/5 3-5 days Newbie friendliness 38/100

sequelize/sequelize#15285 · 3 comments · Opened Nov 15, 2022
Rewrite toposort-class Open

dependency type: refactor

sequelize/sequelize#15269 · 4 comments · 1 assignee · Opened Nov 10, 2022
Rewrite `include` in `findAll`, `findOne`, `findAndCountAll` Open

sequelize/sequelize#15260 · 8 comments · 20 reactions · 1 assignee · Opened Nov 8, 2022
Make loaded associations available on the model when possible Open

Difficulty 5/5 Over a week Newbie friendliness 30/100

sequelize/sequelize#15234 · 2 reactions · Opened Nov 4, 2022
Remove the `include` option from `Model.create` Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

sequelize/sequelize#15233 · 13 comments · 20 reactions · Opened Nov 4, 2022
ibmi Dialect Issues Open

Difficulty 4/5 3-5 days Newbie friendliness 32/100

sequelize/sequelize#15227 · 4 comments · 1 reaction · Opened Nov 3, 2022

sequelize/sequelize

Get new issues in your inbox