SQL-Connected Chatbot with Postgres Memory

b4e1859d-9642-4c9a-907d-d59e8afb6dcc

Latency
6138ms
Cost
$0.0022
Tokens
877
Status
partial
gemini-3-flash-preview

5 nodes ran as pass-throughs

@n8n/n8n-nodes-langchain.memoryPostgresChat, @n8n/n8n-nodes-langchain.memoryPostgresChat, n8n-nodes-base.mySqlTool, @n8n/n8n-nodes-langchain.toolHttpRequest, @n8n/n8n-nodes-langchain.toolHttpRequest

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "4b961f1d-7da2-4a0b-98e3-7ec35ee14335",
    "timestamp": 1780741978493
  },
  {
    "data": {
      "kind": "@n8n/n8n-nodes-langchain.chatTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780741978493
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "4b961f1d-7da2-4a0b-98e3-7ec35ee14335",
    "timestamp": 1780741978493
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "dccdb07f-97db-4a5a-9b09-02a5de65246e",
    "timestamp": 1780741978496
  },
  {
    "data": {
      "type": "@n8n/n8n-nodes-langchain.memoryPostgresChat"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780741978496
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "dccdb07f-97db-4a5a-9b09-02a5de65246e",
    "timestamp": 1780741978496
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "553dd27b-ab06-4605-99e0-8f15735cfff3",
    "timestamp": 1780741978499
  },
  {
    "data": {
      "type": "@n8n/n8n-nodes-langchain.memoryPostgresChat"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780741978499
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "553dd27b-ab06-4605-99e0-8f15735cfff3",
    "timestamp": 1780741978499
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "0103fb97-c691-4bd3-b26d-85aaa9774594",
    "timestamp": 1780741978503
  },
  {
    "data": {
      "type": "n8n-nodes-base.mySqlTool"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780741978503
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "0103fb97-c691-4bd3-b26d-85aaa9774594",
    "timestamp": 1780741978503
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "0cdfd89f-eb9e-4b6c-90d1-1cf8d6ed96bb",
    "timestamp": 1780741978505
  },
  {
    "data": {
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780741978505
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "0cdfd89f-eb9e-4b6c-90d1-1cf8d6ed96bb",
    "timestamp": 1780741978505
  },
  {
    "data": {
      "nodeType": "unsupported"
    },
    "event": "node_start",
    "nodeId": "393f792a-4eff-4b33-aac0-025fc622a4b3",
    "timestamp": 1780741978508
  },
  {
    "data": {
      "type": "@n8n/n8n-nodes-langchain.toolHttpRequest"
    },
    "event": "unsupported_node",
    "nodeId": "unsupported",
    "timestamp": 1780741978508
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "unsupported"
    },
    "event": "node_end",
    "nodeId": "393f792a-4eff-4b33-aac0-025fc622a4b3",
    "timestamp": 1780741978508
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "c6e454af-70a1-4c65-8450-8159f7fc738b",
    "timestamp": 1780741978510
  },
  {
    "event": "false branch",
    "nodeId": "if",
    "timestamp": 1780741978510
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "c6e454af-70a1-4c65-8450-8159f7fc738b",
    "timestamp": 1780741978510
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "2221736f-ef99-4ac8-8a81-51af6d4e7dcd",
    "timestamp": 1780741978513
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780741978513
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "2221736f-ef99-4ac8-8a81-51af6d4e7dcd",
    "timestamp": 1780741978513
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "6afe6158-7a8b-4a83-a778-6fd28e2a11af",
    "timestamp": 1780741978515
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780741978515
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780741978515
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0012128,
      "provider": "openai",
      "latencyMs": 3146,
      "promptTokens": 1,
      "completionTokens": 485
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780741981665
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "6afe6158-7a8b-4a83-a778-6fd28e2a11af",
    "timestamp": 1780741981665
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "6aa1b3a4-0e6a-4312-9d9f-f67c4bf8f443",
    "timestamp": 1780741981670
  },
  {
    "data": {
      "inputKeys": [
        "text",
        "model",
        "usage"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780741981670
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "6aa1b3a4-0e6a-4312-9d9f-f67c4bf8f443",
    "timestamp": 1780741981670
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "df6737ca-c588-48fc-9761-2a5307841298",
    "timestamp": 1780741981673
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780741981673
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780741981673
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0009731000000000001,
      "provider": "openai",
      "latencyMs": 2957,
      "promptTokens": 2,
      "completionTokens": 389
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780741984631
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "df6737ca-c588-48fc-9761-2a5307841298",
    "timestamp": 1780741984631
  }
]