MCP Supabase Agent – Manage Your Database with AI

Go to Workflow
2,308 views
Built by Amanda Benks Amanda Benks
Created on June 13, 2026

Description

Hi, I’m Amanda 🌷
This workflow was built with love to help you manage your Supabase database using natural language, powered by the MCP (Multi-Channel Protocol) AI Agent on n8n.

With just a message like “update the status to active where city is New York”, your agent will know exactly what to do — safely, step by step, and always asking for confirmation before deleting anything.

It’s ideal for developers who want a smart assistant to create, update, delete or search database records without writing SQL or opening Supabase.

What this workflow does

Receives messages through a chat interface or webhook
Translates them into actions using GPT-4o (via LangChain Agent)
Interacts with Supabase using a custom MCP tool
Supports create, update, delete, search (single or all rows)
Handles confirmations, validations, and missing data checks

Setup (quick and easy 💫)

Connect your Supabase credentials
Adjust your table and field names
Link the MCP webhook to your AI frontend (Typebot, WhatsApp, etc.)
Customize the system message to reflect your tone of voice
Start chatting — your agent is ready to assist!

✅ Works on n8n Cloud and Self-Hosted
🧠 Built with GPT-4o + LangChain + Supabase + MCP Trigger
💡 No code or SQL required

Want it tailored to your project?
❤️ Buy Workflows: https://iloveflows.gumroad.com
💬 Hire My Services: +5517991557874 (WhatsApp)

Nodes Used (4)

AI Agent
@n8n/n8n-nodes-langchain.agent
MCP Client Tool
@n8n/n8n-nodes-langchain.mcpClientTool
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow