MCP Supabase server for AI agent with RAG multi tenant CRUD
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 work...
🔌 Nodes & Integrations Used (4)
📖 Implementation & Setup Guide
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 (e.g., `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.
⚡ How to import this workflow into n8n:
- Click the Direct Download JSON button above to save
MCP_Supabase_server_for_AI_agent_with_RAG_multi_tenant_CRUD.json. - Log in to your n8n Cloud or self-hosted n8n instance.
- In your workflow canvas, click the menu in top-right and select Import from File (or paste the JSON directly).
- Configure your credentials (e.g. API keys, database URLs) in the corresponding node settings.
- Click Execute Workflow to test and switch to Active!
Related AI Agents Workflows
View All in AI Agents →5 ways to process images PDFs with Gemini AI in n8n
How it works Many users have asked in the support forum about different methods to analyze images and PDF documents with Google Gemini AI in n8n. This workfl...
7 AI Sales Assistant
Production-ready n8n automation template for 7 AI Sales Assistant built by AhiXLight. Seamlessly connects Airtop Tool, Slack, Airtop with 24 configured nodes.
AAVE portfolio professional AI agent Telegram Email GPT 4o
A next-generation AI-powered DeFi health monitor that tracks wallet positions across Aave V3 using GPT-4o and LangChain. It delivers human-readable reports v...
Access control for AI agents RBAC using Airtable and Telegram
Purpose This workflow allows granular control over the access to tools connected to AI Agents (including Multi-Agent setups) using Role Based Access Control....