Description
🤖 Query Your Database with GPT-4o Using Natural Language
Automated SQL query generation and execution using AI — no manual SQL writing needed!
📉 Stop struggling with writing SQL — this workflow lets you ask plain-English questions and get instant SQL queries executed on your database via GPT-4o.
🧠 What Problem Does It Solve?
Writing, debugging, and running SQL queries can be slow and technical, especially for non-experts. This workflow automates query generation and execution using GPT-4o and allows you to interact with your database conversationally.
💬 Ask questions like:
-
“What tables are available?”
-
“Add a new user named Harsh with email harsh@example.com”
-
“Show the total sales for the last 30 days”
⚙️ How It Works
💬 Listens for incoming chat messages
🤖 Sends your question to GPT-4o with a smart SQL prompt
📊 GPT-4o responds with a valid, executable SQL query
🐘 Executes the SQL query in a Postgres database
📥 Returns the results or confirmation to your chat
✨ Key Features
✅ Uses GPT-4o to convert natural language to SQL
✅ Supports PostgreSQL (can be swapped with MySQL or SQLite)
✅ Automatically runs queries and fetches results
✅ Built-in safeguards to avoid dangerous queries
✅ Memory buffer for conversational context
✅ Works with n8n embedded chat (or can be integrated with Slack, WhatsApp, etc.)
🧰 What You Need
✅ OpenAI API key (GPT-4o access)
✅ Access to your Postgres, MySQL, or SQLite database
✅ n8n version 1.19.4 or later
(Optional) Chat service integration (Slack, MS Teams, WhatsApp)
🚀 Setup Instructions
-
🔌 Connect your chat service or use n8n embedded chat
-
🔐 Add credentials for OpenAI and your database
-
🧠 Customize the AI prompt for your database schema if needed
-
🧪 Test with simple queries like “What tables exist?”
-
🧩 Optionally extend to support updates, deletes, or analytics
🔗 Integrations
-
OpenAI GPT-4o
-
PostgreSQL (MySQL / SQLite optional)
-
n8n Chat Interface (or Slack/MS Teams)
Project Link:-[https://preview--gpt-sql-converser.lovable.app/]
