Im trying to create a process where I can use versions of my documents on RAG, using Supabase as Vector Store. I create a table with the necessaire fields and the related functions, but Im not able to set the query properly on N8N to insert and retrieve the data.
The problem is on N8N Supabase Vector Store node, I did find a way to insert the aditional field in the query (document_id, agent_id, etc) it’s look like this node is make only for the default table on Supabase with only 4 fields (if, content, metadata, embeddings) like the documetation stablish (LangChain | Supabase Docs).
And I don’t know how to do it with another generic node, like code or httprequest.
Did some one have done something like that?
Adding information: I already use Supabase as a vector store with that simpe table (4 fields) and it works great, the problem is when my project demands constant info attualization. And with that model I have to create an table for each agent or Client. For example, I have a workflow to support actual and former employees of a company, theres an agent for actual employees and another for former, each with its own group of infromation to insert on the RAG.
hey can you check your supabase API settings? when using the HTTP Request node, make sure you’re hitting the correct table’s REST endpoint and your headers include the apikey and Authorization: Bearer yourapikey — without this, supabase will just block your request or return empty. Also make sure the data you’re inserting is structured correctly. supabase expects JSON with keys matching your table columns. if you’re storing vectors, you might be passing them wrong — they should be stored as arrays (e.g. [0.12, 0.98, …]) and your table column should be set up to accept that (type: float8)
hope this helps, cheers
The problem is on N8N Supabase Vector Store node, I did find a way to insert the aditional field in the query (document_id, agent_id, etc) it’s look like this node is made only for the default table on Supabase, with only 4 fields (if, content, metadata, embeddings) like the doccunetation stablish (LangChain | Supabase Docs).
And I don’t know how to do it with another generic node, like code or httprequest.
Adding information: I already use Supabase as a vector store with that simpe table (4 fields) and it works great, the problem is when my project demands constant info attualization. And with that model I have to create a table for each agent or Client. For example, I have a workflow to support actual and former employees of a company, theres an agent for actual employees and another for former, each with its own group of infromation to insert on the RAG.