/chatDuck

🐤 chatDuck - chatting with your DuckDB

Primary LanguagePython

🐤 chatDuck - chatting with your DuckDB

This application is a straightforward tool that enables users to interact with their DuckDB through natural language queries. It serves as a gateway to the 'Modern Data Stack in a Box with LLM' concept, it is intended to be used in conjunction with Modern Data Stack in a box with dbt-duckdb and Apache Superset.

Developed using Streamlit, DuckDB, ChromaDB, LangChain, and OpenAI.

chatDuck.mp4

Table of Contents

Concept

It serves as a gateway to the 'Modern Data Stack in a Box with LLM' concept, it is intended to be used in conjunction with Modern Data Stack in a box with dbt-duckdb and Apache Superset.

MDS-in-a-Box-with-LLM

Features

  • Conversational AI: Harnesses ChatGPT to translate natural language into precise SQL queries.
  • Conversational Memory: Retains context for interactive, dynamic responses.
  • DuckDB Integration: Offers seamless, real-time data insights straight from your DuckDB.
  • Self-healing SQL: Proactively suggests solutions for SQL errors, streamlining data access.

Getting Started

  1. Set up your OPENAI_API_KEY and DUCKDB_DATABASE in .streamlit/secrets.toml.
  2. To run the application, use the following command: 
    make run
  3. Access the application in your web browser at http://localhost:8501.

Special Thanks