# sequelize/sequelize architecture

> Architecture diagram of the GitHub repository sequelize/sequelize, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-09). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/sequelize/sequelize
- Repository: https://github.com/sequelize/sequelize

## Overview

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: [`packages/core/src/abstract-dialect/dialect.ts`](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/dialect.ts) (Dialect configuration), [`packages/core/src/sequelize.js`](https://github.com/sequelize/sequelize/blob/main/packages/core/src/sequelize.js) (Sequelize API), [`packages/core/src/abstract-dialect/query-interface.js`](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/query-interface.js) (Query interface), [`packages/core/src/model-definition.ts`](https://github.com/sequelize/sequelize/blob/main/packages/core/src/model-definition.ts) (Model definitions)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_modeling["Modeling"]
  node_sequelize["Sequelize API<br/>[sequelize.js]"]
  node_definitions["Model definitions"]
  node_model["Model operations<br/>[model.js]"]
  node_associations["Associations"]
  node_types["Data types<br/>[data-types.ts]"]
  node_operators["Query operators<br/>[operators.ts]"]
end

subgraph group_query["Query Runtime"]
  node_queryinterface["Query interface<br/>[query-interface.js]"]
  node_generator["SQL generation<br/>[query-generator.js]"]
  node_where["Where builder"]
  node_transactions["Transactions<br/>[transaction.ts]"]
  node_connections["Connection management"]
end

subgraph group_dialects["Database Dialects"]
  node_dialect["Dialect configuration<br/>[dialect.ts]"]
  node_postgres["Postgres adapter<br/>[dialect.ts]"]
  node_mysql["MySQL adapter<br/>[dialect.ts]"]
  node_mariadb["MariaDB adapter<br/>[dialect.ts]"]
  node_sqlite["SQLite adapter<br/>[dialect.ts]"]
  node_mssql["SQL Server adapter<br/>[dialect.ts]"]
  node_otherdb["Other adapters"]
end

subgraph group_operations["Operations"]
  node_cli["Migration and seed CLI"]
  node_migration["Migration management<br/>[run-migrations.ts]"]
end

node_developer(("Application developer"))
node_database[("SQL databases")]

node_developer -->|"uses ORM"| node_sequelize
node_sequelize -.->|"exposes model API"| node_model
node_developer -->|"defines models"| node_definitions
node_definitions -.->|"declares relations"| node_associations
node_definitions -.->|"uses types"| node_types
node_developer -->|"issues queries"| node_model
node_model -.->|"dispatches queries"| node_queryinterface
node_queryinterface -.->|"requests SQL"| node_generator
node_generator -.->|"builds predicates"| node_where
node_operators -.->|"expresses conditions"| node_where
node_sequelize -->|"configures dialect"| node_dialect
node_dialect -->|"provides manager"| node_connections
node_dialect -->|"provides generator"| node_generator
node_dialect -->|"provides interface"| node_queryinterface
node_connections -.->|"opens connections"| node_database
node_queryinterface -.->|"executes SQL"| node_database
node_postgres -.->|"implements dialect"| node_dialect
node_mysql -.->|"implements dialect"| node_dialect
node_mariadb -.->|"implements dialect"| node_dialect
node_sqlite -.->|"implements dialect"| node_dialect
node_mssql -.->|"implements dialect"| node_dialect
node_otherdb -.->|"implements dialect"| node_dialect
node_developer -->|"runs maintenance"| node_cli
node_cli -.->|"runs migrations"| node_migration
node_migration -.->|"changes schema"| node_database
node_sequelize -->|"supports transactions"| node_transactions

click node_sequelize "https://github.com/sequelize/sequelize/blob/main/packages/core/src/sequelize.js"
click node_definitions "https://github.com/sequelize/sequelize/blob/main/packages/core/src/model-definition.ts"
click node_model "https://github.com/sequelize/sequelize/blob/main/packages/core/src/model.js"
click node_associations "https://github.com/sequelize/sequelize/tree/main/packages/core/src/associations"
click node_types "https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/data-types.ts"
click node_operators "https://github.com/sequelize/sequelize/blob/main/packages/core/src/operators.ts"
click node_queryinterface "https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/query-interface.js"
click node_generator "https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/query-generator.js"
click node_where "https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/where-sql-builder.ts"
click node_transactions "https://github.com/sequelize/sequelize/blob/main/packages/core/src/transaction.ts"
click node_connections "https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/connection-manager.ts"
click node_dialect "https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/dialect.ts"
click node_postgres "https://github.com/sequelize/sequelize/blob/main/packages/postgres/src/dialect.ts"
click node_mysql "https://github.com/sequelize/sequelize/blob/main/packages/mysql/src/dialect.ts"
click node_mariadb "https://github.com/sequelize/sequelize/blob/main/packages/mariadb/src/dialect.ts"
click node_sqlite "https://github.com/sequelize/sequelize/blob/main/packages/sqlite3/src/dialect.ts"
click node_mssql "https://github.com/sequelize/sequelize/blob/main/packages/mssql/src/dialect.ts"
click node_otherdb "https://github.com/sequelize/sequelize/tree/main/packages"
click node_cli "https://github.com/sequelize/sequelize/tree/main/packages/cli/src/api"
click node_migration "https://github.com/sequelize/sequelize/blob/main/packages/cli/src/api/run-migrations.ts"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_sequelize,node_definitions,node_model,node_associations,node_types,node_operators toneBlue
class node_queryinterface,node_generator,node_where,node_transactions,node_connections,node_database toneAmber
class node_dialect,node_postgres,node_mysql,node_mariadb,node_sqlite,node_mssql,node_otherdb toneMint
class node_cli,node_migration toneRose
class node_developer toneIndigo
```

## Components

### Modeling

- [Sequelize API](https://github.com/sequelize/sequelize/blob/main/packages/core/src/sequelize.js): `packages/core/src/sequelize.js`
- [Model definitions](https://github.com/sequelize/sequelize/blob/main/packages/core/src/model-definition.ts): `packages/core/src/model-definition.ts`
- [Model operations](https://github.com/sequelize/sequelize/blob/main/packages/core/src/model.js): `packages/core/src/model.js`
- [Associations](https://github.com/sequelize/sequelize/tree/main/packages/core/src/associations): `packages/core/src/associations`
- [Data types](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/data-types.ts): `packages/core/src/abstract-dialect/data-types.ts`
- [Query operators](https://github.com/sequelize/sequelize/blob/main/packages/core/src/operators.ts): `packages/core/src/operators.ts`

### Query Runtime

- [Query interface](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/query-interface.js): `packages/core/src/abstract-dialect/query-interface.js`
- [SQL generation](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/query-generator.js): `packages/core/src/abstract-dialect/query-generator.js`
- [Where builder](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/where-sql-builder.ts): `packages/core/src/abstract-dialect/where-sql-builder.ts`
- [Transactions](https://github.com/sequelize/sequelize/blob/main/packages/core/src/transaction.ts): `packages/core/src/transaction.ts`
- [Connection management](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/connection-manager.ts): `packages/core/src/abstract-dialect/connection-manager.ts`

### Database Dialects

- [Dialect configuration](https://github.com/sequelize/sequelize/blob/main/packages/core/src/abstract-dialect/dialect.ts): `packages/core/src/abstract-dialect/dialect.ts`
- [Postgres adapter](https://github.com/sequelize/sequelize/blob/main/packages/postgres/src/dialect.ts): `packages/postgres/src/dialect.ts`
- [MySQL adapter](https://github.com/sequelize/sequelize/blob/main/packages/mysql/src/dialect.ts): `packages/mysql/src/dialect.ts`
- [MariaDB adapter](https://github.com/sequelize/sequelize/blob/main/packages/mariadb/src/dialect.ts): `packages/mariadb/src/dialect.ts`
- [SQLite adapter](https://github.com/sequelize/sequelize/blob/main/packages/sqlite3/src/dialect.ts): `packages/sqlite3/src/dialect.ts`
- [SQL Server adapter](https://github.com/sequelize/sequelize/blob/main/packages/mssql/src/dialect.ts): `packages/mssql/src/dialect.ts`
- [Other adapters](https://github.com/sequelize/sequelize/tree/main/packages): `packages`

### Operations

- [Migration and seed CLI](https://github.com/sequelize/sequelize/tree/main/packages/cli/src/api): `packages/cli/src/api`
- [Migration management](https://github.com/sequelize/sequelize/blob/main/packages/cli/src/api/run-migrations.ts): `packages/cli/src/api/run-migrations.ts`

### Other components

- **Application developer**
- **SQL databases**

## Connections

- Application developer → Sequelize API: uses ORM (evidence: `README.md`)
- Sequelize API → Model operations: exposes model API
- Application developer → Model definitions: defines models (evidence: `README.md`)
- Model definitions → Associations: declares relations (evidence: `packages/core/src/associations/belongs-to.ts`)
- Model definitions → Data types: uses types
- Application developer → Model operations: issues queries (evidence: `README.md`)
- Model operations → Query interface: dispatches queries
- Query interface → SQL generation: requests SQL
- SQL generation → Where builder: builds predicates (evidence: `packages/core/src/abstract-dialect/query-generator.js`)
- Query operators → Where builder: expresses conditions (evidence: `packages/core/src/abstract-dialect/where-sql-builder.ts`)
- Sequelize API → Dialect configuration: configures dialect (evidence: `packages/core/src/abstract-dialect/dialect.ts`)
- Dialect configuration → Connection management: provides manager (evidence: `packages/core/src/abstract-dialect/dialect.ts`)
- Dialect configuration → SQL generation: provides generator (evidence: `packages/core/src/abstract-dialect/dialect.ts`)
- Dialect configuration → Query interface: provides interface (evidence: `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 (evidence: `packages/core/src/abstract-dialect/connection-manager.ts`)
- Application developer → Migration and seed CLI: runs maintenance (evidence: `README.md`)
- Migration and seed CLI → Migration management: runs migrations
- Migration management → SQL databases: changes schema
- Sequelize API → Transactions: supports transactions (evidence: `README.md`)
