Chat to DB: ask in plain language, get SQL results

# Natural language chatbot for querying PostgreSQL without SQL

This automation template enables conversational interaction with a Supabase/PostgreSQL database via chat. Using AI (OpenAI) and LangChain, it converts natural language queries into SQL, executes them, and returns results — all without requiring SQL knowledge. Ideal for teams needing fast, self-service data access.

## Who it´s for
- Analysts who need quick database access without writing SQL
- Product managers requesting metrics through chat
- Developers testing or exploring database content via natural language
- Teams automating internal analytics tools

## What the automation does
- Receives user input via chat message
- Uses a LangChain agent with OpenAI to generate valid SQL from natural language
- Can retrieve full database schema or specific table definitions
- Executes generated SQL queries on PostgreSQL/Supabase
- Returns query results directly in the chat interface
- Handles both data retrieval and metadata inspection (e.g., structure of the users table)

## What´s included
- Ready-to-use workflow for n8n
- Trigger and handler logic based on chat_message events
- Integrations with Supabase, OpenAI API, and PostgreSQL
- Basic text instructions for deployment and adaptation

## Requirements for setup
- n8n instance (self-hosted or cloud)
- Access to a PostgreSQL database or Supabase project (with read permissions)
- OpenAI API key
- Basic understanding of your database structure

## Benefits and outcomes
- Accelerates data access for non-technical users
- Reduces dependency on analysts and developers
- Simplifies database exploration and testing
- Enables internal AI-powered data assistants
- Minimizes errors from manual SQL writing
- Supports dynamic queries and metadata analysis

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