Upsert (On Conflict) in Drizzle ORM

From the Drizzle ORM cheat sheet · Insert / Update / Delete · verified Jul 2026

Upsert (On Conflict)

Insert or update on conflict using onConflictDoUpdate or onConflictDoNothing.

typescript

// Upsert — update on conflict
await db.insert(users).values({
  email: 'alice@example.com',
  name: 'Alice Updated',
}).onConflictDoUpdate({
  target: users.email,
  set: { name: 'Alice Updated' },
});

💡 target must be a unique or PK column(s)

⚡ sql`excluded.*` references incoming values

📌 onConflictDoNothing silently skips duplicates

🟢 Combine with .returning() to get final row

insertupsertconflict

More Drizzle ORM tasks

Insert Rows
Update Rows
Delete Rows

Back to the full Drizzle ORM cheat sheet