---
title: "Upsert"
description: "Local-first visual environment for building and running AI workflows. Build agents visually, deploy anywhere, privacy by design."
canonical: https://docs.nodetool.ai/nodes/lib/supabase/upsert
markdown: https://docs.nodetool.ai/nodes/lib/supabase/upsert.md
product: NodeTool
source: https://github.com/nodetool-ai/nodetool/blob/main/docs/nodes/lib/supabase/upsert.md
---

# Upsert

**Type:** `lib.supabase.Upsert`

**Namespace:** `lib.supabase`

## Description

Insert or update (upsert) records in a Supabase table.
    supabase, database, upsert, merge

## Properties

| Property | Type | Description | Default |
|----------|------|-------------|---------|
| table_name | `str` | Table to upsert into | `` |
| records | `union[list[dict[str, any]], dict[str, any]]` | One or multiple rows to upsert | `[]` |
| return_rows | `bool` | Return upserted rows (uses select('*')) | `true` |

## Outputs

| Output | Type | Description |
|--------|------|-------------|
| output | `any` |  |

## Related Nodes

Browse other nodes in the [lib.supabase](./) namespace.