向量化 TUSS 表

Name: 向量化 TUSS 表
Rating: 4.5 (10 reviews)
Author: Thiago Vazzoler Loureiro

中级

这是一个Engineering, AI RAG领域的自动化工作流，包含 11 个节点。主要使用 Code, ManualTrigger, SplitInBatches, VectorStorePGVector, EmbeddingsGoogleGemini 等节点。使用 TUSS、Gemini 和 pgVector 对医疗程序进行向量化以实现语义搜索

前置要求

•无特殊前置要求，导入即可使用

使用的节点 (11)

EmbeddingsGoogleGemini

DocumentDefaultDataLoader

TextSplitterTokenSplitter

Oracle Database with Parameterization

分类

工程

AI RAG 检索增强

工作流预览

可视化展示节点连接关系，支持缩放和平移

Postgres PGVector Store2

Token Splitter

嵌入 Google Gemini

向量化 TUSS 表

ORACLE 数据库连接

医疗程序集合

用于 - 医疗程序

数据加载器

React Flow

导出工作流

复制以下 JSON 配置到 n8n 导入，即可使用此工作流

{
  "id": "6nPKaWcXqc2YPy87",
  "meta": {
    "instanceId": "98986c4dc0b4b2af9fd0666d254f8b80e6e6b2044e2f3f3eedc76242999f4b5e"
  },
  "name": "向量化 TUSS 表",
  "tags": [],
  "nodes": [
    {
      "id": "c3de0ca4-e8e7-4e27-93a3-82cf65c0153f",
      "name": "Postgres PGVector Store2",
      "type": "@n8n/n8n-nodes-langchain.vectorStorePGVector",
      "onError": "continueRegularOutput",
      "position": [
        1216,
        256
      ],
      "parameters": {
        "mode": "insert",
        "options": {},
        "tableName": "{your_table_name_here}"
      },
      "credentials": {
        "postgres": {
          "id": "3oR16F8lBunP3CQN",
          "name": "N8N"
        }
      },
      "typeVersion": 1.1,
      "alwaysOutputData": true
    },
    {
      "id": "ed23ae91-a574-4573-a4b6-77d05a927985",
      "name": "Token Splitter",
      "type": "@n8n/n8n-nodes-langchain.textSplitterTokenSplitter",
      "position": [
        1504,
        704
      ],
      "parameters": {
        "chunkSize": 100
      },
      "typeVersion": 1
    },
    {
      "id": "85128969-3eaf-4d79-adce-cf7791c26f7a",
      "name": "嵌入 Google Gemini",
      "type": "@n8n/n8n-nodes-langchain.embeddingsGoogleGemini",
      "position": [
        1056,
        448
      ],
      "parameters": {},
      "credentials": {
        "googlePalmApi": {
          "id": "gVMH2T1624AUVtgA",
          "name": "GEMINI - PRODUÇÃO"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "4fccff60-abd4-423d-971e-fed9f14cce18",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        0
      ],
      "parameters": {
        "width": 432,
        "height": 208,
        "content": "## 数据库和/或文件连接"
      },
      "typeVersion": 1
    },
    {
      "id": "104c2ec3-9ad4-4cd0-851f-be002e7b5a13",
      "name": "便签 1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1200,
        48
      ],
      "parameters": {
        "width": 352,
        "content": "## 向量化"
      },
      "typeVersion": 1
    },
    {
      "id": "ac59dec8-36c6-473d-8622-a6c9e6dddfa9",
      "name": "向量化 TUSS 表",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -176,
        240
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "c9f12d90-9b9f-42fb-8519-6367b4ce11e2",
      "name": "ORACLE 数据库连接",
      "type": "n8n-nodes-oracle-database-parameterization.Oracle Database with Parameterization",
      "position": [
        176,
        240
      ],
      "parameters": {
        "query": "SELECT CD_ITEM, DS_ITEM FROM {sua tabela aqui }"
      },
      "credentials": {
        "oracleCredentials": {
          "id": "Dj4SbJh38O9fJ7kg",
          "name": "PROTHEUS - PRODUÇÃO (APPN8N)"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "ad808bb8-02ef-4075-be77-17512b144cb8",
      "name": "医疗程序集合",
      "type": "n8n-nodes-base.code",
      "position": [
        464,
        240
      ],
      "parameters": {
        "jsCode": "return $input.first().json.rows;"
      },
      "typeVersion": 2
    },
    {
      "id": "936a7ab6-7149-4a3e-ad7b-6bc12670df31",
      "name": "用于 - 医疗程序",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        816,
        32
      ],
      "parameters": {
        "options": {}
      },
      "executeOnce": false,
      "typeVersion": 3,
      "alwaysOutputData": false
    },
    {
      "id": "1c1f20ee-d3e5-4015-b428-bff52abf9361",
      "name": "便签 2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1616,
        480
      ],
      "parameters": {
        "width": 352,
        "height": 224,
        "content": "## 数据加载器"
      },
      "typeVersion": 1
    },
    {
      "id": "07b91604-696c-467e-a9ba-0046f9a76761",
      "name": "数据加载器",
      "type": "@n8n/n8n-nodes-langchain.documentDefaultDataLoader",
      "position": [
        1328,
        496
      ],
      "parameters": {
        "options": {
          "metadata": {
            "metadataValues": [
              {
                "name": "cd_item",
                "value": "={{ $json.cd_item }}"
              },
              {
                "name": "procedureName",
                "value": "={{ $json.ds_item }}"
              }
            ]
          }
        },
        "jsonData": "=Medical procedure code: {{ $json.cd_item }}\nMedical procedure description: {{ $json.ds_item }}",
        "jsonMode": "expressionData"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "d1a6766c-bc43-46c9-9581-ca5c86ca300f",
  "connections": {
    "Data Loader": {
      "ai_document": [
        [
          {
            "node": "Postgres PGVector Store2",
            "type": "ai_document",
            "index": 0
          }
        ]
      ]
    },
    "Token Splitter": {
      "ai_textSplitter": [
        [
          {
            "node": "Data Loader",
            "type": "ai_textSplitter",
            "index": 0
          }
        ]
      ]
    },
    "VECTORIZE TUSS TABLE": {
      "main": [
        [
          {
            "node": "ORACLE DATABASE CONNECTION",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Embeddings Google Gemini": {
      "ai_embedding": [
        [
          {
            "node": "Postgres PGVector Store2",
            "type": "ai_embedding",
            "index": 0
          }
        ]
      ]
    },
    "FOR - MEDICAL PROCEDURES": {
      "main": [
        [],
        [
          {
            "node": "Postgres PGVector Store2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Postgres PGVector Store2": {
      "main": [
        [
          {
            "node": "FOR - MEDICAL PROCEDURES",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ORACLE DATABASE CONNECTION": {
      "main": [
        [
          {
            "node": "COLLECTION OF MEDICAL PROCEDURES",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "COLLECTION OF MEDICAL PROCEDURES": {
      "main": [
        [
          {
            "node": "FOR - MEDICAL PROCEDURES",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

常见问题

如何使用这个工作流？

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

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

中级 - 工程, AI RAG 检索增强

需要付费吗？

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

向量化 TUSS 表

使用的节点 (11)

分类

如何使用这个工作流？

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

需要付费吗？

相关工作流推荐