Oracle One Imersao Agentes Ia Aula02

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "oracle-one-imersao-agentes-ia_aula02",
  "nodes": [
    {
      "parameters": {
        "options": {}
      },
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "typeVersion": 1.4,
      "position": [
        -928,
        -208
      ],
      "id": "5fe92e28-c379-4ce1-aaa8-601aac0c24f2",
      "name": "When chat message received"
    },
    {
      "parameters": {
        "options": {
          "systemMessage": "Voc\u00ea \u00e9 o HR Buddy, assistente virtual de RH da ChocolaTech.\nREGRAS:\n\n1. Sempre responda em portugu\u00eas.\n2. Responda APENAS d\u00favidas relacionadas a RH.\nIDENTIFICA\u00c7\u00c3O DO FUNCION\u00c1RIO:\n- Se o usu\u00e1rio n\u00e3o disser quem \u00e9, pergunte o nome completo dele logo na primeira mensagem.\n- Use a ferramenta MySQL para buscar na tabela funcionarios usando SEMPRE o NOME COMPLETO informado pelo usu\u00e1rio na conversa.\n- Se encontrado: use os saldos de f\u00e9rias e banco de horas.\n- Se n\u00e3o encontrado: n\u00e3o invente dados pessoais. Responda apenas com base nas pol\u00edticas gerais de RH do Vector Store.\nUse a base de conhecimento para d\u00favidas gerais."
        }
      },
      "type": "@n8n/n8n-nodes-langchain.agent",
      "typeVersion": 3.1,
      "position": [
        -544,
        -208
      ],
      "id": "51aa383e-24ea-4194-9976-d15c558543a6",
      "name": "AI Agent"
    },
    {
      "parameters": {
        "options": {}
      },
      "type": "@n8n/n8n-nodes-langchain.lmChatCohere",
      "typeVersion": 1,
      "position": [
        -704,
        16
      ],
      "id": "a6219273-3c52-4616-a216-bb6b9fc175ea",
      "name": "Cohere Chat Model",
      "credentials": {
        "cohereApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {},
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "typeVersion": 1.4,
      "position": [
        -576,
        16
      ],
      "id": "d2d35db9-e754-46c3-bf5c-1c4dd3cb005b",
      "name": "Simple Memory"
    },
    {
      "parameters": {
        "mode": "retrieve-as-tool",
        "toolDescription": "Busque informa\u00e7\u00f5es sobre pol\u00edticas de RH, f\u00e9rias, hor\u00e1rios e rotinas da empresa Chocolatech.",
        "memoryKey": {
          "__rl": true,
          "value": "vector_store_key",
          "mode": "list",
          "cachedResultName": "vector_store_key"
        }
      },
      "type": "@n8n/n8n-nodes-langchain.vectorStoreInMemory",
      "typeVersion": 1.3,
      "position": [
        -448,
        16
      ],
      "id": "83801b60-7b16-4be9-b913-93b5084399f3",
      "name": "Simple Vector Store"
    },
    {
      "parameters": {
        "modelName": "embed-multilingual-v3.0"
      },
      "type": "@n8n/n8n-nodes-langchain.embeddingsCohere",
      "typeVersion": 1,
      "position": [
        -368,
        224
      ],
      "id": "0bcf6ae0-090f-4ee1-964c-c0769048417e",
      "name": "Embeddings Cohere",
      "credentials": {
        "cohereApi": {
          "name": "<your credential>"
        }
      }
    },
    {
      "parameters": {
        "operation": "select",
        "table": {
          "__rl": true,
          "value": "funcionarios",
          "mode": "list",
          "cachedResultName": "funcionarios"
        },
        "where": {
          "values": [
            {
              "column": "nome",
              "condition": "LIKE",
              "value": "={{ /*n8n-auto-generated-fromAI-override*/ $fromAI('values0_Value', `Sempre use o formato %nome% (% no in\u00edcio e no fim) para busca parcial. \n\nExemplo: \n%Jo\u00e3o Silva%`, 'string') }}"
            }
          ]
        },
        "options": {}
      },
      "type": "n8n-nodes-base.mySqlTool",
      "typeVersion": 2.5,
      "position": [
        -160,
        16
      ],
      "id": "9aa27c23-d1d1-4a19-b2fc-a104b95120c1",
      "name": "Select rows from a table in MySQL",
      "credentials": {
        "mySql": {
          "name": "<your credential>"
        }
      }
    }
  ],
  "connections": {
    "When chat message received": {
      "main": [
        [
          {
            "node": "AI Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Cohere Chat Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Agent",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Simple Memory": {
      "ai_memory": [
        [
          {
            "node": "AI Agent",
            "type": "ai_memory",
            "index": 0
          }
        ]
      ]
    },
    "Simple Vector Store": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings Cohere": {
      "ai_embedding": [
        [
          {
            "node": "Simple Vector Store",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "Select rows from a table in MySQL": {
      "ai_tool": [
        [
          {
            "node": "AI Agent",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": false,
  "settings": {
    "executionOrder": "v1",
    "binaryMode": "separate",
    "availableInMCP": false
  },
  "versionId": "80d84ae4-235e-4d47-868d-cbcf424a960a",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "nodeGroups": [],
  "id": "cs6Y3QGNCppK9195",
  "tags": []
}

Credentials you'll need

Each integration node will prompt for credentials when you import. We strip credential IDs before publishing — you'll add your own.

• cohereApi
• mySql

About this workflow

oracle-one-imersao-agentes-ia_aula02. Uses chatTrigger, agent, lmChatCohere, memoryBufferWindow. Chat trigger; 7 nodes.

Source: https://github.com/laurofrancisco/oracle-one-imersao-agentes-ia/blob/main/workflows/aula02-agente-mysql.json — original creator credit. Request a take-down →

More AI & RAG workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.