Natural Language MySQL Queries via GPT AI Chatbot

This n8n workflow enables users to query MySQL databases using everyday English through a chat interface powered by GPT AI. When a chat message is received via the webhook trigger, an AI Agent interprets the natural language input, leverages tools to list available tables and schema from the database, generates precise SQL queries, executes them, and returns formatted results. It maintains context from the previous five interactions, allowing for follow-up questions without repetition.

Key benefits include democratizing data access—no SQL expertise required—reducing errors from manual query writing, and accelerating insights for non-technical users. The workflow integrates OpenAI for intelligent query generation, LangChain for agentic behavior, and MySQL for data retrieval, all within a self-hosted n8n environment using community nodes.

Ideal use cases span business intelligence (e.g., sales teams querying revenue trends), customer support (checking order statuses), data analysis (exploring datasets conversationally), and internal reporting (HR fetching employee metrics). Setup is straightforward: configure OpenAI API key, MySQL credentials, and database name, then start chatting for instant results. This saves hours of development time compared to custom apps.