Query MySQL database with natural language using GPT AI
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 6 nodes and runs when a chat message arrives. Along the way it connects OpenAI Chat Model and MySQL.
How it runs
Trigger: When a chat message arrives.
- AI Agent: runs an AI agent, with model: OpenAI Chat Model; 2 tools (Execute a SQL query in MySQL, SQL DB - List Tables and Schema); memory: Simple Memory
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (5)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - My Sql Tool
n8n-nodes-base.mySqlTool
From the author
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…