SQL-Connected Chatbot with Postgres Memory

190547ce-c0fe-46f8-81bd-7db95a4ffc86

Latency
6204ms
Cost
$0.0001
Tokens
319
Status
partial
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "4b961f1d-7da2-4a0b-98e3-7ec35ee14335",
    "timestamp": 1780872282938
  },
  {
    "data": {
      "kind": "@n8n/n8n-nodes-langchain.chatTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780872282938
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "4b961f1d-7da2-4a0b-98e3-7ec35ee14335",
    "timestamp": 1780872282938
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "dccdb07f-97db-4a5a-9b09-02a5de65246e",
    "timestamp": 1780872282939
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780872282939
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "dccdb07f-97db-4a5a-9b09-02a5de65246e",
    "timestamp": 1780872282939
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "553dd27b-ab06-4605-99e0-8f15735cfff3",
    "timestamp": 1780872282940
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780872282940
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "553dd27b-ab06-4605-99e0-8f15735cfff3",
    "timestamp": 1780872282940
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "0103fb97-c691-4bd3-b26d-85aaa9774594",
    "timestamp": 1780872282943
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "mysql",
      "latencyMs": 180,
      "operation": "executeQuery",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780872283123
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "0103fb97-c691-4bd3-b26d-85aaa9774594",
    "timestamp": 1780872283123
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "0cdfd89f-eb9e-4b6c-90d1-1cf8d6ed96bb",
    "timestamp": 1780872283125
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "toolhttprequest",
      "latencyMs": 250,
      "operation": "run",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780872283375
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "0cdfd89f-eb9e-4b6c-90d1-1cf8d6ed96bb",
    "timestamp": 1780872283375
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "393f792a-4eff-4b33-aac0-025fc622a4b3",
    "timestamp": 1780872283377
  },
  {
    "data": {
      "mode": "read",
      "status": "ok",
      "service": "toolhttprequest",
      "latencyMs": 250,
      "operation": "run",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780872283628
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "393f792a-4eff-4b33-aac0-025fc622a4b3",
    "timestamp": 1780872283628
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "c6e454af-70a1-4c65-8450-8159f7fc738b",
    "timestamp": 1780872283630
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1780872283630
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "c6e454af-70a1-4c65-8450-8159f7fc738b",
    "timestamp": 1780872283630
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "2221736f-ef99-4ac8-8a81-51af6d4e7dcd",
    "timestamp": 1780872283633
  },
  {
    "data": {
      "inputKeys": [
        "leadData",
        "session_id",
        "chatInput",
        "sessionId"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780872283633
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "2221736f-ef99-4ac8-8a81-51af6d4e7dcd",
    "timestamp": 1780872283633
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "6afe6158-7a8b-4a83-a778-6fd28e2a11af",
    "timestamp": 1780872283634
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780872283634
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780872283634
  },
  {
    "data": {
      "error": "Google Gemini API error (500): {\n  \"error\": {\n    \"code\": 500,\n    \"message\": \"An internal error has occurred. Please retry or report in https://developers.generativeai.google/guide/troubleshooting\",\n    \"status\": \"INTERNAL\"\n  }\n}\n",
      "status": "error",
      "degraded": true,
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "6afe6158-7a8b-4a83-a778-6fd28e2a11af",
    "timestamp": 1780872287774
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "6aa1b3a4-0e6a-4312-9d9f-f67c4bf8f443",
    "timestamp": 1780872287776
  },
  {
    "data": {
      "inputKeys": [
        "leadData",
        "session_id",
        "chatInput",
        "sessionId"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780872287776
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "6aa1b3a4-0e6a-4312-9d9f-f67c4bf8f443",
    "timestamp": 1780872287776
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "df6737ca-c588-48fc-9761-2a5307841298",
    "timestamp": 1780872287778
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780872287778
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780872287778
  },
  {
    "data": {
      "model": "gemini-2.5-flash-lite",
      "costUsd": 0.00012700000000000002,
      "provider": "openai",
      "latencyMs": 1363,
      "promptTokens": 2,
      "completionTokens": 317
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780872289142
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "df6737ca-c588-48fc-9761-2a5307841298",
    "timestamp": 1780872289142
  }
]