{"data":{"slug":"kaarthik108-snowchat","name":"snowChat","tagline":"Chat snowflake - Text to SQL","github_url":"https://github.com/kaarthik108/snowChat","owner":"kaarthik108","repo":"snowChat","owner_avatar_url":"https://avatars.githubusercontent.com/u/53030784?v=4","primary_language":"Python","stars":553,"forks":280,"topics":["agents","chatgpt","langchain","langgraph","llama","snowflake","snowpark","streamlit","supabase"],"archived":false,"github_pushed_at":"2025-02-16T19:23:23+00:00","maintenance_label":"Dormant","stars_delta_30d":0,"url":"https://www.graphcanon.com/tools/kaarthik108-snowchat","markdown_url":"https://www.graphcanon.com/tools/kaarthik108-snowchat.md","api_url":"https://www.graphcanon.com/api/graphcanon/tools/kaarthik108-snowchat","graph_url":"https://www.graphcanon.com/api/graphcanon/graph?tool=kaarthik108-snowchat","description":"Chat snowflake - Text to SQL","homepage_url":"https://snowchat.streamlit.app/","license":null,"open_issues":9,"watchers":13,"ai_summary":"A chat-based tool that translates text into SQL queries, using a combination of AI agents and data retrieval from Snowflake.","readme_excerpt":"## 🛠️ Installation\n\n1. Clone this repository:\n   git clone https://github.com/yourusername/snowchat.git\n\n2. Install the required packages:\n   cd snowchat\n   pip install -r requirements.txt\n\n3. 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`,\n   `CLOUDFLARE_API_TOKEN` in project directory `secrets.toml`.\n   Cloudflare is used here for caching Snowflake responses in KV.\n\n4. Make you're schemas and store them in docs folder that matches you're database.\n\n5. Create supabase extention, table and function from the supabase/scripts.sql.\n\n6. Run `python ingest.py` to get convert to embeddings and store as an index file.\n\n7. Run the Streamlit app to start chatting:\n   streamlit run main.py\n\n---\n\n## 📄 License\n\nThis project is licensed under the MIT License - see the [LICENSE](https://choosealicense.com/licenses/mit/) file for details.","github_created_at":"2023-04-10T23:31:01+00:00","created_at":"2026-07-11T10:51:02.500222+00:00","updated_at":"2026-08-15T06:01:19.276428+00:00","categories":[{"slug":"ai-agents","name":"AI Agents","url":"https://www.graphcanon.com/categories/ai-agents","markdown_url":"https://www.graphcanon.com/categories/ai-agents.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/ai-agents"},{"slug":"data-retrieval","name":"Data & Retrieval","url":"https://www.graphcanon.com/categories/data-retrieval","markdown_url":"https://www.graphcanon.com/categories/data-retrieval.md","api_url":"https://www.graphcanon.com/api/graphcanon/categories/data-retrieval"}],"tags":[{"slug":"agents","name":"agents"},{"slug":"chatgpt","name":"chatgpt"},{"slug":"langchain","name":"langchain"},{"slug":"langgraph","name":"langgraph"},{"slug":"llama","name":"llama"},{"slug":"snowflake","name":"snowflake"},{"slug":"snowpark","name":"snowpark"},{"slug":"streamlit","name":"streamlit"}],"trust":{"provenance":{"is_fork":false,"github_id":626161045,"owner_type":"User","methodology":"github_public_v1","parent_repo":null,"near_duplicate_slugs":[]},"computed_at":"2026-08-15T06:01:18.526Z","maintenance":{"label":"Dormant","score":18,"methodology":"github_public_v1","releases_90d":0,"days_since_push":544,"last_release_at":null,"stars_delta_30d":0,"open_issues_delta_30d":0},"security_summary":{"status":"findings","scanner":"osv@v1","low_count":15,"high_count":0,"last_scan_at":"2026-07-11T10:51:04.012Z","medium_count":0,"scan_profile":"deps","critical_count":0}},"capability_facts":{"scan":{"source":"repo_scan","observed_at":"2026-08-15T06:01:18.979Z"},"languages":{"value":["python"],"source":"github.language","observed_at":"2026-08-15T06:01:18.979Z"}},"decision_facts":{"hosting":null,"pricing":null,"requirements":null,"constraints":null,"when_to_use":["Need precise text input conversion into optimized SQL queries for your Snowflake data platform","Your project benefits from caching mechanisms provided by Cloudflare in KV storage"],"when_not_to_use":["Your application does not interact with Snowflake or you prefer alternative SQL engines","Cannot configure numerous API keys detailed in setup requirements such as SUPABASE_URL and CLOUDFLARE_API_TOKEN"],"source":"enrich:decision_facts","observed_at":"2026-07-12T16:26:08.722Z"},"constraint_facets":null,"decision_summary":[{"label":"Adopt for","value":"Text-to-SQL converter using AI agents with integration to Snowflake, requires various API keys."}]}}