Servidor de agente AI MCP de Supabase

Avanzado

Este es unBuilding Blocks, AIflujo de automatización del dominio deautomatización que contiene 27 nodos.Utiliza principalmente nodos como SupabaseTool, McpTrigger, EmbeddingsOpenAi, VectorStoreSupabase, combinando tecnología de inteligencia artificial para lograr automatización inteligente. Servidor de agente de IA MCP Supabase con soporte para RAG y CRUD multiinquilino

Requisitos previos
  • URL y Clave de API de Supabase
  • Clave de API de OpenAI
Vista previa del flujo de trabajo
Visualización de las conexiones entre nodos, con soporte para zoom y panorámica
Exportar flujo de trabajo
Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo
{
  "id": "oowUGM7ey6gWxzEG",
  "meta": {
    "instanceId": "6d46e25379ef430a7067964d1096b885c773564549240cb3ad4c087f6cf94bd3",
    "templateCredsSetupCompleted": true
  },
  "name": "MCP_SUPABASE_AGENT",
  "tags": [],
  "nodes": [
    {
      "id": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
      "name": "MCP_SUPABASE",
      "type": "@n8n/n8n-nodes-langchain.mcpTrigger",
      "position": [
        -1460,
        1180
      ],
      "webhookId": "affff59c-9c5c-4a07-b531-616c1d631601",
      "parameters": {
        "path": "affff59c-9c5c-4a07-b531-616c1d631601"
      },
      "typeVersion": 1
    },
    {
      "id": "b25040a8-2d70-4d3a-ba58-b8c7164d375e",
      "name": "RAG",
      "type": "@n8n/n8n-nodes-langchain.vectorStoreSupabase",
      "position": [
        1240,
        760
      ],
      "parameters": {
        "mode": "retrieve-as-tool",
        "topK": 5,
        "options": {},
        "toolName": "ITERACOES",
        "tableName": {
          "__rl": true,
          "mode": "list",
          "value": "documents",
          "cachedResultName": "documents"
        },
        "toolDescription": "lembra das interacoes e consulta as instrucoes do system como assim tambem vai guardando o que aprende"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "081035c0-ecc2-4924-8f07-da4cbb69fb06",
      "name": "Incrustaciones OpenAI",
      "type": "@n8n/n8n-nodes-langchain.embeddingsOpenAi",
      "position": [
        1500,
        960
      ],
      "parameters": {
        "model": "text-embedding-ada-002",
        "options": {}
      },
      "credentials": {
        "openAiApi": {
          "id": "zUnIUrOWA279vAoC",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "361e0a74-b386-4e03-9e7b-5f435f0d8c5f",
      "name": "Nota adhesiva",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -260,
        120
      ],
      "parameters": {
        "width": 1380,
        "height": 520,
        "content": "## AGENT_MESSAGE\n"
      },
      "typeVersion": 1
    },
    {
      "id": "5aafb3a6-edd1-4154-adab-948db9aad8e7",
      "name": "Nota adhesiva1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -260,
        720
      ],
      "parameters": {
        "width": 1380,
        "height": 520,
        "content": "## AGENT_TASK\n"
      },
      "typeVersion": 1
    },
    {
      "id": "61b75c2e-b472-4597-a12a-f6027caecf4e",
      "name": "Nota adhesiva2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -260,
        1320
      ],
      "parameters": {
        "width": 1380,
        "height": 520,
        "content": "## AGENT_STATUS\n\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "7adc4cd9-cbac-4922-b928-f0b556d6f839",
      "name": "Nota adhesiva3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -260,
        1900
      ],
      "parameters": {
        "width": 1380,
        "height": 520,
        "content": "## AGENT_KNOWLEDGE\n\n"
      },
      "typeVersion": 1
    },
    {
      "id": "7680abd0-d5f1-41db-96ad-d64c1b857032",
      "name": "ELIMINAR_REGISTRO_INSCRIPCIONES_CURSOS",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        260,
        2020
      ],
      "parameters": {
        "tableId": "agent_knowledge",
        "operation": "delete"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5c752cf4-6dde-49d9-9328-2ed0731c6d7a",
      "name": "OBTENER_REGISTRO_MENSAJE_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        80,
        260
      ],
      "parameters": {
        "tableId": "agent_messages",
        "operation": "get"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "f65e9fd3-a656-473c-a7af-217d9b041aa7",
      "name": "CREAR_REGISTRO_MENSAJE_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -100,
        260
      ],
      "parameters": {
        "tableId": "agent_messages"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "61269957-e6ac-4e5b-adb0-fd610cdff8aa",
      "name": "ELIMINAR_REGISTRO_MENSAJE_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        260,
        260
      ],
      "parameters": {
        "tableId": "agent_messages",
        "operation": "delete"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "52db9de5-5610-4b2d-9194-e1551b95a4e6",
      "name": "ACTUALIZAR_REGISTRO_MENSAJE_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        440,
        260
      ],
      "parameters": {
        "tableId": "agent_messages",
        "operation": "update"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "b43aaea6-7841-4848-9228-2be6dd07a03f",
      "name": "OBTENER_MULTIPLES_REGISTROS_MENSAJE_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        620,
        260
      ],
      "parameters": {
        "limit": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Limit', ``, 'number') }}",
        "tableId": "agent_messages",
        "operation": "getAll"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "c5347c5e-f9cb-40aa-bca5-249e8c220839",
      "name": "CREAR_REGISTRO_TAREAS_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -100,
        840
      ],
      "parameters": {
        "tableId": "agent_tasks"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "85e3c8e1-6a75-40ce-a344-4a8fd3a1ae16",
      "name": "OBTENER_REGISTRO_TAREAS_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        80,
        840
      ],
      "parameters": {
        "tableId": "agent_tasks",
        "operation": "get"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "7dacc138-a3aa-4483-a79c-5f2eee915c72",
      "name": "ELIMINAR_REGISTRO_TAREAS_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        260,
        840
      ],
      "parameters": {
        "tableId": "agent_tasks",
        "operation": "delete"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "cb942ab1-e7f2-4fd7-bc1e-fa9e559480a1",
      "name": "ACTUALIZAR_REGISTRO_TAREAS_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        440,
        840
      ],
      "parameters": {
        "tableId": "agent_tasks",
        "operation": "update"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ed9cc573-764c-4cda-82f4-796851b16fba",
      "name": "OBTENER_MULTIPLES_REGISTROS_TAREAS_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        620,
        840
      ],
      "parameters": {
        "limit": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Limit', ``, 'number') }}",
        "tableId": "agent_tasks",
        "operation": "getAll"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "d3412d90-6025-4db5-a845-8b1ea6070ea3",
      "name": "CREAR_REGISTRO_ESTADO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -100,
        1440
      ],
      "parameters": {
        "tableId": "agent_status"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "843a2b92-8fb4-4453-9517-b37e07148f52",
      "name": "OBTENER_REGISTRO_ESTADO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        80,
        1440
      ],
      "parameters": {
        "tableId": "agent_status",
        "operation": "get"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "9a075b33-23fa-487c-b139-41e7e4794831",
      "name": "ELIMINAR_REGISTRO_ESTADO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        260,
        1440
      ],
      "parameters": {
        "tableId": "agent_status",
        "operation": "delete"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "a066b99d-15f4-4c3e-bab6-4423b749bb74",
      "name": "ACTUALIZAR_REGISTRO_ESTADO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        440,
        1440
      ],
      "parameters": {
        "tableId": "agent_status",
        "operation": "update"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "be9930a8-4e01-4823-a0be-4adfd06dd29c",
      "name": "OBTENER_MULTIPLES_REGISTROS_ESTADO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        620,
        1440
      ],
      "parameters": {
        "limit": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Limit', ``, 'number') }}",
        "tableId": "agent_status",
        "operation": "getAll"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "01fbbe34-81e7-4017-a10e-ef7137024d6a",
      "name": "CREAR_REGISTRO_CONOCIMIENTO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        -100,
        2020
      ],
      "parameters": {
        "tableId": "agent_knowledge"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5ba9e5eb-76bb-499c-b93b-5cca7286259b",
      "name": "OBTENER_REGISTRO_CONOCIMIENTO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        80,
        2020
      ],
      "parameters": {
        "tableId": "agent_knowledge",
        "operation": "get"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "a25cef14-0cf0-4ded-81f0-cde300f74432",
      "name": "ACTUALIZAR_REGISTRO_INSCRIPCIONES_CONOCIMIENTO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        440,
        2020
      ],
      "parameters": {
        "tableId": "agent_knowledge",
        "operation": "update"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "1c1fae2e-97f9-449f-913a-8ac730c1f145",
      "name": "OBTENER_MULTIPLES_REGISTROS_CONOCIMIENTO_AGENTE",
      "type": "n8n-nodes-base.supabaseTool",
      "position": [
        620,
        2020
      ],
      "parameters": {
        "limit": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('Limit', ``, 'number') }}",
        "tableId": "agent_knowledge",
        "operation": "getAll"
      },
      "credentials": {
        "supabaseApi": {
          "id": "yfa6fXRKgmrEx175",
          "name": "Supabase account"
        }
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d32edd9b-7508-45a9-adcc-049543647145",
  "connections": {
    "b25040a8-2d70-4d3a-ba58-b8c7164d375e": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings OpenAI": {
      "ai_embedding": [
        [
          {
            "node": "b25040a8-2d70-4d3a-ba58-b8c7164d375e",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "85e3c8e1-6a75-40ce-a344-4a8fd3a1ae16": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "843a2b92-8fb4-4453-9517-b37e07148f52": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "5c752cf4-6dde-49d9-9328-2ed0731c6d7a": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "c5347c5e-f9cb-40aa-bca5-249e8c220839": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "7dacc138-a3aa-4483-a79c-5f2eee915c72": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "cb942ab1-e7f2-4fd7-bc1e-fa9e559480a1": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "d3412d90-6025-4db5-a845-8b1ea6070ea3": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "9a075b33-23fa-487c-b139-41e7e4794831": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "5ba9e5eb-76bb-499c-b93b-5cca7286259b": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "a066b99d-15f4-4c3e-bab6-4423b749bb74": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "f65e9fd3-a656-473c-a7af-217d9b041aa7": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "61269957-e6ac-4e5b-adb0-fd610cdff8aa": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "ed9cc573-764c-4cda-82f4-796851b16fba": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "52db9de5-5610-4b2d-9194-e1551b95a4e6": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "be9930a8-4e01-4823-a0be-4adfd06dd29c": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "01fbbe34-81e7-4017-a10e-ef7137024d6a": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "b43aaea6-7841-4848-9228-2be6dd07a03f": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "7680abd0-d5f1-41db-96ad-d64c1b857032": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "1c1fae2e-97f9-449f-913a-8ac730c1f145": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "a25cef14-0cf0-4ded-81f0-cde300f74432": {
      "ai_tool": [
        [
          {
            "node": "135ceeee-77cd-479f-a0b4-dd72abe23ac4",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  }
}
Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Avanzado - Bloques de construcción, Inteligencia Artificial

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.

Información del flujo de trabajo
Nivel de dificultad
Avanzado
Número de nodos27
Categoría2
Tipos de nodos5
Descripción de la dificultad

Adecuado para usuarios avanzados, flujos de trabajo complejos con 16+ nodos

Autor
Luciano Gutierrez

Luciano Gutierrez

@koresoluciones

🇧🇷 Argentino de 30 anos e fundador da KORE Soluções em Belo Horizonte (MG). Há 1 ano, fornecemos automações, cursos, configurações e manutenção de workflows, ajudando empresas a aumentar eficiência e escalar processos com tecnologia. 🇺🇸 I’m a 30‑year‑old Argentine founder of KORE Soluções in Belo Horizonte (MG). For 1 year, we’ve delivered automations, courses, configuration, and workflow maintenance, helping businesses boost efficiency and scale processes with technology.

Enlaces externos
Ver en n8n.io

Compartir este flujo de trabajo

Categorías

Categorías: 34