AI SQL Query Generator from Database Schema

0e79e245-dc40-4a79-9fa2-858a33d30bbd

Latency
6177ms
Cost
$0.0017
Tokens
937
Status
success
gemini-3-flash-preview

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "b7c3ca47-11b3-4378-81fa-68b2f56b295e",
    "timestamp": 1780648604251
  },
  {
    "data": {
      "messages": 1,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o",
    "nodeId": "llm",
    "timestamp": 1780648604251
  },
  {
    "data": {
      "model": "gpt-4o",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780648604251
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0013028,
      "provider": "openai",
      "latencyMs": 4026,
      "promptTokens": 1,
      "completionTokens": 521
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780648608278
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "b7c3ca47-11b3-4378-81fa-68b2f56b295e",
    "timestamp": 1780648608278
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "977c3a82-440b-4d44-9042-47a673bcb52c",
    "timestamp": 1780648608281
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780648608281
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "977c3a82-440b-4d44-9042-47a673bcb52c",
    "timestamp": 1780648608281
  },
  {
    "data": {
      "nodeType": "trigger"
    },
    "event": "node_start",
    "nodeId": "96f129c0-d1d4-4cbf-a24d-0b0cea18a229",
    "timestamp": 1780648608284
  },
  {
    "data": {
      "kind": "@n8n/n8n-nodes-langchain.chatTrigger"
    },
    "event": "seeded",
    "nodeId": "trigger",
    "timestamp": 1780648608284
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "trigger"
    },
    "event": "node_end",
    "nodeId": "96f129c0-d1d4-4cbf-a24d-0b0cea18a229",
    "timestamp": 1780648608284
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "c8ac730a-04ee-499d-b845-1149967d6aa2",
    "timestamp": 1780648608288
  },
  {
    "data": {
      "initialData": {
        "Tables_in_tttytdb2023": "users, orders, products, inventory"
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780648608288
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "c8ac730a-04ee-499d-b845-1149967d6aa2",
    "timestamp": 1780648608288
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "e4045e33-bb87-488d-8ccf-b4a94339a841",
    "timestamp": 1780648608290
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780648608290
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "e4045e33-bb87-488d-8ccf-b4a94339a841",
    "timestamp": 1780648608290
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "4c141ae8-d2d1-45c7-bb5d-f33841d3cee6",
    "timestamp": 1780648608292
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "mysql",
      "latencyMs": 180,
      "operation": "executeQuery",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780648608473
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "4c141ae8-d2d1-45c7-bb5d-f33841d3cee6",
    "timestamp": 1780648608473
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "04511c4f-44fa-4c23-87af-54d959e6cb2c",
    "timestamp": 1780648608476
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780648608476
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "04511c4f-44fa-4c23-87af-54d959e6cb2c",
    "timestamp": 1780648608476
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "54fb3362-041b-4e4f-bfea-f0bc788d8dfd",
    "timestamp": 1780648608478
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "mysql",
      "latencyMs": 180,
      "operation": "executeQuery",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780648608659
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "54fb3362-041b-4e4f-bfea-f0bc788d8dfd",
    "timestamp": 1780648608659
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "0cd425db-2a8e-4f48-b749-9a082e948395",
    "timestamp": 1780648608663
  },
  {
    "data": {
      "inputKeys": [
        "Tables_in_tttytdb2023"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780648608663
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "0cd425db-2a8e-4f48-b749-9a082e948395",
    "timestamp": 1780648608663
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "d55e841d-11ed-4ce2-8c8e-840bd807ff2c",
    "timestamp": 1780648608666
  },
  {
    "data": {
      "inputKeys": [
        "ok",
        "id",
        "simulated",
        "echo"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780648608666
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "d55e841d-11ed-4ce2-8c8e-840bd807ff2c",
    "timestamp": 1780648608666
  },
  {
    "data": {
      "nodeType": "llm"
    },
    "event": "node_start",
    "nodeId": "4d993ed9-3bbe-4bc3-9e5b-c3d738b0e714",
    "timestamp": 1780648608669
  },
  {
    "data": {
      "messages": 2,
      "maxTokens": 1024
    },
    "event": "calling openai/gpt-4o-mini",
    "nodeId": "llm",
    "timestamp": 1780648608669
  },
  {
    "data": {
      "model": "gpt-4o-mini",
      "provider": "openai"
    },
    "event": "llm_call",
    "nodeId": "_context",
    "timestamp": 1780648608669
  },
  {
    "data": {
      "model": "gemini-3-flash-preview",
      "costUsd": 0.0004171,
      "provider": "openai",
      "latencyMs": 1552,
      "promptTokens": 282,
      "completionTokens": 133
    },
    "event": "llm_result",
    "nodeId": "_context",
    "timestamp": 1780648610221
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "llm"
    },
    "event": "node_end",
    "nodeId": "4d993ed9-3bbe-4bc3-9e5b-c3d738b0e714",
    "timestamp": 1780648610221
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "ca8d30d6-c1f1-4e89-8cd5-ea3648dc3b0c",
    "timestamp": 1780648610224
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780648610224
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "ca8d30d6-c1f1-4e89-8cd5-ea3648dc3b0c",
    "timestamp": 1780648610224
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "367ebe95-0b87-44f6-8392-33fe65446c24",
    "timestamp": 1780648610228
  },
  {
    "data": {
      "inputKeys": [
        "text",
        "model",
        "usage"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780648610228
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "367ebe95-0b87-44f6-8392-33fe65446c24",
    "timestamp": 1780648610228
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "2d89f901-d4e7-4fea-bd69-20b518280bbc",
    "timestamp": 1780648610231
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780648610231
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "2d89f901-d4e7-4fea-bd69-20b518280bbc",
    "timestamp": 1780648610231
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "b856fe78-2435-4075-97f8-ecbeecf3e780",
    "timestamp": 1780648610233
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1780648610233
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "b856fe78-2435-4075-97f8-ecbeecf3e780",
    "timestamp": 1780648610233
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "d958de24-84ef-4928-a7f3-32cada09a0eb",
    "timestamp": 1780648610236
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "mysql",
      "latencyMs": 180,
      "operation": "executeQuery",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780648610417
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "d958de24-84ef-4928-a7f3-32cada09a0eb",
    "timestamp": 1780648610417
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "c6e9c0e2-d238-4f0b-a4c8-2271f2c8b31b",
    "timestamp": 1780648610420
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780648610420
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "c6e9c0e2-d238-4f0b-a4c8-2271f2c8b31b",
    "timestamp": 1780648610420
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "cbb6d1e1-0a75-4b3a-89cd-6bd545b8d414",
    "timestamp": 1780648610423
  },
  {
    "data": {
      "inputKeys": [
        "ok",
        "id",
        "simulated",
        "echo"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780648610423
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "cbb6d1e1-0a75-4b3a-89cd-6bd545b8d414",
    "timestamp": 1780648610423
  },
  {
    "data": {
      "nodeType": "merge"
    },
    "event": "node_start",
    "nodeId": "9380c2f6-15d9-43e4-80a2-3019bcf5ae04",
    "timestamp": 1780648610425
  },
  {
    "data": {
      "inputCount": 2
    },
    "event": "merged 2 inputs",
    "nodeId": "merge",
    "timestamp": 1780648610425
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "merge"
    },
    "event": "node_end",
    "nodeId": "9380c2f6-15d9-43e4-80a2-3019bcf5ae04",
    "timestamp": 1780648610426
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "99a6dc03-1035-4866-81e4-11dc66bf98ec",
    "timestamp": 1780648610428
  },
  {
    "data": {
      "inputKeys": [
        "ok",
        "id",
        "simulated",
        "echo",
        "text",
        "model",
        "usage"
      ],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780648610428
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "99a6dc03-1035-4866-81e4-11dc66bf98ec",
    "timestamp": 1780648610428
  }
]