AI Chat Analyst for NocoDB with Memory

# Data analysis from NocoDB via chat with AI and conversation memory

This workflow enables users to ask questions about their data through a chat interface and receive accurate, AI-generated responses. It accesses data from NocoDB without requiring SQL knowledge, making it ideal for analysts, managers, and developers who need fast, natural-language-based analytics.

## Who it´s for
- Data analysts using NocoDB as a database
- Managers requesting reports via chat without SQL
- Developers integrating AI agents with low-code databases
- Teams automating internal knowledge systems

## What the automation does
- Triggered by a new chat message (chat_message)
- Fetches relevant tables from NocoDB via HTTP API
- Filters and passes data to a LangChain agent powered by OpenAI
- Maintains conversation context using window buffer memory
- Generates human-readable responses in natural language
- Supports follow-up questions with preserved dialogue history

## What´s included
- Ready-to-use n8n workflow
- Logic for message triggers and handlers
- Integrations with NocoDB, OpenAI, and HTTP API
- Basic text instructions for setup and adaptation

## Requirements for setup
- n8n account with workflow editing access
- Running NocoDB instance with data and exposed API
- OpenAI API key
- Access to configure environment variables and test execution

## Benefits and outcomes
- Simplifies data access for non-technical users
- Reduces analyst workload with automated responses
- Enables contextual interactions with dialogue memory
- Accelerates time-to-insight for business decisions
- Minimizes manual queries and duplicate reporting
- Enhances team autonomy through self-service analytics

## 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