Query MySQL Database with Natural Language using GPT AI
Last edited 58 days ago
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
You may also like
New to n8n?
Need help building new n8n workflows? Process automation for you or your company will save you time and money, and it's completely free!
