AutomationMart
Home/Browse/Conversational PostgreSQL agent with visuals, multi-KPI, and data editing (MCP)
n8n

Conversational PostgreSQL agent with visuals, multi-KPI, and data editing (MCP)

n8nn8n19 modulesv1.0
SlackOpenAIGemini

Ask your PostgreSQL database complex questions and receive clear summaries, charts, and even update or insert data โ€” all through one smart agent powered by n8nโ€™s Model Context Protocol (MCP). Supports: - Multi-KPI insights in one prompt - Auto-generated QuickChart bar/pie charts - Natural-language inserts and updates - Markdown-friendly output for dashboards --- ๐Ÿš€ Why This Version Stands Out This version goes beyond reporting: - ๐Ÿ“ˆ Auto-generates charts (QuickChart) - ๐Ÿงฎ Answers multiple KPIs i

At a glance

Conversational PostgreSQL agent with visuals, multi-KPI, and data editing (MCP) is a ready-made n8n workflow you import as a workflow JSON file โ€” no build required. It connects Slack, OpenAI, Gemini. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
Slack, OpenAI, Gemini
Modules
19
Price
Free
Version
v1.0
Conversational PostgreSQL agent with visuals, multi-KPI, and data editing (MCP) workflow diagram

About this workflow

Ask your PostgreSQL database complex questions and receive clear summaries, charts, and even update or insert data โ€” all through one smart agent powered by n8nโ€™s Model Context Protocol (MCP). Supports: - Multi-KPI insights in one prompt - Auto-generated QuickChart bar/pie charts - Natural-language inserts and updates - Markdown-friendly output for dashboards --- ๐Ÿš€ Why This Version Stands Out This version goes beyond reporting: - ๐Ÿ“ˆ Auto-generates charts (QuickChart) - ๐Ÿงฎ Answers multiple KPIs in one message - โœ๏ธ Add and update records securely - ๐Ÿง  Uses up to 30 planned steps for smart reasoning ๐Ÿ’ฐ Estimated cost per run: $0.02 --- ๐Ÿ’ฌ Example Output --- ๐Ÿงฐ Key Components - MCP Server Trigger โ†’ Receives natural queries - Claude 3.5 Haiku โ†’ Plans, reasons, splits tasks - DeepSeek โ†’ SQL and QuickChart generation - checkdatabase subflow โ†’ Validates SQL - Plot Tool โ†’ Converts data to QuickChart URLs - Insert/Update nodes โ†’ Edits PostgreSQL records - Markdown Formatter โ†’ Combines output into readable message --- ๐Ÿค– Model Configuration Notes This workflow uses two models: 1. Claude 3.5 Haiku (Anthropic) Used as the MCP agent for reasoning, planning, and tool calling. Claude is the native model for MCP and delivers reliable results in fewer steps. 2. DeepSeek Used in: - checkdatabase for SQL generation - Plot Tool for QuickChart JSON generation ๐Ÿง  All models are modular โ€” you can plug in OpenAI, Gemini, or Mistral if desired. --- ๐Ÿ” Security by Design - No raw SQL from user input - Fully parameterized queries - Structured tool calling with validation - Safe output format (text + chart links) --- ๐Ÿงช Try This Prompt > โ€œShow me top 5 products by revenue, revenue per month chart, and best customers.โ€ Expected output: - 3 KPIs - Multiple SQL queries - 2โ€“3 QuickChart links - Markdown summary for dashboard/Slack --- ๐Ÿ›  How to Use 1. Import: - BuildyourownPostgreSQLMCPservervisualscapable.json - checkdatabase.json - Plottool.json 2. Create your PostgreSQL credential under โ€œCredentialsโ€ in n8n: - Must match the name used in the workflow (e.g., Postgres account 3) 3. Assign AI models: - Claude 3.5 Haiku โ†’ MCP agent (Claude 3.5 MCP Agent) - DeepSeek โ†’ LLM nodes inside checkdatabase and Plot Tool 4. Trigger the workflow using the URL from the MCP Server Trigger node (e.g., in a chatbot, HTTP request, or Webhook UI) --- ๐Ÿ“ฆ End-User Setup Guide If you're using this template for the first time, follow these exact steps: 1. Go to your n8n dashboard and import all three workflows (main + subflows) 2. Create a PostgreSQL credential using your host, database, user, and password 3. Go to the Claude and DeepSeek nodes, and connect them to your account(s) 4. Use the Webhook URL in the MCP Server Trigger to connect your chatbot or frontend 5. Send a prompt like: โ€œShow me revenue per month, top 5 products, and a chart of best customers.โ€ Optional: - You can increase the MCP Agentโ€™s MaxIterations to go deeper (default is 30) - You can use Switch nodes to limit access to certain tables or actions - Insert/Update nodes are already included and can be safely enabled โœ… Once this is done, your AI assistant will: - Read from your database - Visualize data via QuickChart - Insert or update rows - Respond in clear, markdown-formatted summaries --- ๐Ÿ”— More Templates by the Same Creator 1. PostgreSQL Conversational Agent with Claude & DeepSeek (Multi-KPI, Secure) 2. Conversing with Data: Transforming Text into SQL Queries and Visual Curves 3. Customer Feedback Analysis with AI, QuickChart & HTML Report Generator

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

Move files meeting specified criteria to a newly created folder in Egnyte and send a message about the event to Slack

When new files are listed in a specified folder in Egnyte, a new folder with the current date is created and the files are moved to that folder. A message about this event is sent to a specified channel in Slack.

Free

Automate audio/video transcription in any language with the new ElevenLabs model

How it works ๐Ÿ—ฃ๏ธ> ๐Ÿ“– I set up this workflow to convert any audio or video file into structured text using the new ElevenLabs Scribe model, one of the best Speech-to-Text AIs, available in 99+ languages. This workflow integrates seamlessly with n8n and leverages the ElevenLabs Scribe API to: This workflow seamlessly integrates with n8n to: โœ… Upload audio/video files automatically โœ… Transcribe them with industry-leading accuracy in any language โœ… Export the text for further processing (summaries,

Free

Cheaper, faster, accurate answers with memory summarization & dynamic routing!

Smart Telegram AI Assistant with Memory Summarization & Dynamic Model Selection > Optimize your AI workflows, cut costs, and get faster, more accurate answers. --- ๐Ÿ“‹ Description Tired of expensive AI calls, slow responses, or bots that forget your context? This Telegram AI Assistant template is designed to optimize cost, speed, and precision in your AI-powered conversations. By combining PostgreSQL chat memory, AI summarization, and dynamic model selection, this workflow ensures you only pa

Free

LinkedIn auto message router and responder with request detection

Who is this for? Public-facing professionals (developer advocates, founders, marketers, content creators) who get bombarded with LinkedIn messages that aren't actually for them - support requests when you're in marketing, sales inquiries when you're a devrel, partnership pitches when you handle content, etc. What problem is this workflow solving? When you're visible online, people assume you handle everything at your company. You end up spending hours daily playing human router, forward

Free

Send Slack messages for new SimpleCirc purchases

Every time you got a new subscription purchase in SimpleCirc, Make will automatically send a message containing info about the purchase via Slack.

Free

Gmail AI Auto-Responder: Create Draft Replies to incoming emails

This workflow automatically generates draft replies in Gmail. It's designed for anyone who manages a high volume of emails or often face writer's block when crafting responses. Since it doesn't send the generated message directly, you're still in charge of editing and approving emails before they go out. How It Works: - Email Trigger: activates when new emails reach the Gmail inbox - Assessment: uses OpenAI gpt-4o and a JSON parser to determine if a response is necessary. - Reply Generation: cra

Free

Automated B2B lead generation: Google Maps to Sheets with BrowserAct & Telegram

Automated B2B Lead Generation from Google Maps to Google Sheets using BrowserAct This n8n template automates local lead generation by scraping Google Maps for businesses, saving them to Google Sheets, and notifying you in real-time via Telegram. This workflow is perfect for sales teams, marketing agencies, and local B2B services looking to build targeted lead lists automatically. --- S

Free

Create a daily market brief from Google Sheets, Alpha Vantage, Reddit, OpenAI, and Slack

Description This workflow automatically creates a daily market intelligence brief for your stock portfolio. Instead of checking prices, news, and social media separately, it brings everything together into one clear update. On a scheduled basis, the workflow reads your stock list from Google Sheets and processes each stock individually. It fetches the latest stock price data, recent market news, and investor sentiment from public sources. All this information is then analyzed by AI to identify w

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