Supabase Vector Store Node isn't passing query through to Supabase

Questions
1

I have an issue with the Supabase Vector Store node as part of my workflow. What I am trying to do is search a database which has a vector column within it for rows that match a query/keyword.

I know the vector search is working as I have tested it inside of Supabase directly.

But it doesn’t work when using the Supabase Vector Store node. There are no errors, it just returns results that all have a match of 0.99. I have run some tests trying to log the search, and the filter/query appears to be null or empty when I have been testing which says the query isn’t being passed through from n8n.

The fact all results come back with a 0.99 match, when they have no match at all with the query shows that something isn’t quite right.

The setup I have I have attached screenshots for. I believe my SQL function on Supabase is fine. It’s the query not being passed through, or is it something else?

I have been battling with this for hours, and many AI chats, which all take me down the same rabbit hole, with the same solutions that do not fix it.

Does anyone have any ideas what could be going on here?

I can’t upload screenshots as it keeps giving me an error that a date string is not allowed, so I have uploaded both screenshots of n8n node setup here:

[Album] imgur.com
2
  • Test by entering a fixed and simple word in the Query field of the node.
  • Log the incoming query parameter in your Supabase SQL function to check if it is empty or not.
  • Review the node configuration and the parameter names you are using.
  • If possible, manually test the Supabase query in n8n (for example, using the HTTP Request node) to verify whether the search query is being passed correctly.
3

Thanks for the points to look at.

I have done the first one, and also now added logging and the filter object is indeed empty coming from n8n. The parameters look fine too. I have no idea why it wouldn’t pass the query through? I have recreated the node from scratch also just to be sure, but still the same results.