/snowChat

Chat on you're snowflake database - Text to SQL

Primary LanguagePython

snowChat 💬❄️

Python Streamlit OpenAI Snowflake Supabase

Streamlit App

388

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.

snowchat_showoff.mp4

🌟 Features

  • Conversational AI: Harnesses ChatGPT 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.

🛠️ 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 and REPLICATE_API_TOKEN in project directory secrets.toml.

  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

🚀 Additional Enhancements

  1. Platform Integration: Connect snowChat with popular communication platforms like Slack or Discord for seamless interaction.
  2. Voice Integration: Implement voice recognition and text-to-speech functionality to make the chatbot more interactive and user-friendly.
  3. Advanced Analytics: Integrate with popular data visualization libraries like Plotly or Matplotlib to generate interactive visualizations based on the user's queries (AutoGPT).

🤝 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.