AutomationMart
Home/Browse/Conversing with data: transforming text into SQL queries and visual curves
n8n

Conversing with data: transforming text into SQL queries and visual curves

n8nn8n25 modulesv1.0
UNSUPPORTED_SLUG_FORMAT

Conversational Data Retrieval and Visualization Workflow This workflow enables users to interact with a PostgreSQL database using natural language. It translates text inputs into SQL queries, retrieves the corresponding data, and generates visualizations using QuickChart, facilitating seamless data analysis without manual query writing. Table of Contents - Pre-conditions and Requirements - Database Schema Setup - Step-by-Step Workflow Explanation - Customization Guide Pre-conditions and Requirem

At a glance

Conversing with data: transforming text into SQL queries and visual curves is a ready-made n8n workflow you import as a workflow JSON file — no build required. It connects UNSUPPORTED_SLUG_FORMAT. It's free to download. Follow the 5-step import below to go live in minutes.

Platform
n8n
Connects
UNSUPPORTED_SLUG_FORMAT
Modules
25
Price
Free
Version
v1.0
Conversing with data: transforming text into SQL queries and visual curves workflow diagram

About this workflow

Conversational Data Retrieval and Visualization Workflow This workflow enables users to interact with a PostgreSQL database using natural language. It translates text inputs into SQL queries, retrieves the corresponding data, and generates visualizations using QuickChart, facilitating seamless data analysis without manual query writing. Table of Contents - Pre-conditions and Requirements - Database Schema Setup - Step-by-Step Workflow Explanation - Customization Guide Pre-conditions and Requirements 1. API Keys and Services Required To operate this workflow, access to the following services is necessary: - DeepSeek API: For converting natural language into SQL queries. - API Key: Obtain from your DeepSeek account. - QuickChart: For generating data visualizations. - Service URL: 2. n8n Instance Setup - n8n Installation: Install and run n8n using the Official Guide. - Credential Configuration: - DeepSeek API: Set up DeepSeek credentials in n8n by adding your API key. - PostgreSQL Database: - Local Database Access: If your PostgreSQL database is hosted locally and needs to be accessed over the internet (e.g., by n8n running on a different machine or in the cloud), you can expose it using ngrok: 1. Install ngrok: Download and install ngrok from ngrok.com. 2. Start ngrok Tunnel: Run the command ngrok tcp 5432 to expose your local PostgreSQL server. - This will provide a forwarding address like tcp://0.tcp.ngrok.io:12345 that can be used to connect to your local database remotely. 3. Update n8n Credentials: In n8n, configure the PostgreSQL node to use the ngrok forwarding address, ensuring remote access to your local database. Database Schema Setup Before initiating the workflow, ensure that the database schema is extracted and saved: 1. Extract Schema: Retrieve the database schema, including table names and column details. 2. Save Schema: Store the extracted schema in a JSON file for reference during query generation. Step-by-Step Workflow Explanation 1. User Input Handling - The workflow begins by receiving a natural language query from the user. 2. Schema Retrieval - Loads the previously saved database schema from the JSON file. 3. AI-Based SQL Generation - Combines the user's query with the database schema. - Utilizes the DeepSeek API to translate the natural language query into a SQL statement. 4. SQL Query Execution - Executes the generated SQL query against the PostgreSQL database. - Retrieves the data corresponding to the query. 5. Data Visualization - Formats the retrieved data into a structure compatible with QuickChart. - Sends the data to QuickChart to generate a visual representation. - Example: To create a bar chart, construct a URL with the chart configuration: This URL returns an image of the chart. 6. Response Delivery - Presents the generated visualizations and data insights to the user. Customization Guide Modifying the AI Model - Alternative AI Services: Replace DeepSeek with other AI models by adjusting the API call configurations in the workflow. Changing Visualization Services - Visualization Tools: Swap QuickChart with other visualization services by modifying the data processing and visualization steps. Expanding Database Support - Additional Databases: Adapt the workflow to support other databases (e.g., MySQL, MongoDB) by configuring the respective database credentials and query execution nodes. --- This workflow streamlines the process of data retrieval and visualization, allowing users to interact with their database using natural language, thereby enhancing accessibility and efficiency in data analysis. ---

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

Triage and reply to multilingual support tickets with Anthropic Claude

Overview This workflow automates customer support ticket processing using AI-powered analysis. Incoming tickets from email (IMAP) or a webhook endpoint are automatically cleaned, translated to English if necessary, analyzed with AI, and routed based on urgency and category. The workflow can automatically generate draft replies for simple tickets or escalate critical issues to your support team. It also updates your CRM or helpdesk system with structured ticket insights and logs observability met

Free

Binance spot trader - limit & market orders via API

How it works This n8n workflow allows you to interact with Binance Spot Trading API directly to: - Place Limit Buy and Limit Sell orders - Place Market Buy and Market Sell orders - Query account info and open orders - Cancel all open orders for a specific symbol All requests are signed using Binance's HMAC SHA256 signature method for secure trading. --- ⚙️ Setup Steps 1. Create Binance API Credentials in n8n: - Go to Credentials > New

Free

Automate NPM package installation and updates for self-hosted environments

Are you looking to install external libraries for your self-hosted N8N instance? This automated workflow makes adding npm packages to your N8N environment quick and effortless. Beware, this workflow only works on self-hosted instances. What This Workflow Does This solution automatically installs npm packages like axios, cheerio, or node-fetch in your self-hosted N8N Docker container, making them immediately available in Code nodes. Key features ✅ Automated Installation: No manual npm commands ne

Free

Create and join call sessions with Plivo and UltraVox AI Voice Assistant

This workflow template creates an audio stream session on UltraVox compatible with Plivo and sends it to Plivo. How It Works : Plivo initiates a call and requests the Answer URL. The workflow responds with Plivo XML to join the session. Note: Ensure you update the UltraVox API Key in the credentials. Update System Prompt based on your requirements. Check Youtube Video

Free

Insert data into PostgreSQL and create documents in Google Cloud Firestore from Browse AI tasks

Use this automation to insert data into PostgreSQL and create Google Cloud Firestore documents from Browse AI tasks, streamlining data management across platforms.

Free

Very quick quickstart

Want to learn the basics of n8n? Our comprehensive quick quickstart tutorial is here to guide you through the basics of n8n, step by step. Designed with beginners in mind, this tutorial provides a hands-on approach to learning n8n's basic functionalities.

Free

Personal knowledgebase AI agent

How it works: This project creates a personal AI knowledge assistant that operates through Telegram. The assistant can extract summaries from YouTube videos or online articles, store them in Google Sheets for later reference, and retrieve stored summaries when requested by the user. Step-by-step: Google Sheets Trigger: The workflow starts by detecting a new YouTube or article URL added to a dedicated sheet (Sheet2). It checks whether the link is already processed. Link

Free

Generate personalized language learning news digests with LLaMA-3.1 & DeepSeek AI

Automatically generate and email level-appropriate language learning content based on trending news. This workflow reads learner preferences from Google Sheets (language, level, and topic of interest), uses an AI web search model to fetch relevant news, and formats the result into a structured HTML digest featuring grammar explanations and vocabulary highlights. Emails are sent automatically to each learner in a clean, mobile-friendly format. --- ⚙️ What it does 1. ⏰ Daily Trigger at 6 AM 2.

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