Supabase AI Agent with RAG & Multi-Tenant CRUD

Version : 1.0.0
n8n Version : 1.88.0+
Author : Koresolucoes
License : MIT

Description

A stateful AI agent workflow powered by Supabase and Retrieval-Augmented Generation (RAG) . Enables persistent memory, dynamic CRUD operations, and multi-tenant data isolation for AI-driven applications like customer support, task orchestration, and knowledge management.

Key Features :

• 🧠 RAG Integration : Leverages OpenAI embeddings and Supabase vector search for context-aware responses.
• 🗃️ Full CRUD : Manage agent_messages , agent_tasks , agent_status , and agent_knowledge in real time.
• 📤 Multi-Tenant Ready : Supports per-user/organization data isolation via dynamic table names and webhooks.
• 🔒 Secure : Role-based access control via Supabase Row Level Security (RLS).

Use Cases

1. Customer Support Chatbots : Persist conversation history and resolve queries using institutional knowledge.
2. Automated Task Management : Track and update task statuses dynamically.
3. Knowledge Repositories : Store and retrieve domain-specific information for AI agents.

Instructions

1. Import Template

• Go to n8n > Templates > Import from File and upload this workflow.

2. Configure Credentials

• Add your Supabase and OpenAI API keys under Settings > Credentials .

3. Set Up Multi-Tenancy (Optional)

• Dynamic Webhook Path :
  Replace the default webhook path with /mcp/tool/supabase/:userId to enable per-user routing.
• Table Names :
  Use a Set Node to dynamically generate table names (eg, agent_messages_ {{userId}} ).

4. Activate & Test

• Enable the workflow and send test requests to the webhook URL.

Tags

AI Agent RAG Supabase CRUD Multi-Tenant OpenAI Automation

Screenshots

License

This template is licensed under the MIT License.