Integrierter KI-Chatbot-Workflow mit MySQL-Datenbank
Dies ist ein Engineering, DevOps, Product, AI, IT Ops-Bereich Automatisierungsworkflow mit 11 Nodes. Hauptsächlich werden MySqlTool, Agent, LmChatGroq, ChatTrigger, MemoryBufferWindow und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Ein KI-gesteuerter Chatbot-Workflow mit MySQL-Datenbankintegration
- •MySQL-Datenbankverbindungsdaten
Verwendete Nodes (11)
{
"meta": {
"instanceId": "f0daacbbece4d36ce73ed214e506ba3899410c0e00a1b6cd1d93e012465d1082"
},
"nodes": [
{
"id": "e1055031-f1f1-44dd-8e3b-18b9f543aac2",
"name": "Bei Chat-Nachricht empfangen",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-60,
-80
],
"webhookId": "cf1de04f-3e38-426c-89f0-3bdb110a5dcf",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "88eaaf60-aed6-4e9d-9667-d2838a8e7f78",
"name": "Chatverlauf",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
280,
120
],
"parameters": {},
"typeVersion": 1.3
},
{
"id": "a5b49dee-d5e4-4324-a7f8-1638e4e41abd",
"name": "MySQL",
"type": "n8n-nodes-base.mySqlTool",
"position": [
460,
120
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "7abfcdc7-dfc5-4627-a479-82dd38404c88",
"name": "MySQL Schema",
"type": "n8n-nodes-base.mySqlTool",
"position": [
640,
120
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "bc9dfb90-0696-4801-a5c2-741c2fd27855",
"name": "MySQL Definition",
"type": "n8n-nodes-base.mySqlTool",
"position": [
820,
120
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"name": "KI-Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
360,
-80
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "4849ec08-2ab9-46f2-bc8c-f9dad3196246",
"name": "Groq Chat Model",
"type": "@n8n/n8n-nodes-langchain.lmChatGroq",
"position": [
100,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "400a5f98-60af-4acb-950a-085402f3502d",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5859cd82-9d6c-4783-8ef9-44cd4d800148",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "599c02ac-7246-4cab-8bdd-1f6565ece04d",
"name": "Haftnotiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33cbfb73-10e5-428b-ba71-539be16e7bc7",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-60,
-300
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"a5b49dee-d5e4-4324-a7f8-1638e4e41abd": {
"ai_tool": [
[
{
"node": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"type": "ai_tool",
"index": 0
}
]
]
},
"88eaaf60-aed6-4e9d-9667-d2838a8e7f78": {
"ai_memory": [
[
{
"node": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"type": "ai_memory",
"index": 0
}
]
]
},
"7abfcdc7-dfc5-4627-a479-82dd38404c88": {
"ai_tool": [
[
{
"node": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"type": "ai_tool",
"index": 0
}
]
]
},
"4849ec08-2ab9-46f2-bc8c-f9dad3196246": {
"ai_languageModel": [
[
{
"node": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"bc9dfb90-0696-4801-a5c2-741c2fd27855": {
"ai_tool": [
[
{
"node": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"type": "ai_tool",
"index": 0
}
]
]
},
"e1055031-f1f1-44dd-8e3b-18b9f543aac2": {
"main": [
[
{
"node": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"type": "main",
"index": 0
}
]
]
}
}
}Wie verwende ich diesen Workflow?
Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.
Für welche Szenarien ist dieser Workflow geeignet?
Fortgeschritten - Engineering, DevOps, Produkt, Künstliche Intelligenz, IT-Betrieb
Ist es kostenpflichtig?
Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.
Verwandte Workflows
Gegenfeld
@gegenfeldWe at Gegenfeld are an EdTech platform dedicated to delivering high-quality on-demand courses and interactive training sessions for professional development at all skill levels. With our commitment to "Accelerate your future," we empower professionals to enhance their expertise through engaging, industry-focused learning experiences. On n8n, we share some of the workflows used in our interactive training to provide deeper insights and practical applications.
Diesen Workflow teilen