AI Agent to Chat with Files in Supabase Storage

This n8n workflow transforms Supabase Storage into a smart document repository by integrating AI agents for conversational access to your files. It automatically detects new uploads, processes PDFs and text files by extracting content, generates vector embeddings, and stores them in Supabase's vector database for efficient retrieval-augmented generation (RAG).

Key steps include fetching and deduplicating files to prevent redundant processing, downloading and parsing content based on file type, chunking text for optimal embedding, creating AI embeddings (e.g., via OpenAI), and upserting vectors into Supabase. A separate query path allows users to ask questions in natural language, retrieving relevant contexts for accurate AI responses.

Ideal for researchers, analysts, and business owners managing document libraries, it saves hours of manual searching by enabling instant, context-aware answers. No need for Google Drive or Pinecone—leverage Supabase fully. Benefits include scalability, cost-efficiency, and seamless n8n automation for production use cases like knowledge bases, customer support, or internal wikis.