# Data analysis from NocoDB via chat: ask questions in natural language
This automation template enables users to retrieve analytics from NocoDB databases through a simple chat interface using natural language instead of SQL. The built-in logic powered by LangChain and OpenAI understands queries, fetches relevant data, and maintains conversational context.
## Who it´s for
- Analysts who need fast data summaries via chat
- Managers requesting reports without SQL knowledge
- Developers integrating AI-driven analysis into internal systems
## What the automation does
- Triggers when a new message is received in the chat
- Fetches data from NocoDB tables via HTTP API
- Extracts relevant columns and passes them to a LangChain-based agent
- Uses OpenAI model and window buffer memory to understand query context
- Generates clear responses and returns them to the chat
- Supports follow-up questions and multi-step interactions
## What´s included
- Ready-to-use n8n workflow
- Trigger and message handling logic
- Integrations with NocoDB, OpenAI, and chat interface
- Basic text guide for setup and adaptation
## Requirements for setup
- n8n account with workflow deployment access
- NocoDB instance with enabled API access
- OpenAI API key
- Chat interface capable of sending trigger messages to n8n
## Benefits and outcomes
- Faster access to insights without writing SQL
- Reduced dependency on technical specialists
- Support for contextual, multi-turn conversations
- Easy integration into existing tools without heavy development
## 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 chat
No feedback yet