1. guides
prorm
  • prorm documentation
  • Known test gaps
  • Architecture
  • Core concepts
  • Database types & coverage
  • Getting started
  • Going further
  • compliance
    • Compliance
    • The security toolkit: `prorm audit`
    • Checklists by regulation
    • Declaring personal data
    • Evidence bundles
    • Evidence
    • Frameworks: `@Security`
    • Jurisdictions
    • Platform policies
    • Protecting data
    • The regulation dataset
    • Residency and cross-border transfers
    • Retention & integrity
    • Status
    • Subject rights
  • decorators
    • prorm with decorators
    • Models with decorators
    • Querying a decorated model
    • Relations with decorators
  • diagrams
    • Diagram generators
    • Chen diagram
    • Class diagram
    • Dependency diagram
    • ER diagram
    • Flow diagram
    • From your models to a diagram
    • Gantt diagram
    • Index diagram
    • Migration diagram
    • Model diagram
    • Package diagram
    • Crow’s-foot diagram
    • Schema documentation
    • Sequence diagram
    • State diagram
    • Tree diagram
  • dialects
    • SQL dialects
    • AlloyDB Dialect
    • AlloyDB Omni Dialect
    • Amazon Athena Dialect
    • Aurora DSQL Dialect
    • Amazon Aurora MySQL Dialect
    • Amazon Aurora PostgreSQL Dialect
    • Azure Database for MySQL Dialect
    • Azure Database for PostgreSQL Dialect
    • Azure SQL Database Dialect
    • Azure SQL Managed Instance Dialect
    • Google BigQuery Dialect
    • Citus Dialect
    • ClickHouse dialect
    • Cloud Authentication (`cloud-auth`)
    • Cloud SQL for SQL Server Dialect
    • Cloud SQL for MySQL Dialect
    • Cloud SQL for PostgreSQL Dialect
    • CockroachDB Dialect
    • Azure Cosmos DB for PostgreSQL Dialect
    • CrateDB Dialect
    • Cloudflare D1 Dialect
    • Databricks dialect
    • IBM Db2 Dialect
    • Dolt Dialect
    • Apache Doris Dialect
    • Druid Dialect
    • DuckDB Dialect
    • Exasol dialect
    • Microsoft Fabric Data Warehouse Dialect
    • Firebird Dialect
    • Greenplum Dialect
    • SAP HANA Dialect
    • MySQL HeatWave Dialect
    • Azure Data Explorer (Kusto) Dialect — T-SQL
    • MariaDB Dialect
    • Materialize Dialect
    • MonetDB Dialect
    • MotherDuck Dialect
    • Microsoft SQL Server Dialect
    • MySQL Dialect
    • Neon Dialect
    • OceanBase Dialect
    • openGauss Dialect
    • Oracle Dialect
    • Oracle Autonomous Database Dialect
    • ParadeDB Dialect
    • PolarDB Dialect
    • PostgreSQL Dialect
    • Presto Dialect
    • QuestDB Dialect
    • Aurora RDS Data API Dialect (`rdsdata`)
    • Amazon RDS for Db2 Dialect
    • Amazon RDS for MariaDB Dialect
    • Amazon RDS for SQL Server Dialect
    • Amazon RDS for MySQL Dialect
    • Amazon RDS for Oracle Dialect
    • Amazon RDS for PostgreSQL Dialect
    • Amazon Redshift
    • Amazon Redshift Data API Dialect
    • RisingWave Dialect
    • rqlite Dialect
    • SingleStore Dialect
    • Snowflake Dialect
    • Google Cloud Spanner Dialect
    • Spanner (PostgreSQL interface) Dialect
    • SQLite Dialect
    • StarRocks Dialect
    • Supabase Dialect
    • Azure Synapse Analytics (dedicated SQL pool)
    • Teradata Dialect
    • TiDB Dialect
    • TimescaleDB Dialect
    • Trino Dialect
    • Turso / libSQL Dialect
    • Vertica dialect
    • Vitess Dialect
    • Yellowbrick Dialect
    • YugabyteDB Dialect
  • guides
    • Access rules and behaviour profiles
    • ArangoDB (AQL)
    • Associations
    • Audit levels and escalation
    • Audit logging
    • In the browser
    • Bulk operations
    • Caching
    • Capabilities, tiers and team roles
    • CLI
    • Cloudflare
    • Compliance & data protection
    • Connection Pooling & Performance
    • Security in the console
    • Couchbase: structured N1QL queries
    • Data types
    • Decorators
    • Eager loading
    • Enums and constants
    • Error handling & error types
    • Extensions
    • External fields
    • Foreign data wrappers
    • Graph databases
    • Hooks & lifecycle events
    • Indexes & constraints
    • InfluxDB: structured Flux pipelines
    • klock-errors
    • klock — the `.klock` file
    • Local databases (`prorm db up`)
    • Structured log search — Splunk, Graylog, Papertrail, Sumo Logic
    • Logging
    • Grafana Loki: structured LogQL queries
    • MCP server
    • Migrate — the data transfer subsystem
    • Migrations & Schema Sync
    • Models from an existing database
    • Defining models
    • Multiple databases
    • OrientDB, Neptune and TigerGraph
    • Passwords
    • Importing a Prisma schema
    • Structured PromQL and MetricsQL
    • Query firewall
    • QueryInterface
    • Query operators reference
    • Query optimization
    • Composing find options with `pipe()` and `Q`
    • Query safety: the fail-closed WHERE guard
    • Querying
    • Raw Queries & Query Building
    • Read replicas
    • Schema diffing & migration generation
    • Views, triggers & other schema objects
    • Scopes & default scopes
    • Seeders
    • SPARQL / RDF triplestores
    • SQL constants
    • SQL features
    • SQL function builders
    • SQLite advanced features
    • StoreKey — a prod-orm database as the storage
    • Streaming results
    • Terraform
    • Transactions & Isolation Levels
    • Type mapping: legacy and modern
    • TypeScript types
    • Database users, roles & privileges
    • Validation & constraints
    • Virtual & Computed Fields
    • Writing docs
  • javascript
    • prorm in JavaScript
    • Models in JavaScript
    • Querying in JavaScript
    • Relations in JavaScript
  • runbooks
    • Operational runbooks
    • Connection failures
    • Credential rotation
    • Failover
    • Incident checklist
    • Deploying klock v2
    • Migration rollback
  • running-databases
    • Running databases in Docker
    • Running prorm under Bun in Docker
    • Running Cassandra in Docker with prorm
    • Running ClickHouse in Docker with prorm
    • Running CockroachDB in Docker with prorm
    • Running prorm under Deno in Docker
    • Running Elasticsearch in Docker with prorm
    • Running MariaDB in Docker with prorm
    • Running MongoDB in Docker with prorm
  • prorm control plane
    • Introduction
    • Authentication
    • Errors
    • Getting started
      • Service
        • Is it up
        • This description
    • Account
      • Sign-up and verification
        • Create an account
        • Exchange credentials for a token
        • Verify with the emailed code
        • Verify by clicking the emailed link
        • Name the parent or guardian
        • What a consent link is about
        • Give consent for a child's account
        • Ask the parent or guardian again
        • Send a new code and link
      • Family
        • Everyone this account is responsible for
        • One child, in detail
        • Turn a limit on or off
      • Profile
        • Who am I
        • Change the account
        • Every address on the account
        • Add an address
        • Confirm an address with the code mailed to it
        • Mail a fresh code to an unconfirmed address
        • Make an address primary
        • Remove an address
        • What this caller may do
    • Security
      • Sessions
        • Everywhere this account is signed in
        • Sign out everywhere else
        • Sign one out
        • A token for the CLI on a named machine
        • A token for the customer console, from the staff one
        • Park a sign-in for the CLI to collect
        • The CLI collecting its sign-in
        • The team's members' live sessions
        • Sign a member's session out
        • Sign an account out everywhere
        • Everywhere the account is signed in
        • Sign an account's session out
      • Single sign-on
        • Begin a single sign-on
        • The provider's return
        • Link the signed-in account to a team's provider
        • Which team an address signs in to
        • The team's single sign-on, as a member sees it
        • Set the team's OpenID Connect provider up, or change it
        • Remove the provider
        • The team's domain claims and the DNS record each needs
        • Prove a claimed domain
      • MFA and passwords
        • Start enrolling a second factor
        • Prove the app has it
        • Remove the second factor
        • Ask for a reset link
        • Set a new password with the emailed token
      • Klock
        • Open a device-bound klock session
        • Check in, for the next grant
        • Step up the session asking
        • Rotate the device key
        • Freeze a session
        • Unfreeze a session
        • A guest grant
        • The revocation feed
        • The published keyset
        • What this control plane supports
      • Devices
        • Your devices, or a team's
        • Approve a new device's pairing code
        • One device
        • Rename a device
        • Revoke a device
        • Suspend a device
        • Reinstate a suspended device
        • Wipe a device
        • Ask a device to rotate its key
        • The team's members' devices
        • Revoke a member's device
        • An account's devices
        • Revoke an account's device
        • Wipe an account's device
        • The device fleet
      • Access rules and behaviour
        • The access rules that bear on you
        • Add an access rule
        • This request, as the rules see it
        • One access rule
        • Remove an access rule
        • The behaviour profiles that bear on you
        • Add or change a behaviour profile
        • The profile presets
        • Your behaviour findings
        • Acknowledge a finding
        • One behaviour profile
        • Remove a behaviour profile
        • The team's access rules
        • Add a team access rule
        • Remove a team access rule
        • The team's behaviour profiles
        • Add or change a team behaviour profile
        • Remove a team behaviour profile
        • What the team's profiles caught
        • Acknowledge a team finding
      • Recovery and lockdown
        • Ask for a recovery link
        • Recover access with the emailed code
        • Is the account locked down
        • Lock the account down
        • Release a lockdown
        • Lock a member down
        • Release a member's lockdown
      • MCP tokens
        • Make a delegated token for one MCP client
        • The account's delegated tokens
        • Revoke a delegated token
        • What a delegated token may do now
        • Run one MCP tool with a delegated token
        • Run a device-signed MCP tool call relayed by the MCP Worker
      • Kerberos
        • Give the team its own Kerberos realm
        • The team's realm
        • Remove the team's realm
    • Logging and monitoring
      • Audit log
        • What has been done to the account
        • What has happened to this account
        • The account's audit trail
      • Operations
        • Everything that has been asked of this database
        • One, with its steps
        • Stop it
        • Put a failed one back in the queue
        • Every operation, across all accounts
      • Metrics and events
        • Every measurement, for a graph
        • Who did what to it
    • Billing
      • Plans and pricing
        • What the plans allow
        • The rate card
        • What one database would cost
        • What this account is paying for, itemised
      • Subscriptions and invoices
        • What this month's invoice will say
        • What this account is on
        • What it has been charged
        • Start a Stripe Checkout session
        • Open the customer portal
        • Stripe's events
        • Buy more connection pools
      • Team billing
        • The team's billing account
        • What the team has been charged
        • What this month's invoice will say
        • The team's cards
        • Add a card, through a Stripe-hosted setup session
        • Make a card the team's default
        • Remove a card
        • Start the team paying
        • Open the Stripe portal on the team's customer
        • Change the team's plan
        • Who receives the team's bills
        • How the team pays for transfers
    • Support
      • Support chat
        • My conversations
        • Start a conversation
        • Every support conversation, open first
        • A ticket for the socket
        • One conversation, with who is in it and who is connected
        • Rename a group; open or close a support conversation
        • The lines, oldest first
        • Say something
        • Add somebody
        • Mark read
    • Administration
      • Users
        • Every account
        • One account, with everything hanging off it
        • Grant or revoke admin
        • Verify an account by hand
        • Lock or unlock sign-in
        • Allow or hold provisioning
        • Send the verification mail again
        • Set the plan by hand
      • Platform
        • Every database and store, across all accounts
        • The counts worth putting on a dashboard
      • Staff and permissions
        • What kind of admin the caller is, and which scopes they hold
        • The admin presets
        • Every admin, and the scopes each resolves to
        • Make an account an admin of a kind
        • Change an admin's kind, or a custom admin's scopes
        • Revoke admin
      • Team administration
        • Every team, with its owner and size
        • One team in full — members with their accounts, and projects
        • Hand the team to another member
        • Put an account in the team, active at once
        • Change a member's role
        • Remove a member
      • Assumed identities
        • Assume an identity — act as a customer account
        • The identities the caller holds open
        • End an assumed identity
      • Support inbox
        • The platform's addresses
        • Add a platform address
        • One address, with its counts
        • Change an address's label, routing, or whether it accepts mail
        • Remove an address that holds no mail
        • Make, adopt or repair the address's routing rule
        • Every admin's personal address, made where missing
        • File a raw message, as if it had arrived
        • The inbox
        • One message, whole
        • Mark a message
        • Hand a message to an admin, or take it back
        • Leave an internal note
        • Reply, from the address the message came to
        • What is waiting
    • Databases
      • Databases
        • Data stores
          • Every data store on the account
          • Provision a data store
          • Change a data store that is already running
          • One data store
          • Deprovision it
          • Report what it is using
          • How to reach a data store
        • Connections and credentials
          • The api keys on a database
          • Issue a key
          • Revoke a key
          • The engine users we created
          • Create a user inside the database
          • Give a user a new password
          • Drop a user
          • How the database is reached
          • Set how it is reached
          • Revoke every api key on it
          • How to connect to it
          • The ssh keys that open its bastion
          • Add a key, or have one made
          • The private half of a generated key, once
          • Revoke an ssh key
        • Schema and objects
          • The SQL objects we put in it
          • Create one, and apply it
          • What is in the database, as the engine reports it
          • One table
          • What it would run, without running it
          • Redefine an object in place
          • Drop it
          • The extensions installed in it
        • Migrations
          • A plan compiled to statements, recording nothing
          • The migrations recorded for it
          • Record one
          • Apply everything recorded and not yet run
          • Apply everything pending, oldest version first
        • Lifecycle
          • Grow or shrink it
          • Stop it accepting connections
          • Start it again
          • Move it to another region
        • Backups and replicas
          • Take a backup
          • The backups it has
          • Restore one into it
          • What has been restored into it, and from where
          • Its read copies
          • Add one
        • Policies
          • The catalog
          • One policy
          • What this database is held to
          • Switch a policy on, or change its knobs
          • Switch it off
          • Mark the policies reviewed
          • Evaluate the periodic policies now
          • Who is behind a credential
        • Passwordless
          • The database's passwordless sessions
          • Issue a passwordless session (v1)
          • Revoke a passwordless session
          • Bind a session to a device key
          • Issue a v2 session for a host to bind
          • Redeem an enrolment ticket on the host
          • Check a passwordless credential
          • Run one described query under a passwordless credential
        • Database roles
          • The database's roles
          • Define a role
          • One role
          • Change what a role permits
          • Delete a role, and revoke every key granted it
          • Grant a role, which mints a key
          • Who holds a role
          • The api keys bound to a role
        • Pools
          • A database's connection pools, and how busy each is
          • Open another pool
          • Rename a pool or change its size
          • Close a pool
        • Data plane
          • Run a query against a database
          • Several statements, in order, over one connection
          • Is this database answering
          • What the proxy itself is holding
        • Transfers
          • The strategies this account's tier may use
          • Price a transfer without creating it
          • The account's transfer jobs, newest first
          • Create a transfer job
          • One job, and whether its certificate holds
          • Cancel an unfinished job
          • Start a created job, confirming its price
          • Report a job's status (the runner, or the owner's side of a local run)
        • Every database on the account
        • Provision a database
        • Change a database that is already running
        • One database
        • Deprovision it
        • Read or write it
        • Report what it is using
        • The engines this API will provision
        • Where a managed database can be put
    • Teams
      • Teams
        • Members
          • Who is on it
          • Invite somebody
          • Accept an invitation
          • Change somebody's role
          • Remove somebody
        • Projects
          • The projects a team runs
          • Start one
          • Rename a project, or move its environment
          • Delete a project
          • One project, and what is in it
          • Put a database or store in it
          • What is in a project
          • Take one out
        • The teams this account is on
        • Start one
        • The twelve roles, and what each may do
        • Rename a team
        • Close a team
        • One team
        • Hand the team to somebody else
        • Leave a team
    • Schemas
      • Error
      • ValidationErrors
      • Token
      • PolicyCategory
      • PolicySeverity
      • PolicyAction
      • PolicyTrigger
      • PolicyParam
      • Policy
      • PolicyCatalog
      • PolicyAssignment
      • PolicyOutcome
      • PolicyFiring
      • CredentialTrace
      • Relation
      • Restrictions
      • ChildSummary
      • SignupRequest
      • SigninRequest
      • UpdateMeRequest
      • User
      • Address
      • GeoPoint
      • D1Region
      • Usage
      • UsageReport
      • Resource
      • Database
      • DataStore
      • NewDatabase
      • NewDataStore
      • QueryRequest
      • DatabasePrivilege
      • ApiKey
      • DbUser
      • Access
      • AccessRequest
      • DatabaseObject
      • NewDatabaseObject
      • NewMigration
      • SchemaOperation
      • Migration
      • Operation
      • Session
      • AdminPowers
      • Admin
      • AuditEntry
      • TeamRole
      • Conversation
      • ChatMessage
      • TeamSso
      • Team
      • TeamMember
      • SshKey
      • ConnectionInfo
      • InboxAddress
      • InboxMailbox
      • InboxMessageSummary
      • InboxMessage
      • InboxNote
      • Page
      • Quote
      • Plan
      • ApiError
      • CapabilityRefusal
      • KlockErrorCode
      • PageWindow
      • SessionView
      • KlockStepUpRequest
      • KlockOpenRequest
      • KlockOpenedSession
      • UpdateMeResult
      • CapabilitiesView
      • SessionLimits
      • Device
      • DeviceListed
      • DeviceTeamRef
      • DeviceCommand
      • DeviceAuditLine
      • DeviceActionRequest
      • StaffActionRequest
      • ManagedSession
      • SessionRevoked
      • AccessRule
      • AccessRuleRequest
      • BehaviourProfile
      • BehaviourProfileRequest
      • BehaviourProfileSaved
      • BehaviourFinding
      • BehaviourFindingAck
      • StepUpProof
      • Removed
      • MemberLockdownRequest
      • McpClient
      • McpDelegatedView
      • McpToolCall
      • McpForwardRequest
      • PasswordlessScope
      • RoleScope
      • PasswordlessSession
      • PasswordlessTlsMaterial
      • PasswordlessKerberosMaterial
      • ServiceDeviceKeys
      • ServiceSession
      • DatabaseRole
      • TransferEndpoint
      • TransferJobRequest
      • TransferQuote
      • TransferStrategy
      • TransferJob
      • TransferJobAccess
      • Pool
      • PoolAllowance
      • BillingSubscription
      • Invoice
      • BillingContact
      • PaymentMethod
      • UpcomingCharges
      • TeamBilling
      • TeamKerberosRealm
      • TeamSsoDomain
      • TeamSsoResponse
      • StoreConnection
      • BatchFailure
      • ProxyStatus
  1. guides

Hooks & lifecycle events

Hooks are functions that Prorm runs automatically at well-defined points in a
model's lifecycle — before and after validation, creation, updates, deletes,
and finds. They let you hash a password before it is written, stamp an audit
field, cascade side effects, or veto an operation by throwing — all without
scattering that logic across every call site.
Every hook is dispatched through the model's HooksManager, which stores the
handlers you register and invokes them in registration order. This guide covers
the complete set of lifecycle events, how to attach handlers, what arguments
they receive, the order in which they fire, and some practical patterns.
[!NOTE]
Every order and argument on this page was recorded by registering all the
hooks on a prorm.define() model (SQLite) and logging each call alongside the
SQL it produced. The scripts are ordinary Prorm code; if you depend on an
order, a test that records it the same way is cheap insurance.

Firing order#

The full create path — Model.create(), save() on a new instance, and each
row of bulkCreate(rows, { individualHooks: true }):
beforeCreate runs before beforeSave, and afterCreate before
afterSave. If validation fails, the sequence stops after beforeValidate:
afterValidate and everything after it are skipped and a ValidationError is
thrown.
The update path — instance.update(values) and save() on a loaded, changed
instance — runs the per-instance update hooks and the bulk pair, because the
single-row write goes through the same UPDATE machinery as Model.update():
beforeSave and afterSave wrap both create and update, so logic that
applies to either belongs there rather than duplicated across the pair. Inside
a transaction the hooks receive the transaction in options.transaction, so a
throw rolls back the write along with anything the hook did on it.

The lifecycle hooks that exist#

Prorm defines these hooks (the HookName union / ModelHooks interface). They
come in before* / after* pairs:
HookFires around
beforeValidate / afterValidateinstance validation on the create path
beforeCreate / afterCreateinserting a single record
beforeUpdate / afterUpdateupdating — one instance, or once per Model.update() call
beforeDestroy / afterDestroydeleting — one instance, or once per Model.destroy() call
beforeSave / afterSaveboth insert and update of an instance
beforeBulkCreate / afterBulkCreateModel.bulkCreate()
beforeBulkUpdate / afterBulkUpdateevery UPDATE, static or instance
beforeBulkDestroy / afterBulkDestroyevery delete, static or instance
beforeFind / afterFindfindAll / findOne / findByPk
beforeCountModel.count()
beforeUpsert / afterUpsertModel.upsert()
beforeReload / afterReload are also valid names (they are ModelHook
members). A define() model's reload() fires no hook: it re-reads the row
with hooks: false, so a beforeFind that rewrites the where cannot make
it load a different row. Earlier releases fired beforeFind / afterFind
for it.

Defining hooks in define()#

The most common way to attach hooks is the hooks object in the third argument
of define(). Each key is a hook name and each value is a handler.
import { Prorm, DataTypes } from 'ts-prorm-orm';

const prorm = new Prorm({ dialect: 'sqlite', storage: ':memory:' });
await prorm.connect();

const User = prorm.define(
  'User',
  {
    id: { type: DataTypes.INTEGER(), primaryKey: true, autoIncrement: true },
    name: { type: DataTypes.STRING(100), allowNull: false },
    email: { type: DataTypes.STRING(255), allowNull: false },
    status: { type: DataTypes.STRING(20), defaultValue: 'pending' },
  },
  {
    tableName: 'users',
    timestamps: true,
    hooks: {
      beforeCreate: async (values: any) => {
        // Normalise data before it is written. On the create path this is the
        // plain values object: assign properties, there is no get()/set() yet.
        values.status = 'active';
      },
      afterCreate: async (instance) => {
        console.log(`Created user ${instance.get('id')}`);
      },
    },
  },
);
Handlers may be synchronous or async; Prorm always awaits them, so returning
a promise is fully supported. A value a before* hook assigns is written:
the INSERT is built after beforeCreate / beforeSave have run.

Attaching hooks after definition#

You can also register hooks on an already-defined model with hook(name, fn),
or with addHook(name, id, fn), which gives the handler an id you can remove it
by later (registering the same id again replaces the handler instead of
stacking a second copy). A common layout keeps each cross-cutting concern in its own
module that registers against the model at startup:
src/
  db/
    index.ts             # defines the models, then imports ./hooks
    hooks/
      normalise-user.ts  # beforeCreate: trim and lower-case the email
      audit.ts           # afterSave / afterDestroy: write audit rows
      cache.ts           # afterSave / afterDestroy: evict cache keys
import type { ModelStatic } from 'ts-prorm-orm';

export function registerNormaliseUser(User: ModelStatic) {
  User.addHook('beforeCreate', 'normalise-user', (user: any) => {
    user.email = String(user.email).trim().toLowerCase();
    user.slug = String(user.name).toLowerCase().replace(/\s+/g, '-');
  });
}
await User.create({ email: '  Ada@Example.COM ', name: 'Ada Lovelace' });
Registration is additive — calling hook() twice for the same event registers
two handlers, and both run in the order they were added. To inspect or remove
handlers:
User.hasHook('beforeCreate'); // => true

// Remove one handler by the id it was registered with…
User.removeHook('beforeCreate', 'normalise-user');

// …or by the handler function itself…
const stamp = (user: any) => { user.importedAt = new Date(); };
User.addHook('beforeCreate', stamp);
User.removeHook('beforeCreate', stamp);

// …or every handler for an event.
User.removeHook('beforeCreate');
User.hasHook('beforeCreate'); // => false
[!NOTE]
Before 4.9.2, removeHook removed by id only: passing the handler
function left it registered and running. It now matches either.
The named shortcuts (User.beforeUpdate(fn), User.afterDestroy(fn), …)
exist on decorator (Model class) models only; on a define() model they
are undefined, so use hook('beforeUpdate', fn).

Hook arguments#

What each hook receives depends on the call that fired it — an instance for
instance operations, the options object for static ones:
Hook, fired byArguments
beforeValidate, afterValidate, beforeCreate, beforeSave on the create path(record, options) — the values about to be inserted, with the instance API (get, set, changed(), dataValues, isNewRecord: true)
afterCreate, afterSave on the create path(instance, options)
update and destroy hooks from save / instance.update / instance.destroy(instance, options)
beforeUpdate / afterUpdate, from static Model.update(values, opts)(values, options) — a plain object, not an instance
beforeDestroy / afterDestroy, from static Model.destroy(opts)(options) — with where
beforeBulkUpdate / beforeBulkDestroy(options) — with where (and attributes for updates)
beforeBulkCreate / afterBulkCreate(instances, options)
beforeFind(findOptions) — mutable
afterFind(instances, findOptions)
beforeCount(countOptions)
beforeUpsert(values)
[!IMPORTANT]
Before the INSERT there is no stored row yet: on the create path
beforeValidate, afterValidate, beforeCreate and beforeSave get the
values about to be inserted with the instance API over them —
record.get('email'), record.set({ slug }), record.setDataValue(…),
record.changed('email') (every attribute given is a change) and
record.dataValues. Plain assignment (record.email = …) works too, and
whatever a hook writes goes into the INSERT. It has no save(),
reload() or destroy(); from afterCreate on the argument is a real
instance. (Before the next release after 4.9.4, a define() model handed
these hooks the plain values object, with no get or set.)
[!CAUTION]
The same beforeUpdate handler is called with an instance from
user.update() and with a plain values object from User.update(). A
handler that calls instance.get() or instance.changed() throws on the
static path. Check before you use it:
User.addHook('beforeUpdate', 'lowercase-email', (target) => {
  const isInstance = typeof (target as any).get === 'function';
  const email = isInstance ? target.get('email') : (target as any).email;
  if (typeof email === 'string') {
    isInstance ? target.set('email', email.toLowerCase()) : ((target as any).email = email.toLowerCase());
  }
});
options carries the triggering call's options (a HookOptions), including
transaction. Use options.transaction to keep any additional queries you run
inside the same transaction:
User.hook('beforeCreate', async (instance, options) => {
  instance.slug = slugify(instance.name);
  await AuditEntry.create(
    { action: 'user.create', name: instance.name },
    { transaction: options?.transaction },
  );
});
Bulk hooks receive the array of records for creates:
User.hook('beforeBulkCreate', (instances, options) => {
  for (const instance of instances ?? []) {
    instance.status = 'imported';
  }
});
Find hooks can rewrite the query before it runs. A beforeFind that adds a
condition — a tenant filter, say — changes the SQL for every finder:
User.hook('beforeFind', (findOptions) => {
  findOptions.where = { ...(findOptions.where ?? {}), status: 'active' };
});

User.hook('afterFind', (instances) => {
  console.log(`Loaded ${instances.length} user(s)`);
});

await User.findAll({ where: { email: 'ada@example.com' } });
A beforeFind handler may also return a new options object instead of
mutating the one it was given; with several handlers, each one receives what
the previous returned.

Ordering#

Hooks fire in a fixed sequence per operation. Within a single event, multiple
registered handlers run in the order they were added. The sequences below are
exactly what was recorded, statement included:
Model.create(values) · build(values).save() · bulkCreate(rows, { individualHooks: true }), per row
  beforeValidate → afterValidate → beforeCreate → beforeSave
  → INSERT
  → afterCreate → afterSave

Validation failure:
  beforeValidate → ValidationError thrown (nothing else runs, nothing is sent)
instance.update(values) · instance.save() on a loaded row
  beforeUpdate → beforeSave → beforeBulkUpdate
  → UPDATE
  → afterBulkUpdate → afterUpdate → afterSave

Model.update(values, { where }) — with or without individualHooks
  beforeUpdate(values) → beforeBulkUpdate(options)
  → UPDATE
  → afterUpdate → afterBulkUpdate
instance.destroy()
  beforeDestroy → beforeBulkDestroy
  → DELETE (or UPDATE … SET "deletedAt" on a paranoid model)
  → afterBulkDestroy → afterDestroy

Model.destroy({ where }) — with or without individualHooks
  beforeDestroy(options) → beforeBulkDestroy(options)
  → DELETE / UPDATE
  → afterDestroy → afterBulkDestroy
findAll · findOne · findByPk
  beforeFind → SELECT → afterFind

instance.reload()
  SELECT (no hooks)

count
  beforeCount → SELECT COUNT(*)

upsert
  beforeUpsert
  → beforeFind → SELECT → afterFind
  → INSERT … ON CONFLICT DO UPDATE
  → beforeFind → SELECT → afterFind
  → afterUpsert
Model.bulkCreate(rows)
  beforeBulkCreate
  → INSERT (one per row)
  → afterBulkCreate
  No validation and no per-row hooks.

Model.bulkCreate(rows, { individualHooks: true })
  beforeBulkCreate
  → for each row: beforeValidate → afterValidate → beforeCreate → beforeSave → INSERT → afterCreate → afterSave
  → afterBulkCreate
Things this order implies:
individualHooks only matters for bulkCreate. Model.update() and
Model.destroy() already call beforeUpdate / beforeDestroy once per
call, with the options, and passing individualHooks: true does not change
that — it does not load and visit each row.
Updates skip the validate hooks. instance.update() still validates
(see Validation), but
beforeValidate / afterValidate do not fire for it; put update-time
normalisation in beforeUpdate or beforeSave.
A handler on beforeBulkUpdate sees instance updates too, so do not
treat it as "someone ran a mass update".
// Bulk import that should go through the same normalisation as a signup.
await User.bulkCreate(rows, { individualHooks: true });

Skipping hooks#

Every write accepts hooks: false to bypass hook execution — useful for seeds,
migrations, or internal maintenance where you do not want side effects to fire.
await User.create({ name: 'System', email: 'system@example.com' }, {
  hooks: false,
});
By default hooks are on (hooks defaults to true); passing hooks: false is
the only value that disables them.
hooks: false is honoured by create(), bulkCreate(), instance.save()
(new or already saved), instance.update(), the static Model.update() and
Model.destroy(), and findAll(): no model hook fires, including the bulk
pair around the INSERT, UPDATE or DELETE.
[!NOTE]
Before 4.9.2, instance.save({ hooks: false }) on an already-saved row
still fired beforeUpdate and beforeBulkUpdate, and the static
Model.update() and findAll() ignored hooks: false. Until the next
release after 4.9.4, the static Model.destroy({ where, hooks: false })
still fired beforeBulkDestroy / afterBulkDestroy, and a define()
model's bulkCreate(rows, { hooks: false }) still fired
beforeBulkCreate / afterBulkCreate.

Validation hooks#

beforeValidate / afterValidate fire around validation on the create path,
and around instance.validateRules() when you opt in:
const result = await user.validateRules({ hooks: true });
beforeValidate is the right place to coerce or normalise input so that the
values that reach the validators are already clean:
User.hook('beforeValidate', (instance) => {
  if (typeof instance.email === 'string') {
    instance.email = instance.email.trim().toLowerCase();
  }
});
Before and after, with an isEmail rule on email:

Practical patterns#

Hashing a password before write. A beforeCreate hook keeps hashing logic in
one place (for new code, the secure attribute option does
this for you):
declare function hashPassword(plain: string): Promise<string>; // your own, e.g. argon2

User.hook('beforeCreate', async (instance) => {
  instance.password = await hashPassword(instance.password);
});
Generating a value the database cannot. A beforeCreate hook is also the
reliable way to fill a UUID or slug column, because what it assigns is part of
the INSERT (see the warning in Data types):
import { randomUUID } from 'node:crypto';

User.hook('beforeCreate', (instance) => {
  if (!instance.publicId) instance.publicId = randomUUID();
});
Vetoing an operation. Throwing from any before* hook aborts the operation —
the error propagates to the caller unchanged and the write never happens.
User.hook('beforeDestroy', (instance) => {
  if (instance.role === 'owner') {
    throw new Error('Cannot delete the workspace owner');
  }
});
Error: Cannot delete the workspace owner
Cascading side effects transactionally. Use options.transaction so the side
effect commits or rolls back with the triggering write:
User.hook('afterCreate', async (instance, options) => {
  await Profile.create(
    { userId: instance.id },
    { transaction: options?.transaction },
  );
});

await prorm.transaction(async (t) => {
  await User.create({ name: 'Ada', email: 'ada@example.com' }, { transaction: t });
  // the Profile insert above ran on `t`; a throw here rolls back both rows
});
Cache invalidation on delete. afterDestroy runs once the row is gone:
User.hook('afterDestroy', (instance) => {
  cache.evict(`user:${instance.id}`);
});
Because hooks are just functions registered on the model, you can compose them
freely — layer several handlers on one event, register cross-cutting concerns
(audit, cache, search indexing) from separate modules, and disable them per-call
with hooks: false whenever you need the raw operation.

Next: Transactions — making several writes succeed or fail together.

Related reading#

Validation — what runs between beforeValidate and afterValidate
Enums — ModelHook / PrormHook instead of strings
Core concepts — the reading path these belong to
Going further — the specialised material
Modified at 2026-10-04 00:40:16
Previous
Graph databases
Next
Indexes & constraints
Built with