Chat with PostgreSQL: ask in plain English, get data

# Chat with PostgreSQL: ask in natural language, get data without SQL

This automation template enables users to query a PostgreSQL database using natural language via a chat interface. Powered by an AI agent (LangChain + OpenAI), it translates questions into secure SQL queries, executes them, and returns results directly in chat — eliminating the need to write SQL manually.

## Who it´s for
- Analysts who need quick access to PostgreSQL data without writing SQL
- Product managers querying metrics through chat
- Database administrators offering secure, non-direct access to data

## What the automation does
- User sends a message in natural language (e.g., ´Show last 10 delivered orders´)
- The system inspects database schema and maintains conversation context
- An accurate SQL query is generated using the LangChain agent and OpenAI
- Query is executed securely against PostgreSQL
- Results are returned in a readable format within the chat

## What´s included
- Ready-to-use n8n workflow
- Trigger logic based on incoming chat messages
- Integrations with PostgreSQL and OpenAI API
- Basic setup and adaptation guide

## Requirements for setup
- n8n instance (self-hosted or cloud)
- PostgreSQL database access with appropriate read (and optional write) permissions
- OpenAI API key
- Configured chat interface or test channel for message input/output

## Benefits and outcomes
- Faster self-service data access for non-technical users
- Reduced dependency on manual SQL writing
- Increased autonomy for product and analytics teams
- Secure execution with controlled database access
- Support for complex queries involving JOINs, filters, and limits

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