8
n8n 中文网amn8n.com

MCP Supabase代理

高级

这是一个Engineering, Product, Building Blocks, AI领域的自动化工作流,包含 16 个节点。主要使用 SupabaseTool, Agent, McpTrigger, ChatTrigger, LmChatOpenAi 等节点,结合人工智能技术实现智能自动化。 MCP Supabase代理 - 使用AI管理数据库

前置要求
  • Supabase URL 和 API Key
  • OpenAI API Key
工作流预览
可视化展示节点连接关系,支持缩放和平移
导出工作流
复制以下 JSON 配置到 n8n 导入,即可使用此工作流
{
  "id": "L83OjjR3vfmZ0eIc",
  "meta": {
    "instanceId": "6a52f06a38696cfa8d3a5b70f84891fab02c428a5c2d448dcef39b1f17adf12b",
    "templateCredsSetupCompleted": true
  },
  "name": "MCP Supabase",
  "tags": [],
  "nodes": [
    {
      "id": "3991bb96-f1ee-461a-b515-db32142558c6",
      "name": "创建行",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -360,
        -600
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "bf55f6bc-4c5f-4869-ab5e-f1af93cb6aa8",
      "name": "删除行",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -260,
        -600
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "27e5cf9c-b566-4792-9143-d9b6eda09100",
      "name": "搜索单行",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -20,
        -600
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "556637e4-079a-4d1c-bb4b-29fbbe1c3224",
      "name": "搜索所有行",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        120,
        -600
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "e483de63-b3f4-4702-b364-75b7fe5cfb52",
      "name": "更新行",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -160,
        -600
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "141d4d1d-4603-4a9a-b6cf-76e2df1107b3",
      "name": "MCP 服务器 Supabase",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        -260,
        -760
      ],
      "webhookId": "6dd1c2f6-d052-40da-b047-1e2eff92111a",
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "33526dbd-e593-43b8-8683-7fffd41cab74",
      "name": "AI 代理",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        -780,
        -760
      ],
      "parameters": {},
      "typeVersion": 1.8
    },
    {
      "id": "646d19ca-13b5-4555-b20e-65ec29515c30",
      "name": "当收到聊天消息时",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -960,
        -740
      ],
      "webhookId": "10460287-1834-423d-81a4-dc2fa6d0dfff",
      "parameters": {},
      "typeVersion": 1.1
    },
    {
      "id": "2e169de1-8f11-4bc7-a0d9-30c79519d2ef",
      "name": "模型聊天",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        -820,
        -600
      ],
      "parameters": {},
      "typeVersion": 1.2
    },
    {
      "id": "018376ce-9597-498f-8b3d-3b731efbd7f8",
      "name": "简单记忆",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        -700,
        -600
      ],
      "parameters": {},
      "typeVersion": 1.3
    },
    {
      "id": "1ed67f63-197d-4178-8b6c-5fd26d3a01b5",
      "name": "MCP Supabase",
      "type": "@n8n/n8n-nodes-langchain.mcpClientTool",
      "position": [
        -580,
        -600
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "8b2e910b-4f82-46f2-a354-7cf908d8d89f",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1020,
        -1260
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "c27e14ce-100b-41e0-9095-d03bb53c6ebb",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1020,
        -880
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "6c8763d4-51ed-432b-972d-62d3e5b2f403",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -880
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "9f9978f0-e0eb-4a3a-a739-81b3a924cbd7",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -400,
        -1260
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    },
    {
      "id": "dd2ec159-cda6-4268-8f15-0dd3e262de48",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1020,
        -440
      ],
      "parameters": {
        "content": "确保您的表名与实际知识库结构匹配"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "be6f0ca1-6775-4514-918d-9e3225bfb20c",
  "connections": {
    "Create Row": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Supabase",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Delete Row": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Supabase",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Model Chat": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Update Line": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Supabase",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "MCP Supabase": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Search All Lines": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Supabase",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Search Single Line": {
      "ai_tool": [
        [
          {
            "node": "MCP Server Supabase",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "When chat message received": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
常见问题

如何使用这个工作流?

复制上方的 JSON 配置代码,在您的 n8n 实例中创建新工作流并选择「从 JSON 导入」,粘贴配置后根据需要修改凭证设置即可。

这个工作流适合什么场景?

高级 - 工程, 产品, 构建模块, 人工智能

需要付费吗?

本工作流完全免费,您可以直接导入使用。但请注意,工作流中使用的第三方服务(如 OpenAI API)可能需要您自行付费。

工作流信息
难度等级
高级
节点数量16
分类4
节点类型8
难度说明

适合高级用户,包含 16+ 个节点的复杂工作流

作者
Amanda Benks

Amanda Benks

@amanda

Hi loves! I've been making workflows for n8n for two years, and I hope you like my flows <3

外部链接
在 n8n.io 查看

分享此工作流