Chat with Postgresql Database
This workflow enables an AI assistant to chat with a PostgreSQL database, allowing users to query and retrieve data using natural language. It supports custom SQL queries and schema introspection.
OpenAIPostgres
Free AI agent for n8n
Supabase Insertion & Upsertion & Retrieval
This workflow demonstrates how to perform insertion, upsertion, and retrieval operations with Supabase, specifically for handling vector embeddings and associated metadata.
- Price
- Free
- Setup for you
- $149
- Starts on
- a chat message
- Workflow size
- 16 nodes
Apps it connects
Google DriveOpenAISupabase
The problem
Data sits in different apps and databases that do not talk to each other.
How this automation solves it
This workflow demonstrates how to perform insertion, upsertion, and retrieval operations with Supabase, specifically for handling vector embeddings and associated metadata. It runs on a chat message and works with Google Drive, OpenAI and Supabase, so the work happens without anyone doing it by hand.
What changes in your business
- Apps and databases kept in sync
- Data moved without exports and imports
- Plain-English questions answered from your data
Use these to move data between your apps and databases, keep records in sync, and let staff query data in plain English. It's most useful for engineering teams.
Step-by-step setup (free)
- 1
Get the file
Click "Add to cart", check out free with your details, and download the workflow file.
- 2
Import it into n8n
Open n8n (n8n Cloud or your own server), create a new workflow, then choose "Import from File" from the menu and select the file. You can also paste the file contents straight onto the canvas.
- 3
Connect your accounts
Open each node that shows a warning and add your credentials for Google Drive, OpenAI and Supabase. Saved credentials were removed from this file, so it never uses anyone else's accounts.
- 4
Set up the trigger
Open the chat trigger and test the conversation in n8n's chat panel. When it works, embed the chat on your website or connect it to your messaging channel.
- 5
Check the AI settings
Pick the AI model you want to use and read through the prompts so the tone and rules match your business. The AI provider bills you for usage.
- 6
Replace the placeholders
Look for placeholder values such as you@example.com, sheet names, folder IDs and URLs, and replace them with your own.
- 7
Test, then switch it on
Run the workflow once with test data and check every node turns green. Then turn on the Active toggle so it runs by itself.
Get this automation
Get it free and set it up yourself, or have it installed and working in your account.
Do it yourself
$0
- The complete n8n workflow file
- Step-by-step setup guide on this page
- Free to use in your business
Done-for-you setup
$149 one-off, delivered in 3 to 5 days
- Installed in your own n8n account (Cloud or self-hosted)
- Connected to your apps and accounts
- Prompts, messages and branding adjusted to your business
- Tested end to end with your real data
- Short handover video and 7 days of support
Questions about this project
Is the Supabase Insertion & Upsertion & Retrieval automation free to download?
Yes. You can download the Supabase Insertion & Upsertion & Retrieval n8n workflow free and use it in your business. If you'd rather not set it up yourself, the done-for-you setup costs $149.
What do I need to use this template?
An n8n account (n8n Cloud or self-hosted) and accounts for Google Drive, OpenAI and Supabase. It uses AI, so the AI provider will bill you for usage.
How long does it take to set up?
If you know n8n, you can follow the steps on this page in an hour or two. With the done-for-you setup, I deliver it working in your account in 3 to 5 days.
What does the done-for-you setup include?
For $149 I install the template in your n8n account, connect your apps, adjust the prompts and messages to your business, test it with your real data, and give you a handover video plus 7 days of support.
Can the template be changed to fit my business?
Yes. Every part of an n8n workflow can be edited. If you need bigger changes, I can quote a fixed price for a custom version.
Reviews
Loading reviews...
Downloaded this one? Check out from your cart to leave a verified review.
Set up by Hunain Nasir
AI Automation Developer, 100+ automation projects built
I'm Hunain Nasir. I build GoHighLevel CRM systems, n8n and Make.com workflows and AI voice agents for businesses in the UK, USA and Australia, and I run a free shop of 361 AI agents and automations. If you'd rather not set something up yourself, I can do it for you at a fixed price.
More free Database & Storage automations
Generate SQL queries from schema only, AI-powered
This workflow uses AI to generate SQL queries based on a given database schema, making it easier to interact with databases without manual query writing.
OpenAIMySQL
MongoDB AI Agent, Intelligent Movie Recommendations
This workflow creates an AI agent that provides intelligent movie recommendations by interacting with a MongoDB database, using aggregation pipelines to fetch relevant movie data.
OpenAIMongoDB
Want this set up for you?
I'll install it in your n8n account, connect your apps, adjust it to your business and test it. Setup starts at $99.
These projects are adapted from awesome-n8n-templates by Enes Cingoz and the original workflow authors, shared under CC BY 4.0. Changes made: removed sample data and saved credential IDs, replaced hard-coded email addresses and calendar IDs with placeholders, and rewrote some descriptions. Hunain Nasir did not create the original workflows and they are not endorsed by their authors. Always review and test a workflow before using it with real data.