Supabase Vector Store - LangChain AI

Describe the problem/error/question

Insert - Supabase Vector Store. I am having trouble making it work.
I’m a no-code, rather than code developer and perhaps i’m doing something wrong in terms of the setup on the supabase end? I did enable the vector extension and added the vector column to the table. but I don’t see any additional options which I need to fill in, in order to make this work.

What is the error message (if any)?

I’m getting the following error: Problem in node ‘Supabase Vector Store‘ Error inserting: Column 'content' of relation 'item_quote' does not exist 400 Bad Request

Please share your workflow

Share the output returned by the last node

NodeOperationError: Error inserting: Column 'content' of relation 'item_quote' does not exist 400 Bad Request
    at Object.populateVectorStore (/usr/local/lib/node_modules/n8n/packages/@n8n/nodes-langchain/dist/nodes/vector_store/VectorStoreSupabase/VectorStoreSupabase.node.js:108:23)
    at processTicksAndRejections (node:internal/process/task_queues:95:5)
    at Object.execute (/usr/local/lib/node_modules/n8n/packages/@n8n/nodes-langchain/dist/nodes/vector_store/shared/createVectorStoreNode.js:173:21)
    at Workflow.runNode (/usr/local/lib/node_modules/n8n/packages/workflow/dist/Workflow.js:696:19)
    at /usr/local/lib/node_modules/n8n/packages/core/dist/WorkflowExecute.js:656:53

Information on your n8n setup

  • n8n version: n8n@ai-beta
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default
  • Running n8n via (Docker, npm, n8n cloud, desktop app): cloud
  • Operating system:

@MutedJam any thoughts on this?

Supabase Vector Insert/pull doesn’t have much documentation on how it works.

Hi @Eden, I don’t use Supabase as a vector store but this sounds like it could be a problem with the db initialization. The content column is created by the initial SQL documented on LangChain | Supabase Docs.

Perhaps @oleg knows more here?

The whole Vector store thing is overly complex, wasn’t able to get Supabase Vectors to work, there’s no tutorials and the Interface as to how to make it work is unclear…

Also looked for templates I could copy, but couldn’t find any, only for pinecone.