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

Run SQL

AI-generated

Overview

This node operation executes a Supabase RPC (Remote Procedure Call) function, which is essentially a stored procedure or SQL function on the Supabase database. It allows users to run custom SQL logic encapsulated in these functions with parameters passed as a JSON object. This is useful for performing complex queries or operations that are predefined in the database, such as advanced searches, data transformations, or batch processing.

Use Case Examples

  1. Calling a stored procedure to search memories with specific criteria.
  2. Executing a custom SQL function to aggregate data and return summarized results.

Properties

Name Meaning
Function Name The name of the Supabase RPC function to call.
Function Parameters (JSON) A JSON object with the parameters to pass to the RPC function.

Output

JSON

  • result - The result returned by the RPC function if it is a single object or value.
  • json
    • `` - An array of objects returned by the RPC function if it returns multiple rows.

Dependencies

  • Requires a Supabase API key credential with URL and service role key for authentication.

Troubleshooting

  • Ensure the RPC function name is correct and exists in the Supabase database.
  • Verify the JSON parameters are correctly formatted and match the expected input of the RPC function.
  • Check for permission issues with the service role key used for authentication.
  • Common error messages include 'Supabase RPC error' followed by the database error message, which indicates issues with the function execution or parameters.

Discussion