SQL agent with memory

Complex

High

Nodes

Complex

Trigger

High

Complexity

7/22/2025

Added

Workflow Overview

Total Nodes

Node Types

memory Buffer Window

Window Buffer Memory

1 node

lm Chat Open Ai

OpenAI Chat Model

1 node

manual Trigger

When clicking "Test workflow"

1 node

http Request

Get chinook.zip example

1 node

compression

Extract zip file

1 node

read Write File

Save chinook.db locally, Load local chinook.db

2 nodes

sticky Note

Sticky Note, Sticky Note1, Sticky Note2

3 nodes

set

Combine chat input with the binary

1 node

agent

AI Agent

1 node

chat Trigger

Chat Trigger

1 node

Workflow JSON

7.23 KB

{
  "id": "AQJ6QnF2yVdCWMnx",
  "meta": {
    "instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a",
    "templateCredsSetupCompleted": true
  },
  "name": "SQL agent with memory",
  "tags": [],
  "nodes": [
    {
      "id": "3544950e-4d8e-46ca-8f56-61c152a5cae3",
      "name": "Window Buffer Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        1220,
        500
      ],
      "parameters": {
        "contextWindowLength": 10
      },
      "typeVersion": 1.2
    },
    {
      "id": "743cc4e7-5f24-4adc-b872-7241ee775bd0",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1000,
        500
      ],
      "parameters": {
        "model": "gpt-4-turbo",
        "options": {
          "temperature": 0.3
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "rveqdSfp7pCRON1T",
          "name": "Ted's Tech Talks OpenAi"
    ...

Showing first 1000 characters. Click "Expand" to view the full JSON.