SupabaseReader

The SupabaseReader component is designed to fetch records from a Supabase database. It allows users to specify which table and columns to retrieve data from, with an option to limit the number of records. This component is useful for users who want to access specific data from their Supabase projects easily.

Relationship with Supabase

The SupabaseReader component interacts directly with the Supabase API to access and retrieve data from your Supabase database. It uses the SupabaseManager to handle database interactions, ensuring that the data retrieval process is seamless and efficient.

Inputs

Project URL: The unique URL of your Supabase project, required to connect to your database.
Table Name: The name of the table in your Supabase database from which you want to retrieve records.
Columns Name: A list of specific fields you wish to retrieve from each record. By default, all columns are selected.
Max Records: The maximum number of records to retrieve from the table. The default is 10.
Credential: Credentials required to access the Supabase API.

Outputs

The component produces a list of records from Supabase, formatted as a List[Data]. These records can be used in other parts of your application or system to perform further analysis or processing.

Usage Example

Imagine you have a Supabase database containing customer information, and you want to retrieve the names and emails of the first 10 customers. You would set the Table Name to “customers”, the Columns Name to [“name”, “email”], and the Max Records to 10. The SupabaseReader will then fetch this data for you to use in your dashboard.

Templates

Currently, there are no specific templates where this component is pre-configured. You can create your own templates by configuring the component according to your needs.

Supabase Writer: Allows you to write records to a Supabase database.
libSQLRetrieverTool: Tool for interacting with libSQL Retriever.
Embedding Similarity: Computes similarity between two embedding vectors.
SQLite: Interacts with SQLite databases.

Tips and Best Practices

Ensure your Supabase URL and credentials are correct to avoid connection issues.
Use the Columns Name input to limit the data retrieved to only what you need, improving performance.
Adjust the Max Records input to control the volume of data retrieved, especially if dealing with large datasets.

Security Considerations

Keep your Supabase credentials secure and do not share them publicly.
Regularly update your credentials and access permissions to maintain security.