Skip to content
Nappai Documentation

Supabase Reader

The Supabase Reader lets you pull records from a Supabase database table so you can use that data in your Nappai automations.

⚠️ DEPRECATION WARNING

This component is deprecated and will be removed in a future version of Nappai. Please migrate to the recommended alternative components.

How it Works

The component connects to your Supabase database using the URL and service key you provide. It then queries the specified table, selecting the columns you list and limiting the number of rows returned. The retrieved data is returned as a list of Data objects that can be passed to other components in your workflow.

Inputs

Before using the component, make sure you have created a Supabase API credential in Nappai’s Credentials section. Then select that credential in the component’s Credential field.

Input Fields

  • Columns Name: A list of specific fields you want to retrieve from each record.
  • Max Records: The maximum number of records to retrieve from the table.
  • Table Name: The name of the table within your Airtable base where records will be fetched from.

Outputs

  • Records: A list of Data objects containing the rows fetched from the specified Supabase table. Each object includes the record’s data and an id field as the text key.

Usage Example

  1. Configure Credential
    In the Nappai dashboard, go to Credentials, add a new Supabase API credential, and paste your Supabase URL and Service Key.

  2. Add Supabase Reader
    Drag the Supabase Reader component into your workflow.

  3. Set Inputs

    • Credential: Select the credential you just created.
    • Table Name: users
    • Columns Name: id, name, email
    • Max Records: 10

  4. Connect to Next Component
    Connect the Records output to the next component (e.g., a data transformer or a notification sender).

The component will fetch up to 10 rows from the users table, returning the id, name, and email fields for each row.

  • Supabase Writer – Write new records to a Supabase table.
  • Supabase Updater – Update existing records in a Supabase table.

Tips and Best Practices

  • Use * in Columns Name to retrieve all columns from the table.
  • Keep the Max Records value reasonable to avoid large payloads that can slow down your workflow.
  • Ensure the credential you use has read permissions for the tables you want to access.
  • If you need to filter records, consider adding a filter step after the reader or using a custom query in the Supabase Manager.

Security Considerations

  • The Supabase URL and Service Key are stored securely as a credential; they are never exposed in the workflow UI.
  • Avoid sharing the workflow with users who do not need access to the underlying data.
  • Regularly rotate your Supabase Service Key and update the credential in Nappai to maintain security.