Chat with Postgresql Database

👨‍🎤 Setup 1. Add your postgresql and OpenAI credentials. 2. Click Chat button and start asking questions to your database. 3. Activate the workflow and you can make the chat publicly available.

Integrations Used (5)

Chat

Workflow Structure (7 nodes)

100%

Langchain.chat Trigger

When chat message received

Langchain.agent

AI Agent

Langchain.lm Chat Open Ai

OpenAI Chat Model

Langchain.memory Buffer Window

Chat History

Postgres Tool

Execute SQL Query

Postgres Tool

Get DB Schema and Tables List

Postgres Tool

Get Table Definition

Node Types:

trigger

default

action

Requires credentials

Prerequisites

Required Credentials (2)

OpenAI

Used by: OpenAI Chat Model

Docs

Postgres

Used by: Get Table Definition, Execute SQL Query +1 more

Docs

Complexity

Moderate

Some experience helpful. Multiple integrations or logic.

Setup time: ~25 min

Score: 27/100

When to Use This Workflow

Real-time Response

React instantly when events happen - new orders, form submissions, or API calls.

Zero delay between trigger and action for time-sensitive workflows.

Time Savings

Replace repetitive manual tasks with reliable automation.

Reclaim hours every week for higher-value work.

Error Reduction

Eliminate human error from routine processes with consistent automation.

Improve accuracy and reliability across your workflows.

workflow.json

{
  "id": "eOUewYsEzJmQixI6",
  "meta": {
    "instanceId": "77c4feba8f41570ef06dc76ece9a6ded0f0d44f7f1477a64c2d71a8508c11faa",
    "templateCredsSetupCompleted": true
  },
  "name": "Chat with Postgresql Database",
  "tags": [],
  "nodes": [
    {
      "id": "6501a54f-a68c-452d-b353-d7e871ca3780",
      "name": "When chat message received",
      "type": "@n8n/n8n-nodes-langchain.chatTrigger",
      "position": [
        -300,
        -80
      ],
      "webhookId": "cf1de04f-3e38-426c-89f0-3bdb110a5dcf",
      "parameters": {
        "options": {}
...