Curated

(5/5)

Generate SQL queries from schema only - AI-powered

Run this part only once This section: loads a list of all tables from the database hosted on [db4free](https://db4free.net/signup.php) extracts the database schema for each table and adds the table name converts the schema into a binary JSON format saves the schema ./chinookmysql.json file locally Now you can use chat to "talk" to your data! 🎉

Integrations Used (6)

Workflow Structure (20 nodes)

100%

Manual Trigger

When clicking "Test workflow"

My Sql

List all tables in a database

My Sql

Extract database schema

Set

Add table name to output

Convert To File

Convert data to binary

Read Write File

Save file locally

My Sql

Run SQL query

Set

Format query results

Langchain.chat Trigger

Chat Trigger

Read Write File

Load the schema from the local file

Extract From File

Extract data from file

Set

Combine schema data and chat input

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.agent

AI Agent

Langchain.memory Buffer Window

Window Buffer Memory

Set

Extract SQL query

Check if query exists

No Op

No Operation, do nothing

Merge

Combine query result and chat answer

Set

Prepare final output

Node Types:

default

action

transform

trigger

logic

Requires credentials

Prerequisites

Required Credentials (2)

My Sql

Used by: List all tables in a database, Extract database schema +1 more

Docs

OpenAI

Used by: OpenAI Chat Model

Docs

Complexity

Complex

Advanced features used. Requires n8n experience.

Setup time: ~35 min

Score: 60/100

Conditional Logic

6 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": "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": {
...