Supabase Memory icon

Supabase Memory

AI Agent memory node — save, load, search & delete structured data in any Supabase table with custom field mapping and SQL-like filters.

Actions6

Load Memory

AI-generated

Overview

The node loads data from a specified Supabase table with optional SQL-like filters, sorting, pagination, and column selection. It is useful for retrieving structured data from a Supabase database, such as loading agent memory records or other stored information for further processing or analysis.

Use Case Examples

  1. Load all records from the 'agent_memory' table where 'session_id' equals a specific value, returning only selected columns like 'id', 'content', and 'created_at'.
  2. Retrieve a paginated list of records from a Supabase table, sorted by creation date in descending order, with filters applied to narrow down the results.

Properties

Name Meaning
Table Name The Supabase table to operate on, selected either from a list or by manual name entry.
Columns to Return Comma-separated list of columns to return from the table, supporting PostgREST syntax. Use '*' to select all columns.
Filters SQL-like filters to apply to the query. Multiple filters are combined with AND. Each filter includes a field, operator, and value.
Order By Sort the returned results by specified columns and directions (ascending or descending).
Limit Maximum number of records to return, between 1 and 10,000.
Offset Number of records to skip for pagination, minimum 0.

Output

JSON

  • json - Each item contains a JSON object representing a record loaded from the Supabase table, with fields as specified by the selected columns.

Dependencies

  • Supabase API credentials including Supabase URL and service role key

Troubleshooting

  • Ensure the Supabase credentials are correct and have sufficient permissions to read from the specified table.
  • Verify that the table name is correct and accessible.
  • Check that the filters are properly formatted and valid for the Supabase query.
  • If no data is returned, confirm that the filters and pagination settings are not excluding all records.

Links

Discussion