Query PostgreSQL database with natural language using GPT-4o-mini
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 7 nodes and runs when a chat message arrives. Along the way it connects OpenAI Chat Model and Postgres.
How it runs
Trigger: When a chat message arrives.
- Set Table Name (Edit Fields (Set)): sets 1 field: table_name
- Database Agent (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 2 tools (Execute SQL Query, Get Table Definition); memory: Simple Memory
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Chat Trigger
@n8n/n8n-nodes-langchain.chatTrigger - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Simple Memory
@n8n/n8n-nodes-langchain.memoryBufferWindow - Postgres Tool
n8n-nodes-base.postgresTool - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
This Database SQL Query Agent convert natural language into sql query to get results Turn your PostgreSQL database into a conversational AI agent! Ask questions in plain English and get instant data results without writing SQL. ✨ What It Does - Natural…