Rag agent multi-table supabase help

Ive been stuck on this for a few days and nothing ive tried has worked so seeing if someone here may know how to get the result I want

Ive set everything up in Supabase but what i want to have is different tables to search and have specific about that thing. So for instance i have a table of hooks and a buunch of information on the hook like the psychology behind the hook, what is best for, examples, why it works, etc. then i have other tables with other kinds of columns and different information. I dont want to just have every single thing loaded into the standard "documents" table because there are certain information that i want to have in the table that i would not want in another - Like if i want to use a rag agent for all internal company documents loaded in and i want a rag agent that clients can access to ask questions. This would cause major issues having it all in 1 table since the clients may accidentally get internal document information they shouldnt be seeing

Ive tried the supabase vector store directly and even though the embedding node comes back with information the supabase node itself says its empty. Some places have mentioned its because with n8n it can only search the documents table but i feel that defeats the purpose a bit

Has anyone solved this?

0 comments