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.
Based on the search results, this appears to be a known issue with Supabase Vector Store nodes returning empty arrays. Here are the key troubleshooting steps:
• **Check your Supabase function setup** - Ensure the `match_documents` function is properly created in your database. According to [community.n8n.io]( Error with Supabase Vector Stores ), you need to run the complete SQL setup script that creates both the table and the search function.
• **Test with a simple query first** - Try using the Supabase Vector Store in “Insert Documents” mode first to confirm the connection works, then switch back to “Retrieve Documents” mode. This helps isolate whether it’s a connection or retrieval-specific issue.
• **Check table/column naming** - Table names with spaces (like “Sollex Products”) can sometimes cause issues. Try creating a test table with a simple name (no spaces, lowercase) to see if that resolves the problem.
