AutomationMart
Home/Browse/Chat with Postgresql database
n8n

Chat with Postgresql database

n8nn8n7 modulesv1.0
OpenAI

Who is this template for? This workflow template is designed for any professionals seeking relevent data from database using natural language. How it works - Each time user ask's question using the n8n chat interface, the workflow runs. - Then the message is processed by AI Agent using relevent tools - Execute SQL Query, Get DB Schema and Tables List and Get Table Definition, if required. Agent uses these tool to form and run sql query which are necessary to answer the questions.

At a glance

Chat with Postgresql database is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects OpenAI. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
OpenAI
Modules
7
Price
Free
Version
v1.0
Chat with Postgresql database workflow diagram

About this workflow

Who is this template for? This workflow template is designed for any professionals seeking relevent data from database using natural language. How it works - Each time user ask's question using the n8n chat interface, the workflow runs. - Then the message is processed by AI Agent using relevent tools - Execute SQL Query, Get DB Schema and Tables List and Get Table Definition, if required. Agent uses these tool to form and run sql query which are necessary to answer the questions. - Once AI Agent has the data, it uses it to form answer and returns it to the user. Set up instructions Complete the Set up credentials step when you first open the workflow. You'll need a Postgresql Credentials, and OpenAI api key. Template was created in n8n v1.77.0

n8n

How to import this n8n workflow

  1. 1

    Download the workflow JSON file after purchase.

  2. 2

    Open n8n → click the menu → Import from File.

  3. 3

    Select the downloaded JSON and import.

  4. 4

    Set up credentials for each node that requires them.

  5. 5

    Click Execute Workflow to test, then activate.

Setup guide

Setup guide included

Purchase to unlock the full step-by-step guide

Related N8n workflows

Auto-create Instagram carousel posts from Canva with OpenAI and Blotato

Auto-Create Instagram Carousel Posts from Canva (Webhook → AI Caption → Instagram) Automatically turn Canva carousel exports into a fully published Instagram post with AI-generated captions. This workflow receives a webhook payload containing PNG slides (for example from Claude Cowork or a Canva automation), uploads the images, generates an optimized Instagram caption using AI, and publishes the carousel post via Blotato. It removes the manual work of downloading slides, writing captions, and

Free

Website uptime monitoring with GPT-4 analysis and Gmail notifications

How it works Checks if a website is up, sends the HTTP result to an AI model (ChatGPT) for analysis, and emails a clear success or failure message. Great for a quick “is this site up?” check you can trigger from any system via HTTP. 1. Webhook — Receives a POST with the target URL. 2. HTTP Request — Attempts to fetch the URL. 3. Message a model — Uses ChatGPT to explain the status and cause of any error. 4. IF — Checks if the HTTP status code equals 200. 5. Gmail Success — Sends a success email

Free

Chat with PDF docs using AI (quoting sources)

This workflow allows you to ask questions about a PDF document. The answers are provided by an AI model of your choice, and the answer includes a citation pointing to the information it used. You can use n8n’s built-in chat interface to ask the questions, or you could customise this workflow to use another one (e.g. Slack, Teams, etc.) Example The workflow is set up with the Bitcoin whitepaper. So you could ask things like: Question: “Which email provider does the creator of Bitcoin use?“ Answer

Free

Extract and save new articles to Google Sheets using OpenAI and HTML conversion

Automatically extract new articles from RSS feeds, convert HTML to text, summarize with OpenAI, and save to Google Sheets for easy access.

Free

Outlook inbox tamer: GPT-4.1 powered categorization, auto replies & team alerts

Outlook Inbox Tamer: AI-Powered Categorization, Auto Replies & Team Alerts This workflow automatically classifies and routes incoming Outlook emails into smart categories using n8n + OpenAI GPT-4.1-mini. It helps professionals and teams stay organized by intelligently sorting and responding to high-priority messages, customer support emails, promotions, and finance-related messages — all without manual effort. --- 🧠 Who’s It For - Professionals or teams overwhelmed by email volume. - Customer

Free

Scrape business leads from Google Maps using OpenAI and Google Sheets

Google Maps Data Extraction Workflow for Lead Generation This workflow is ideal for sales teams, marketers, entrepreneurs, and researchers looking to efficiently gather detailed business information from Google Maps for: - Lead generation - Market analysis - Competitive research --- Who Is This Workflow For? - Sales professionals aiming to build targeted contact lists - Marketers looking for local

Free

Generate AI-curated Reddit digests for Telegram, Discord & Slack with Gemini

Automatically fetch, curate, and distribute Reddit content digests using AI-powered filtering. This workflow monitors multiple subreddits, ranks posts by relevance, removes spam and duplicates, then delivers beautifully formatted digests to Telegram, Discord, or Slack. Who's it for Perfect for content creators tracking trends, marketers monitoring discussions, researchers following specific topics, and community managers staying informed. Anyone who wants high-quality Reddit updates without

Free

Analyze GitLab CI job failures with GPT-5.3 and send reports to Slack

Overview This workflow helps automatically analyze the causes of build failures in Gitlab CI and propose solutions without involving DevOps engineers. See detailed setup guide How it work 1. Checks whether a job crashed. 1. Gets logs of the crashed job and a description of the pipeline. 1. The agent analyzes this data according to its system prompt. 1. During the process, the agent can retrieve additional data from Gitlab and check the availability of endpoints. 1. A report on the causes and sol

Free

Reviews

No reviews yet

Be the first to buy and share your experience.

Leave a review

Sign in to share your experience with this workflow.

Log in to review
Free
No ratings yet

Create a free account to purchase workflows.

  • JSON blueprint — instant download
  • Setup guide PDF included
  • 5 downloads · valid 30 days
  • Works with n8n

Need help setting this up?

Book a 3-hour live setup session with an Agility consultant.

₹2,499/ session
3 hrs · video call
  • Configure live on Google Meet / Zoom
  • Free follow-up if workflow has defects
  • Platform expert assigned to you
Book installation session
Free