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
Continue with Drizzle ORM
Save the full cheat sheet or work through every related task.