Curated

(5/5)

SQL agent with memory

Run this part only once This section: downloads the example zip file from https://www.sqlitetutorial.net/sqlite-sample-database/ extracts the archive (it contains only a single file) saves the extracted chinook.db SQLite database locally Now you can use chat to "talk" to your data!

Integrations Used (7)

Workflow Structure (10 nodes)

100%

Manual Trigger

When clicking "Test workflow"

Http Request

Get chinook.zip example

Compression

Extract zip file

Read Write File

Save chinook.db locally

Langchain.chat Trigger

Chat Trigger

Read Write File

Load local chinook.db

Set

Combine chat input with the binary

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.agent

AI Agent

Langchain.memory Buffer Window

Window Buffer Memory

Node Types:

default

trigger

http

transform

Requires credentials

Prerequisites

Required Credentials (1)

OpenAI

Used by: OpenAI Chat Model

Docs

Complexity

Moderate

Some experience helpful. Multiple integrations or logic.

Setup time: ~20 min

Score: 28/100

4 Integrations

When to Use This Workflow

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "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
      },
...