🐤 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

• 🚀 'Modern Data Stack in a Box with LLM' concept
• 🌟 Features
• 🛠️ Getting Started
• 🤝 Special Thanks

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.

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

• Modern Data Stack in a Box with DuckDB
• kaarthik108/snowChat