Generate SQL queries from schema only - AI-powered

Generate SQL queries from schema only - AI-powered

Complex
High
29
Nodes
Complex
Trigger
High
Complexity
7/22/2025
Added

Workflow Overview

Total Nodes
29
Node Types
14

Node Types

lm Chat Open Ai
OpenAI Chat Model
1 node
memory Buffer Window
Window Buffer Memory
1 node
no Op
No Operation, do nothing
1 node
my Sql
List all tables in a database, Extract database schema, Run SQL query
3 nodes
set
Add table name to output, Combine schema data and chat input, Extract SQL query, Format query results, Prepare final output
5 nodes
convert To File
Convert data to binary
1 node
read Write File
Save file locally, Load the schema from the local file
2 nodes
extract From File
Extract data from file
1 node
chat Trigger
Chat Trigger
1 node
agent
AI Agent
1 node
sticky Note
Sticky Note, Sticky Note1, Sticky Note2, Sticky Note3, Sticky Note4, Sticky Note5, Sticky Note7, Sticky Note6, Sticky Note8
9 nodes
manual Trigger
When clicking "Test workflow"
1 node
if
Check if query exists
1 node
merge
Combine query result and chat answer
1 node

Workflow JSON

21.15 KB
{
  "id": "P307QnrxpA1ddsM5",
  "meta": {
    "instanceId": "fb924c73af8f703905bc09c9ee8076f48c17b596ed05b18c0ff86915ef8a7c4a",
    "templateCredsSetupCompleted": true
  },
  "name": "Generate SQL queries from schema only - AI-powered",
  "tags": [],
  "nodes": [
    {
      "id": "b7c3ca47-11b3-4378-81fa-68b2f56b295e",
      "name": "OpenAI Chat Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        1460,
        440
      ],
      "parameters": {
        "model": "gpt-4o",
        "options": {
          "temperature": 0.2
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "rveqdSfp7pCRON1T",
          "name": "Ted's Tech Talks OpenAi"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "977c3a82-440b-4d44-9042-47a673bcb52c",
      "name": "Window Buffer Memory",
      "type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
      "position": [
        1640,
        440
      ],
      "parameters": {
      ...

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