Skip to content

Supabase Reader

Supabase Reader reads records from a table in your Supabase project and passes them to the flow, with the columns you name and up to the number of records you choose.

When to use it

  • Load the list of customers or products your application keeps in Supabase.
  • Give an agent the latest orders so it can prepare a report.
  • Go through the records of a table to process them one by one.

Configuration

The component needs a Supabase API credential with your project’s address and its secret key. See Credentials.

FieldWhat it does
Credential (required)The Supabase credential. It fills in Project URL and API Key.
Table Name (required)The table the records are read from.
Columns Name (required)The columns you want to read. * reads them all. Default: *.
Max RecordsThe maximum number of records read. Default: 10.

Output

The Records output returns one item per record read, with the name of each column and its value.

Example

A shop keeps its application’s orders in Supabase:

  1. Add Supabase Reader, pick the credential and enter orders in Table Name.
  2. In Columns Name, enter the columns customer, amount and status.
  3. In Max Records, enter 50.
  4. Connect Records to an agent that prepares a summary of the pending orders.

Good practices

  • Read only the columns you need: the result is lighter and easier to use.
  • Set Max Records to the number of records you expect; by default only 10 are read.
  • Supabase: reads, creates, changes and deletes Supabase records.
  • Loop: goes through the records one by one.