# Chat-based analytics: ask in natural language, get SQL and visualizations from PostgreSQL
This automation enables users to query a PostgreSQL database via chat using natural language. An AI agent powered by LangChain and Deepseek-chat API translates questions into accurate SQL, executes them, and returns results as numbers, tables, or charts. Designed for teams seeking fast, code-free access to data insights through conversational interfaces.
## Who it´s for
- Data analysts who need quick DB access without writing SQL
- Product managers monitoring metrics through chat
- Developers automating data access via conversational UIs
- Teams using chatbots for internal analytics
## What the automation does
- Accepts text input from chat as a trigger
- Converts natural language queries into SQL using an AI agent (LangChain + Deepseek-chat API)
- Executes generated SQL against a connected PostgreSQL database
- Processes results: formats, aggregates, passes to visualization tools
- Preloads and stores database schema for context accuracy
- Maintains conversation history using memory buffer
- Supports manual triggers for testing or schema extraction
## What´s included
- Ready-to-use n8n workflow
- Trigger logic for chat_message and manual_trigger
- Integrations with PostgreSQL, Deepseek-chat API, and LangChain components
- Structured Output Parser for reliable text-to-SQL conversion
- Basic documentation for setup and adaptation
## Requirements for setup
- Access to a PostgreSQL instance with appropriate read (and optionally write) permissions
- API key for Deepseek-chat service
- Running n8n instance configured for your environment
- Basic understanding of your database schema for initial context setup
## Benefits and outcomes
- Faster self-service data access for non-technical users
- Reduced workload on analysts and developers
- Context-aware SQL generation based on preloaded schema
- Support for multi-turn conversations with memory retention
- Easy integration potential with chat platforms like Telegram or Slack
- Reliable parsing and execution of complex analytical queries
## 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