Mit Daten sprechen: Text in SQL-Abfragen und Visualisierungsdiagramme umwandeln
Experte
Dies ist ein Engineering, Product, AI-Bereich Automatisierungsworkflow mit 36 Nodes. Hauptsächlich werden If, Set, Merge, Postgres, ConvertToFile und andere Nodes verwendet, kombiniert mit KI-Technologie für intelligente Automatisierung. Dialog mit Daten: Text in SQL-Abfragen und Visualisierungsdiagramme umwandeln
Voraussetzungen
- •PostgreSQL-Datenbankverbindungsdaten
- •OpenAI API Key
Verwendete Nodes (36)
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
"id": "mLHcEKvtCu6m9nYi",
"meta": {
"instanceId": "1fc85153dfc4ea22a8172f0d7347fa9f591f71e2064dc331f7bdc1d7ee422e7a",
"templateCredsSetupCompleted": true
},
"name": "Conversing with Data: Transforming Text into SQL Queries and Visual Curves",
"tags": [
{
"id": "xSQPh84nO2kyMj3e",
"name": "Talk to data",
"createdAt": "2025-02-25T10:55:43.575Z",
"updatedAt": "2025-02-25T10:55:43.575Z"
}
],
"nodes": [
{
"id": "5207b91b-5a29-4786-93e2-c7ba4bd1d0f1",
"name": "Fensterpufferspeicher",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
340,
360
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "8571a134-1a79-4858-aa22-82a037a3a5f8",
"name": "Keine Operation, nichts tun",
"type": "n8n-nodes-base.noOp",
"position": [
1080,
460
],
"parameters": {},
"typeVersion": 1
},
{
"id": "967fd040-bb82-4e97-a979-b1e91ef54b8f",
"name": "Tabellennamen zur Ausgabe hinzufügen",
"type": "n8n-nodes-base.set",
"position": [
-380,
-60
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "80d47d3e-476e-43fd-a021-609cdad537c8",
"name": "Datei lokal speichern",
"type": "n8n-nodes-base.readWriteFile",
"position": [
-40,
-60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "8e715321-38a3-4ba6-abac-efe2ad54a039",
"name": "Daten aus Datei extrahieren",
"type": "n8n-nodes-base.extractFromFile",
"position": [
-360,
460
],
"parameters": {},
"typeVersion": 1
},
{
"id": "d0f9eb57-2226-4b4a-b7e7-b09074f5c410",
"name": "Chat-Trigger",
"type": "@n8n/n8n-nodes-langchain.chatTrigger",
"position": [
-860,
460
],
"webhookId": "c308dec7-655c-4b79-832e-991bd8ea891f",
"parameters": {},
"typeVersion": 1.1
},
{
"id": "b05e11f0-f957-4067-85fc-35bded780b59",
"name": "KI-Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
220,
140
],
"parameters": {},
"typeVersion": 1.6
},
{
"id": "f91029ec-27e5-4f1d-aec8-711ef5a7e0e4",
"name": "Haftnotiz",
"type": "n8n-nodes-base.stickyNote",
"position": [
-940,
-340
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "95f41622-0ff4-4841-a83d-265864599f2f",
"name": "Haftnotiz1",
"type": "n8n-nodes-base.stickyNote",
"position": [
-200,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "b12dbb8a-48fe-4627-b209-916191aef4e6",
"name": "Bei Klick auf \"Workflow testen\"",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-900,
-60
],
"parameters": {},
"typeVersion": 1
},
{
"id": "3044a292-9596-40dd-96a5-caeed0204630",
"name": "Haftnotiz2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-940,
180
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "a6691f03-8688-4844-85be-b4344e9010bf",
"name": "Haftnotiz3",
"type": "n8n-nodes-base.stickyNote",
"position": [
140,
-320
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "002bf810-5408-40a1-a05d-9bdcab64a14c",
"name": "Schemadaten und Chat-Eingabe kombinieren",
"type": "n8n-nodes-base.set",
"position": [
-120,
460
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "64b73d55-e01a-4777-a07c-6fb047d22666",
"name": "Schema aus lokaler Datei laden",
"type": "n8n-nodes-base.readWriteFile",
"position": [
-620,
460
],
"parameters": {},
"typeVersion": 1
},
{
"id": "c016cffe-669b-418f-818f-cb3692c7dcdb",
"name": "SQL-Abfrage extrahieren",
"type": "n8n-nodes-base.set",
"position": [
680,
380
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "3a9d2623-751d-4b62-9fb7-68d5d9c8facf",
"name": "Prüfen, ob Abfrage existiert",
"type": "n8n-nodes-base.if",
"position": [
840,
380
],
"parameters": {},
"typeVersion": 2.2
},
{
"id": "552385b5-1086-419d-b0b8-f7fa2479c13f",
"name": "Haftnotiz4",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "4ea865a5-7988-4563-9d5a-a7f4a4f9c31f",
"name": "Haftnotiz5",
"type": "n8n-nodes-base.stickyNote",
"position": [
660,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "0a25db4f-cc81-46f1-93cb-9e3d4028516d",
"name": "Haftnotiz7",
"type": "n8n-nodes-base.stickyNote",
"position": [
340,
560
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "66492a65-1553-4286-80ea-d03e631a0995",
"name": "Haftnotiz8",
"type": "n8n-nodes-base.stickyNote",
"position": [
1100,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "73839265-f77a-4856-b1fb-b2be7f6ebe27",
"name": "Abfrageergebnisse formatieren",
"type": "n8n-nodes-base.set",
"position": [
1180,
180
],
"parameters": {},
"executeOnce": true,
"typeVersion": 3.4
},
{
"id": "e9220e4e-8bdc-48ed-b29b-a2fe124b8b72",
"name": "Endausgabe vorbereiten",
"type": "n8n-nodes-base.set",
"position": [
2140,
580
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "81a292e1-c5e9-40df-a181-66f767c60215",
"name": "Abfrageergebnis und Chat-Antwort kombinieren",
"type": "n8n-nodes-base.merge",
"position": [
1880,
580
],
"parameters": {},
"typeVersion": 3
},
{
"id": "4a35ebb4-37cb-4a7c-b005-70315c6f684c",
"name": "Alle Tabellen in einer Datenbank auflisten",
"type": "n8n-nodes-base.postgres",
"position": [
-740,
-60
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "22da4137-af07-4c03-9c2d-6b8178571ff4",
"name": "Daten in Json konvertieren",
"type": "n8n-nodes-base.convertToFile",
"position": [
-200,
-60
],
"parameters": {},
"typeVersion": 1.1
},
{
"id": "0d7d1e90-224b-4159-8930-4470b140305d",
"name": "Schema-Extraktor",
"type": "n8n-nodes-base.postgres",
"position": [
-560,
-60
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "ddba033b-aca0-42a0-b553-3edf4d93cd1f",
"name": "Endergebnis SQL",
"type": "n8n-nodes-base.postgres",
"position": [
1000,
180
],
"parameters": {},
"typeVersion": 2.5
},
{
"id": "3c2b1a0d-4a50-44b2-ada9-00d3b23b3c61",
"name": "Felder bearbeiten",
"type": "n8n-nodes-base.set",
"position": [
1440,
180
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "4ad38866-185e-4cd3-b0b0-b1e744d52204",
"name": "Strukturierter Ausgabe-Parser",
"type": "@n8n/n8n-nodes-langchain.outputParserStructured",
"position": [
1900,
420
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "744b6680-310b-4a89-a84c-dc59145fe73f",
"name": "Felder bearbeiten1",
"type": "n8n-nodes-base.set",
"position": [
2120,
180
],
"parameters": {},
"typeVersion": 3.4
},
{
"id": "196473ba-78c5-412c-8940-121a0e1f28d2",
"name": "Plot-Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
1700,
180
],
"parameters": {},
"typeVersion": 1.7
},
{
"id": "9e03e081-0de2-4b8e-bcaa-adc0d2240272",
"name": "deepseek-chat",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
1700,
380
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "376d0712-00c4-4132-a429-b36234e75316",
"name": "Deepseek-chat",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
200,
360
],
"parameters": {},
"typeVersion": 1.2
},
{
"id": "43d27038-22c0-41ec-b2b5-507c311b23f1",
"name": "Haftnotiz9",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
-60
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "c206c591-5826-4285-900a-c082587bfbaa",
"name": "Haftnotiz10",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
-40
],
"parameters": {
"content": ""
},
"typeVersion": 1
},
{
"id": "57bbe158-4ddc-4f46-b871-d22735e3f720",
"name": "Haftnotiz11",
"type": "n8n-nodes-base.stickyNote",
"position": [
1260,
580
],
"parameters": {
"content": ""
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "93ee6099-65dc-47bc-ba35-15f2e22b1412",
"connections": {
"b05e11f0-f957-4067-85fc-35bded780b59": {
"main": [
[
{
"node": "c016cffe-669b-418f-818f-cb3692c7dcdb",
"type": "main",
"index": 0
}
]
]
},
"196473ba-78c5-412c-8940-121a0e1f28d2": {
"main": [
[
{
"node": "744b6680-310b-4a89-a84c-dc59145fe73f",
"type": "main",
"index": 0
}
]
]
},
"3c2b1a0d-4a50-44b2-ada9-00d3b23b3c61": {
"main": [
[
{
"node": "196473ba-78c5-412c-8940-121a0e1f28d2",
"type": "main",
"index": 0
}
]
]
},
"d0f9eb57-2226-4b4a-b7e7-b09074f5c410": {
"main": [
[
{
"node": "64b73d55-e01a-4777-a07c-6fb047d22666",
"type": "main",
"index": 0
}
]
]
},
"744b6680-310b-4a89-a84c-dc59145fe73f": {
"main": [
[
{
"node": "81a292e1-c5e9-40df-a181-66f767c60215",
"type": "main",
"index": 2
}
]
]
},
"376d0712-00c4-4132-a429-b36234e75316": {
"ai_languageModel": [
[
{
"node": "b05e11f0-f957-4067-85fc-35bded780b59",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"9e03e081-0de2-4b8e-bcaa-adc0d2240272": {
"ai_languageModel": [
[
{
"node": "196473ba-78c5-412c-8940-121a0e1f28d2",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"ddba033b-aca0-42a0-b553-3edf4d93cd1f": {
"main": [
[
{
"node": "73839265-f77a-4856-b1fb-b2be7f6ebe27",
"type": "main",
"index": 0
}
]
]
},
"0d7d1e90-224b-4159-8930-4470b140305d": {
"main": [
[
{
"node": "967fd040-bb82-4e97-a979-b1e91ef54b8f",
"type": "main",
"index": 0
}
]
]
},
"c016cffe-669b-418f-818f-cb3692c7dcdb": {
"main": [
[
{
"node": "3a9d2623-751d-4b62-9fb7-68d5d9c8facf",
"type": "main",
"index": 0
}
]
]
},
"22da4137-af07-4c03-9c2d-6b8178571ff4": {
"main": [
[
{
"node": "80d47d3e-476e-43fd-a021-609cdad537c8",
"type": "main",
"index": 0
}
]
]
},
"73839265-f77a-4856-b1fb-b2be7f6ebe27": {
"main": [
[
{
"node": "81a292e1-c5e9-40df-a181-66f767c60215",
"type": "main",
"index": 0
},
{
"node": "3c2b1a0d-4a50-44b2-ada9-00d3b23b3c61",
"type": "main",
"index": 0
}
]
]
},
"5207b91b-5a29-4786-93e2-c7ba4bd1d0f1": {
"ai_memory": [
[
{
"node": "b05e11f0-f957-4067-85fc-35bded780b59",
"type": "ai_memory",
"index": 0
}
]
]
},
"3a9d2623-751d-4b62-9fb7-68d5d9c8facf": {
"main": [
[
{
"node": "81a292e1-c5e9-40df-a181-66f767c60215",
"type": "main",
"index": 1
},
{
"node": "ddba033b-aca0-42a0-b553-3edf4d93cd1f",
"type": "main",
"index": 0
}
],
[
{
"node": "8571a134-1a79-4858-aa22-82a037a3a5f8",
"type": "main",
"index": 0
}
]
]
},
"8e715321-38a3-4ba6-abac-efe2ad54a039": {
"main": [
[
{
"node": "002bf810-5408-40a1-a05d-9bdcab64a14c",
"type": "main",
"index": 0
}
]
]
},
"967fd040-bb82-4e97-a979-b1e91ef54b8f": {
"main": [
[
{
"node": "22da4137-af07-4c03-9c2d-6b8178571ff4",
"type": "main",
"index": 0
}
]
]
},
"4ad38866-185e-4cd3-b0b0-b1e744d52204": {
"ai_outputParser": [
[
{
"node": "196473ba-78c5-412c-8940-121a0e1f28d2",
"type": "ai_outputParser",
"index": 0
}
]
]
},
"4a35ebb4-37cb-4a7c-b005-70315c6f684c": {
"main": [
[
{
"node": "0d7d1e90-224b-4159-8930-4470b140305d",
"type": "main",
"index": 0
}
]
]
},
"b12dbb8a-48fe-4627-b209-916191aef4e6": {
"main": [
[
{
"node": "4a35ebb4-37cb-4a7c-b005-70315c6f684c",
"type": "main",
"index": 0
}
]
]
},
"002bf810-5408-40a1-a05d-9bdcab64a14c": {
"main": [
[
{
"node": "b05e11f0-f957-4067-85fc-35bded780b59",
"type": "main",
"index": 0
}
]
]
},
"64b73d55-e01a-4777-a07c-6fb047d22666": {
"main": [
[
{
"node": "8e715321-38a3-4ba6-abac-efe2ad54a039",
"type": "main",
"index": 0
}
]
]
},
"81a292e1-c5e9-40df-a181-66f767c60215": {
"main": [
[
{
"node": "e9220e4e-8bdc-48ed-b29b-a2fe124b8b72",
"type": "main",
"index": 0
}
]
]
}
}
}Häufig gestellte Fragen
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?
Experte - Engineering, Produkt, Künstliche Intelligenz
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
SQL-Abfrage ausschließlich aus der Datenbankschemagenerierung - KI-gesteuert
SQL-Abfragen direkt aus der Datenbankschemagenerierung – KI-gesteuert
If
Set
Merge
+
If
Set
Merge
29 NodesYulia
Engineering
Versteckte Website-API-Endpunkte mit regulären Ausdrücken und KI finden
Entdeckung verborgener Website-API-Endpunkte mit regulären Ausdrücken und KI
If
Set
Html
+
If
Set
Html
58 NodesYulia
Engineering
n8n-Knoten in der visuellen Referenzbibliothek erkunden
Erkundung von n8n-Knoten in der visuellen Referenzbibliothek
If
Ftp
Set
+
If
Ftp
Set
113 NodesI versus AI
Sonstiges
KI-Agent für die Konversation mit Dateien im Supabase-Speicher
KI-Agent für Gespräche mit Dateien in Supabase Storage
If
Merge
Switch
+
If
Merge
Switch
33 NodesMark Shcherbakov
Engineering
Konvertieren von per E-Mail gestellten Fragen in SQL-Abfragen und Ausführung
E-Mail-Assistent: Umwandlung von natürlicher Sprache in SQL-Abfragen mit Phi4-mini und PostgreSQL
If
Set
Merge
+
If
Set
Merge
26 NodesAlfonso Corretti
Bausteine
Haustierladen 4
🐥 KI-Terminassistent für Tierbedarfsgeschäfte
If
Set
Code
+
If
Set
Code
187 NodesBruno Dias
Künstliche Intelligenz
Workflow-Informationen
Schwierigkeitsgrad
Experte
Anzahl der Nodes36
Kategorie3
Node-Typen15
Autor
hippolyte-hu
@hippolyte-huExterne Links
Auf n8n.io ansehen →
Diesen Workflow teilen