chat-with-postgresql-database
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
Workflow file: chat-with-postgresql-database.json
8.5 KB
Step 1: Download the Workflow
Click the "Download Workflow" button above to save the workflow JSON file to your computer.
Step 2: Import to n8n
In your n8n instance, go to the workflows page and click "Import from File". Select the downloaded JSON file to import this workflow.
Step 3: Configure Credentials
Set up any required credentials and API connections for the nodes used in this workflow. Check each node's configuration to ensure proper setup.
Step 4: Test and Activate
Test the workflow with sample data to ensure it works correctly, then activate it to start automation.
Author
Category
Data Processing
Created
about 2 months ago