Ask in natural language and get data from MySQL via cha

This workflow allows users to ask questions about data in Russian or English via chat and instantly receive answers based on real data from a MySQL database. It uses an AI agent powered by OpenAI and LangChain that analyzes the database schema, generates accurate SQL queries, and returns results in natural language. Simplifies data access for non-technical users and accelerates analytics.

## Who it´s for
- Analysts who need fast data access without writing SQL
- Managers querying business metrics via chat
- Developers testing AI-generated SQL
- Support teams with access to internal databases

## What the automation does
- Receives a user message from a chat interface
- Sends the question to an AI agent (OpenAI + LangChain) that understands context and database structure
- The agent generates a secure and accurate SQL query based on the MySQL schema
- Executes the query and processes the result
- Returns a human-readable natural language response
- Maintains conversation context using memory buffer

## What´s included
- Ready-to-use n8n workflow
- Trigger and handler logic for incoming chat messages
- Integrations with OpenAI, MySQL, and HTTP API
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n instance (self-hosted or cloud)
- Access to a MySQL server with required permissions
- OpenAI API key
- Configured HTTP endpoint to receive chat messages (if using external chat)

## Benefits and outcomes
- Faster data retrieval without developer involvement
- Lower barrier to database access for non-technical staff
- Automatic generation of correct SQL queries considering database structure
- Support for multi-turn conversations via agent memory buffer
- Reduced errors from manual query writing
- Flexibility: from simple counts to complex JOINs

## Important: template only
Important: you are purchasing a ready-made automation workflow template only. Rollout into your infrastructure, connecting specific accounts and services, 1:1 setup help, custom adjustments for non-standard stacks and any consulting support are provided as a separate paid service at an individual rate. To discuss custom work or 1:1 help, contact via Telegram: @gleb923.