Natural Language Database Queries with Dual-Agent AI & PostgreSQL Integration

Download [18.8KB]

Nodes

+6

Description:

🚀 Transform Your Database into an Intelligent AI Assistant

This workflow creates a smart database assistant that safely handles natural language queries without crashing your system. Features dual-agent architecture with built-in query limits and PostgreSQL optimization – perfect for commercial applications!

✅ Ideal for:

SaaS developers building database search features 🔍
Database administrators providing safe AI access 🛡️
Business teams needing user-friendly data queries 📊
Anyone wanting ChatGPT-like database interaction 🤖

🔧 How It Works

1️⃣ User asks a question – "Show me top 10 popular products" 2️⃣ Main AI Agent – Interprets the request and ensures safety limits 3️⃣ SQL Sub-Agent – Generates precise PostgreSQL queries 4️⃣ Database executes – Returns formatted, limited results safely

⚡ Setup Instructions

1️⃣ Prepare Your Database

Ensure PostgreSQL is accessible from n8n
Note your table structure and column names
Set up database connection credentials

2️⃣ Customize the Templates

Replace [YOUR_TABLE_NAME] with your actual table name
Update [YOUR_FIELDS] with your column names
Modify examples to match your use case
Important: Keep all LIMIT clauses intact!

3️⃣ Configure the Agents

Copy Main Agent system message to your primary AI node
Copy Sub-Agent system message to your SQL generator node
Connect the sub-workflow between both agents

4️⃣ Test & Deploy

Test with sample queries like "Show me 5 recent items"
Verify query limits work (max 50 results)
Deploy and monitor performance

🎯 Why Use This Workflow?

✔️ System Protection – Built-in limits prevent crashes from large queries ✔️ Natural Language – Users ask questions in plain English ✔️ Commercial Ready – Generic templates work with any database ✔️ Dual-Agent Safety – Smart interpretation + precise SQL generation ✔️ PostgreSQL Optimized – Handles complex schemas and data types