How sequelize/sequelize works
Sequelize is a promise-based Node.js ORM. Its main workflow is defining models and associations, expressing queries through model APIs, translating them into dialect-specific SQL, and executing them through a database connection. The core also provides transactions, data types, and query operators; separate dialect packages adapt the runtime to supported databases. The repository includes a CLI for migrations and seeds. Some links are documented or visible in the source index, but most implementations were not excerpted, so uncertain runtime calls are omitted or marked unverified.
Main entry points: dialect.ts Dialect configuration · sequelize.js Sequelize API · query-interface.js Query interface · model-definition.ts Model definitions
Components 22
Modeling
- Sequelize API
packages/core/src/sequelize.js - Model definitions
packages/core/src/model-definition.ts - Model operations
packages/core/src/model.js - Associations
packages/core/src/associations - Data types
packages/core/src/abstract-dialect/data-types.ts - Query operators
packages/core/src/operators.ts
Query Runtime
- Query interface
packages/core/src/abstract-dialect/query-interface.js - SQL generation
packages/core/src/abstract-dialect/query-generator.js - Where builder
packages/core/src/abstract-dialect/where-sql-builder.ts - Transactions
packages/core/src/transaction.ts - Connection management
packages/core/src/abstract-dialect/connection-manager.ts
Database Dialects
- Dialect configuration
packages/core/src/abstract-dialect/dialect.ts - Postgres adapter
packages/postgres/src/dialect.ts - MySQL adapter
packages/mysql/src/dialect.ts - MariaDB adapter
packages/mariadb/src/dialect.ts - SQLite adapter
packages/sqlite3/src/dialect.ts - SQL Server adapter
packages/mssql/src/dialect.ts - Other adapters
packages
Operations
- Migration and seed CLI
packages/cli/src/api - Migration management
packages/cli/src/api/run-migrations.ts
Other components
- Application developer
- SQL databases
Connections 26
- Application developer → Sequelize API: uses ORM
README.md - Sequelize API → Model operations: exposes model API
- Application developer → Model definitions: defines models
README.md - Model definitions → Associations: declares relations
packages/core/src/associations/belongs-to.ts - Model definitions → Data types: uses types
- Application developer → Model operations: issues queries
README.md - Model operations → Query interface: dispatches queries
- Query interface → SQL generation: requests SQL
- SQL generation → Where builder: builds predicates
packages/core/src/abstract-dialect/query-generator.js - Query operators → Where builder: expresses conditions
packages/core/src/abstract-dialect/where-sql-builder.ts - Sequelize API → Dialect configuration: configures dialect
packages/core/src/abstract-dialect/dialect.ts - Dialect configuration → Connection management: provides manager
packages/core/src/abstract-dialect/dialect.ts - Dialect configuration → SQL generation: provides generator
packages/core/src/abstract-dialect/dialect.ts - Dialect configuration → Query interface: provides interface
packages/core/src/abstract-dialect/dialect.ts - Connection management → SQL databases: opens connections
- Query interface → SQL databases: executes SQL
- Postgres adapter → Dialect configuration: implements dialect
- MySQL adapter → Dialect configuration: implements dialect
- MariaDB adapter → Dialect configuration: implements dialect
- SQLite adapter → Dialect configuration: implements dialect
- SQL Server adapter → Dialect configuration: implements dialect
- Other adapters → Dialect configuration: implements dialect
packages/core/src/abstract-dialect/connection-manager.ts - Application developer → Migration and seed CLI: runs maintenance
README.md - Migration and seed CLI → Migration management: runs migrations
- Migration management → SQL databases: changes schema
- Sequelize API → Transactions: supports transactions
README.md