Supabase Auth

sb_upsert_records

Upsert (insert or update on conflict) records in a Supabase table. Uses merge-duplicates by default. Specify on_conflict for non-primary-key columns.

Remote node2flow/supabase

Other tools also called sb_upsert_records? See providers with this name

Input Schema


            {
  "type": "object",
  "properties": {
    "table": {
      "type": "string",
      "description": "Table name"
    },
    "return": {
      "enum": [
        "representation",
        "minimal",
        "headers-only"
      ],
      "type": "string",
      "description": "Return preference"
    },
    "select": {
      "type": "string",
      "description": "Columns to return when return=representation"
    },
    "_fields": {
      "type": "string",
      "description": "Comma-separated list of fields to include in the response"
    },
    "records": {
      "description": "Single record object or array of record objects to upsert"
    },
    "resolution": {
      "enum": [
        "merge-duplicates",
        "ignore-duplicates"
      ],
      "type": "string",
      "description": "Conflict resolution strategy (default: merge-duplicates)"
    },
    "on_conflict": {
      "type": "string",
      "description": "Column(s) to detect conflicts on, if not primary key. Example: email"
    }
  }
}