/snowChat

Chat snowflake - Text to SQL

Primary LanguagePython

snowChat 💬❄️

Streamlit OpenAI Snowflake Supabase AWS Langchain

Streamlit App

156shots_so

snowChat is an intuitive and user-friendly application that allows users to interact with their Snowflake data using natural language queries. Type in your questions or requests, and SnowChat will generate the appropriate SQL query and return the data you need. No more complex SQL queries or digging through tables - SnowChat makes it easy to access your data! By bringing data one step closer, SnowChat empowers users to make data-driven decisions faster and more efficiently, reducing the barriers between users and the insights they seek.

Supported LLM's

  • GPT-4o
  • Gemini Flash 1.5 8B
  • Claude 3 Haiku
  • Llama 3.2 3B
  • Llama 3.1 405B

snowchat_showoff.mp4

🌟 Features

  • Conversational AI: Use ChatGPT and other models to translate natural language into precise SQL queries.
  • Conversational Memory: Retains context for interactive, dynamic responses.
  • Snowflake Integration: Offers seamless, real-time data insights straight from your Snowflake database.
  • Self-healing SQL: Proactively suggests solutions for SQL errors, streamlining data access.
  • Interactive User Interface: Transforms data querying into an engaging conversation, complete with a chat reset option.
  • Agent-based Architecture: Utilizes an agent to manage interactions and tool usage.

🛠️ Installation

  1. Clone this repository: git clone https://github.com/yourusername/snowchat.git

  2. Install the required packages: cd snowchat pip install -r requirements.txt

  3. Set up your OPENAI_API_KEY, ACCOUNT, USER_NAME, PASSWORD, ROLE, DATABASE, SCHEMA, WAREHOUSE, SUPABASE_URL , SUPABASE_SERVICE_KEY, SUPABASE_STORAGE_URL,CLOUDFLARE_ACCOUNT_ID, CLOUDFLARE_NAMESPACE_ID, CLOUDFLARE_API_TOKEN in project directory secrets.toml. Cloudflare is used here for caching Snowflake responses in KV.

  4. Make you're schemas and store them in docs folder that matches you're database.

  5. Create supabase extention, table and function from the supabase/scripts.sql.

  6. Run python ingest.py to get convert to embeddings and store as an index file.

  7. Run the Streamlit app to start chatting: streamlit run main.py

Star History

[Star History Chart]

🤝 Contributing

Feel free to contribute to this project by submitting a pull request or opening an issue. Your feedback and suggestions are greatly appreciated!

📄 License

This project is licensed under the MIT License - see the LICENSE file for details.