flux de travail：intégrationMySQLdonnées库deAIchatbot
Ceci est unEngineering, DevOps, Product, AI, IT Opsworkflow d'automatisation du domainecontenant 11 nœuds.Utilise principalement des nœuds comme MySqlTool, Agent, LmChatGroq, ChatTrigger, MemoryBufferWindow, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. intégrationMySQLdonnées库deAI驱动chatbotflux de travail
- •Informations de connexion à la base de données MySQL
Nœuds utilisés (11)
{
"meta": {
"instanceId": "f0daacbbece4d36ce73ed214e506ba3899410c0e00a1b6cd1d93e012465d1082"
},
"nodes": [
{
"id": "e1055031-f1f1-44dd-8e3b-18b9f543aac2",
"name": "À la réception d'un message de chat",
"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": "Historique de Chat",
"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": "Schéma MySQL",
"type": "n8n-nodes-base.mySqlTool",
"position": [
640,
120
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "bc9dfb90-0696-4801-a5c2-741c2fd27855",
"name": "Définition MySQL",
"type": "n8n-nodes-base.mySqlTool",
"position": [
820,
120
],
"parameters": {},
"typeVersion": 2.4
},
{
"id": "fd8344a4-ee89-4365-ae36-cc39f26c47df",
"name": "Agent IA",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
360,
-80
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "4849ec08-2ab9-46f2-bc8c-f9dad3196246",
"name": "Modèle de Chat Groq",
"type": "@n8n/n8n-nodes-langchain.lmChatGroq",
"position": [
100,
120
],
"parameters": {},
"typeVersion": 1
},
{
"id": "400a5f98-60af-4acb-950a-085402f3502d",
"name": "Note adhésive 1",
"type": "n8n-nodes-base.stickyNote",
"position": [
60,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "5859cd82-9d6c-4783-8ef9-44cd4d800148",
"name": "Note adhésive 2",
"type": "n8n-nodes-base.stickyNote",
"position": [
240,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "599c02ac-7246-4cab-8bdd-1f6565ece04d",
"name": "Note adhésive 3",
"type": "n8n-nodes-base.stickyNote",
"position": [
420,
300
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "33cbfb73-10e5-428b-ba71-539be16e7bc7",
"name": "Note adhésive",
"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
}
]
]
}
}
}Comment utiliser ce workflow ?
Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.
Dans quelles scénarios ce workflow est-il adapté ?
Intermédiaire - Ingénierie, DevOps, Produit, Intelligence Artificielle, Opérations IT
Est-ce payant ?
Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.
Workflows recommandés
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.
Partager ce workflow