App for natural language to SQL translation against Snowflake DB
Top 60.8% on sourcepulse
SnowChat is a conversational AI application designed for users to query Snowflake databases using natural language. It targets business users and analysts who need quick data access without writing SQL, offering an interactive chat interface that translates natural language into SQL queries and retrieves data.
How It Works
SnowChat employs an agent-based architecture to manage interactions and tool usage, translating natural language prompts into SQL queries using supported LLMs (GPT-4o, Gemini Flash 1.5, Claude 3 Haiku, Llama 3.2, Llama 3.1). It features conversational memory for context retention and a "self-healing SQL" capability to suggest fixes for query errors. Snowflake responses are cached using Cloudflare KV.
Quick Start & Requirements
pip install -r requirements.txt
after cloning the repository.docs
folder.python ingest.py
to create embeddings.streamlit run main.py
.Highlighted Details
Maintenance & Community
The project is open for contributions via pull requests or issues. No specific community channels or notable contributors are listed in the README.
Licensing & Compatibility
Licensed under the MIT License, permitting commercial use and integration with closed-source projects.
Limitations & Caveats
The setup requires significant configuration of credentials and API keys. Schema ingestion and embedding creation are necessary steps before querying. The project appears to be a personal project with limited community support indicated.
5 months ago
1 week