Query MySQL Database with Natural Language using GPT AI

Go to Workflow
0 views
Built by Moe Ahad Moe Ahad
Created on June 07, 2026

Description

This workflow contains community nodes that are only compatible with the self-hosted version of n8n.

How it works
Using chat node, ask a question pertaining to information stored in your MySQL database
AI Agent converts your question to a SQL query
AI Agent executes the SQL query and returns a result
AI Agent can remember the previous 5 questions

How to set up:
Add your OpenAI API Key in "OpenAI Chat Model" node
Add your MySQL credentials in the "SQL DB - List Tables and Schema" and "Execute a SQL Query in MySQL nodes"
Update the database name in "SQL DB - List Tables and Schema" node. Replace "your_query_name" under the Query field with your actual database name
After the above steps are completed, use the "When chat message received" node to ask a question about your data using plain English

Nodes Used (3)

AI Agent
@n8n/n8n-nodes-langchain.agent
OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi
Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow