AI SQL Query Generator from Database Schema

772f0581-7baa-4be6-b2ab-4d232adb5cd0

Latency
578ms
Cost
$0.0000
Tokens
0
Status
success
gemini-2.5-flash-lite

Workflow Graph

Trace

[
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "b7c3ca47-11b3-4378-81fa-68b2f56b295e",
    "timestamp": 1780866290974
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866290974
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "b7c3ca47-11b3-4378-81fa-68b2f56b295e",
    "timestamp": 1780866290974
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "977c3a82-440b-4d44-9042-47a673bcb52c",
    "timestamp": 1780866290976
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866290976
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "977c3a82-440b-4d44-9042-47a673bcb52c",
    "timestamp": 1780866290976
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "c6e9c0e2-d238-4f0b-a4c8-2271f2c8b31b",
    "timestamp": 1780866290977
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866290977
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "c6e9c0e2-d238-4f0b-a4c8-2271f2c8b31b",
    "timestamp": 1780866290977
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "4c141ae8-d2d1-45c7-bb5d-f33841d3cee6",
    "timestamp": 1780866290979
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "mysql",
      "latencyMs": 180,
      "operation": "executeQuery",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780866291160
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "4c141ae8-d2d1-45c7-bb5d-f33841d3cee6",
    "timestamp": 1780866291160
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "54fb3362-041b-4e4f-bfea-f0bc788d8dfd",
    "timestamp": 1780866291165
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "mysql",
      "latencyMs": 180,
      "operation": "executeQuery",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780866291346
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "54fb3362-041b-4e4f-bfea-f0bc788d8dfd",
    "timestamp": 1780866291346
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "d55e841d-11ed-4ce2-8c8e-840bd807ff2c",
    "timestamp": 1780866291348
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866291348
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "d55e841d-11ed-4ce2-8c8e-840bd807ff2c",
    "timestamp": 1780866291348
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "ca8d30d6-c1f1-4e89-8cd5-ea3648dc3b0c",
    "timestamp": 1780866291349
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866291349
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "ca8d30d6-c1f1-4e89-8cd5-ea3648dc3b0c",
    "timestamp": 1780866291349
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "2d89f901-d4e7-4fea-bd69-20b518280bbc",
    "timestamp": 1780866291350
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866291350
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "2d89f901-d4e7-4fea-bd69-20b518280bbc",
    "timestamp": 1780866291350
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "04511c4f-44fa-4c23-87af-54d959e6cb2c",
    "timestamp": 1780866291352
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866291352
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "04511c4f-44fa-4c23-87af-54d959e6cb2c",
    "timestamp": 1780866291352
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "96f129c0-d1d4-4cbf-a24d-0b0cea18a229",
    "timestamp": 1780866291353
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866291353
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "96f129c0-d1d4-4cbf-a24d-0b0cea18a229",
    "timestamp": 1780866291353
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "4d993ed9-3bbe-4bc3-9e5b-c3d738b0e714",
    "timestamp": 1780866291354
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866291354
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "4d993ed9-3bbe-4bc3-9e5b-c3d738b0e714",
    "timestamp": 1780866291354
  },
  {
    "data": {
      "nodeType": "manualTrigger"
    },
    "event": "node_start",
    "nodeId": "c8ac730a-04ee-499d-b845-1149967d6aa2",
    "timestamp": 1780866291356
  },
  {
    "data": {
      "initialData": {
        "data": {
          "message": "Hello, I need some help with my database."
        },
        "query": "Show me all users who registered in the last month.",
        "action": "generate_sql",
        "output": null,
        "schema": "CREATE TABLE users (\n  user_id INT AUTO_INCREMENT PRIMARY KEY,\n  username VARCHAR(50) NOT NULL UNIQUE,\n  email VARCHAR(100) NOT NULL UNIQUE,\n  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP\n);\n\nCREATE TABLE products (\n  product_id INT AUTO_INCREMENT PRIMARY KEY,\n  product_name VARCHAR(100) NOT NULL,\n  price DECIMAL(10, 2) NOT NULL,\n  stock INT DEFAULT 0\n);\n\nCREATE TABLE orders (\n  order_id INT AUTO_INCREMENT PRIMARY KEY,\n  user_id INT,\n  order_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP,\n  total_amount DECIMAL(10, 2),\n  FOREIGN KEY (user_id) REFERENCES users(user_id)\n);",
        "chatInput": "Show me all users who registered in the last month.",
        "sessionId": "session_12345abcde",
        "sqloutput": null,
        "output.match": null,
        "Tables_in_tttytdb2023": [
          "users",
          "products",
          "orders"
        ]
      }
    },
    "event": "triggered",
    "nodeId": "manualTrigger",
    "timestamp": 1780866291356
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "manualTrigger"
    },
    "event": "node_end",
    "nodeId": "c8ac730a-04ee-499d-b845-1149967d6aa2",
    "timestamp": 1780866291356
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "0cd425db-2a8e-4f48-b749-9a082e948395",
    "timestamp": 1780866291357
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866291357
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "0cd425db-2a8e-4f48-b749-9a082e948395",
    "timestamp": 1780866291357
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "e4045e33-bb87-488d-8ccf-b4a94339a841",
    "timestamp": 1780866291358
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866291358
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "e4045e33-bb87-488d-8ccf-b4a94339a841",
    "timestamp": 1780866291358
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "367ebe95-0b87-44f6-8392-33fe65446c24",
    "timestamp": 1780866291359
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866291359
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "367ebe95-0b87-44f6-8392-33fe65446c24",
    "timestamp": 1780866291359
  },
  {
    "data": {
      "nodeType": "if"
    },
    "event": "node_start",
    "nodeId": "b856fe78-2435-4075-97f8-ecbeecf3e780",
    "timestamp": 1780866291361
  },
  {
    "event": "true branch",
    "nodeId": "if",
    "timestamp": 1780866291361
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "if"
    },
    "event": "node_end",
    "nodeId": "b856fe78-2435-4075-97f8-ecbeecf3e780",
    "timestamp": 1780866291361
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "cbb6d1e1-0a75-4b3a-89cd-6bd545b8d414",
    "timestamp": 1780866291362
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866291362
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "cbb6d1e1-0a75-4b3a-89cd-6bd545b8d414",
    "timestamp": 1780866291362
  },
  {
    "data": {
      "nodeType": "integration"
    },
    "event": "node_start",
    "nodeId": "d958de24-84ef-4928-a7f3-32cada09a0eb",
    "timestamp": 1780866291364
  },
  {
    "data": {
      "mode": "write",
      "status": "ok",
      "service": "mysql",
      "latencyMs": 180,
      "operation": "executeQuery",
      "simulated": true
    },
    "event": "integration_mocked",
    "nodeId": "integration",
    "timestamp": 1780866291545
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "integration"
    },
    "event": "node_end",
    "nodeId": "d958de24-84ef-4928-a7f3-32cada09a0eb",
    "timestamp": 1780866291545
  },
  {
    "data": {
      "nodeType": "set"
    },
    "event": "node_start",
    "nodeId": "99a6dc03-1035-4866-81e4-11dc66bf98ec",
    "timestamp": 1780866291549
  },
  {
    "data": {
      "inputKeys": [],
      "mergeKeys": []
    },
    "event": "merged",
    "nodeId": "set",
    "timestamp": 1780866291549
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "set"
    },
    "event": "node_end",
    "nodeId": "99a6dc03-1035-4866-81e4-11dc66bf98ec",
    "timestamp": 1780866291549
  },
  {
    "data": {
      "nodeType": "merge"
    },
    "event": "node_start",
    "nodeId": "9380c2f6-15d9-43e4-80a2-3019bcf5ae04",
    "timestamp": 1780866291551
  },
  {
    "event": "no inputs, returning empty",
    "nodeId": "merge",
    "timestamp": 1780866291551
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "merge"
    },
    "event": "node_end",
    "nodeId": "9380c2f6-15d9-43e4-80a2-3019bcf5ae04",
    "timestamp": 1780866291551
  },
  {
    "data": {
      "nodeType": "passthrough"
    },
    "event": "node_start",
    "nodeId": "error-80354c65",
    "timestamp": 1780866291552
  },
  {
    "data": {},
    "event": "noOp",
    "nodeId": "passthrough",
    "timestamp": 1780866291552
  },
  {
    "data": {
      "status": "ok",
      "nodeType": "passthrough"
    },
    "event": "node_end",
    "nodeId": "error-80354c65",
    "timestamp": 1780866291552
  }
]