Skip to content
masterclass Buddy
Start learning

Supabase · Method

.upsert

upsert() inserts rows that do not exist and handles rows that conflict with a primary key or chosen unique column. Use select() if the changed rows should be returned.

Last updated

Syntax

upsert(values, options)

In-depth API docs are only for subscribers: parameters, examples, common mistakes and interview practice.

Subscribe
  • insert()
  • select()
  • update()
  • onConflict
  • ignoreDuplicates

Source: JavaScript API Reference | Supabase Docs. Checked 2026-11-03.