RAG Agent with Supabase Vector Store

Questions
1

Hi N8N community! :wave:

I’m integrating Supabase with N8N to perform vector searches on pgvector-stored documents. My SQL function works fine in Supabase, but the JSONB metadata filter doesn’t work when called from N8N.

image
image2150×1564 265 KB

image
image1276×774 63.2 KB

I tried everything, it seems like another filter ils passed through in the background creating a conflict ?

The same filter working well in sql directly in supabase:

image
image2448×1566 206 KB

I noticed also that it works as intended when I do the same but in a node “Retrieve documents As vector store for chain tools” but when it’s “Retrieve documents as tool for AI Agent” the presence of a metadata filter causes an error

  • n8n version: 1.76.1
  • Database : Supabase
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via: n8n cloud
  • Operating system: Mac

Thank you in advance !

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

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

I am experiencing the same issue :frowning:

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.