MCP Supabase AI Agent: RAG & Multi-Tenant CRUD

n8n AI Product Customer Support

Contributed by Sabrina Ramonov 🍄. From the community directory at agents.sabrina.dev, republished with permission and full credit.

Supabase AI Agent with RAG & Multi-Tenant CRUDVersion: 1.0.0n8n Version: 1.88.0+Author: KoresolucoesLicense: MIT

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:

- Customer Support Chatbots: Persist conversation history and resolve queries using institutional knowledge.

- Automated Task Management: Track and update task statuses dynamically.

- Knowledge Repositories: Store and retrieve domain-specific information for AI agents.

Tools used: OpenAI, Supabase, AI Agent

Download the workflow template (JSON)

Original tutorial

Want this running in your business? KOBA42 builds and operates automations like this one.