How to Set Up Supabase and Postgres for Memory and RAG in n8n

Learn to integrate Supabase with n8n for implementing PostgreSQL chat memory and RAG vector storage in this 12-minute tutorial. Discover the differences between PostgreSQL and Supabase, then follow step-by-step instructions to authenticate connections and configure your setup. Build a basic AI agent with PostgreSQL chat memory functionality, test the memory system, and establish a Supabase vector store for Retrieval-Augmented Generation (RAG). Master the process of uploading files to your vector database and validate your complete RAG system implementation through practical testing exercises.

Syllabus

00:00 Overview of video
00:40 What is Postgres vs. Supabase
01:19 Setting up the basic AI agent
01:40 How to set up Postgres Chat Memory
05:26 Testing the Postgres Chat Memory
06:16 How to set up Supabase Vector Store for RAG
08:55 Upload files to your Supebase Vector Store
10:48 Testing the RAG system we just built
11:27 Outro & closing thoughts