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

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](pre-conditions-and-requirements) - [Database Schema Setup](database-schema-setup) - [Step-by-Step Workflow Explanation](step-by-step-workflow-explanation) - [Customization Guide](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: https://quickchart.io/chart