Supabase icon

Supabase

Interact with Supabase database and storage

Database → Create

AI-generated

Summary

Insert a new row into a specified table in the Supabase database.

Inputs

  • UI Mode — Choose 'Simple' to input column-value pairs using form fields, or 'Advanced' to input raw JSON data for more flexibility.
  • Table (required) — Select or manually enter the name of the table where the new row will be created.
  • Columns — In 'Simple' UI mode, define one or more columns and their values to set in the new row.
  • JSON Data — In 'Advanced' UI mode, provide a JSON object representing the row data to insert.

Output shape

a list containing the newly created row(s) as JSON objects

The output contains the created database row(s) reflecting the inserted data. Use 'Simple' mode for form-based input or 'Advanced' mode to supply raw JSON data. Errors in operation may interrupt execution unless 'Continue On Fail' is enabled.

Examples

Example 1: Create a new user record using simple mode

Set UI Mode to 'Simple', select table 'users', and add columns such as 'name' and 'email' with respective values.

Example 2: Insert a record with complex nested data

Set UI Mode to 'Advanced' and provide the entire row data as JSON under 'JSON Data' parameter.

Discussion