Describe the problem/error/question
I have two Supabase Vector Store nodes configured identically in “Retrieve Documents (As Tool for AI Agent)” mode, but one returns results while the other returns an empty array.
Working setup:
Table: blog_posts
Index: ivfflat with vector_cosine_ops
Returns results correctly 
Not working setup:
Table: Sollex Products
Index: ivfflat with vector_cosine_ops (same as working table)
Returns empty array 
What I’ve verified:
- Both tables have embeddings stored (1536 dimensions, text-embedding-3-small)
- Vector similarity search works directly in SQL for both tables
- Regular Supabase “Get Many” operation returns data correctly
- RLS policies are configured (Allow public read access)
- Using service role key credential
- Both use identical Embeddings OpenAI node configuration
What is the error message (if any)?
No error - just returns “[empty array]” in the output.
Please share your workflow
Additional context: I think the issue seems specific to the “Retrieve Documents (As Tool for AI Agent)” operation mode. The exact same table structure and index configuration works for one table but not the other. Both tables are in the same Supabase database, just diffrent tables.
Information on your n8n setup
- n8n version: 1.107.4
- Database (default: SQLite):
- n8n EXECUTIONS_PROCESS setting (default: own, main):
- Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
- Operating system: Windows 11