← All Products
❄️
AI · DataOpen SourceFree
FrostWatch
Self-hosted Snowflake cost & query observability — free, open-source SELECT.dev alternative
PythonSnowflakeLLMdbtObservability
// screenshots
See FrostWatch in action
// about
FrostWatch is a free, self-hosted observability tool for Snowflake. Track spend by warehouse, user, and dbt model — surface slow queries, detect cost spikes, and ask an AI to explain them in plain English. No SaaS fees. Open-source alternative to SELECT.dev and Chaos Genius.
// features
What FrostWatch does
Cost attribution
Break down Snowflake spend by warehouse, user, query, and dbt model to the cent.
Slow query detector
Automatically surfaces queries above your threshold with full explain plans.
AI explainer
Ask "why is this query slow?" and get an LLM-generated analysis and fix suggestion.
Anomaly detection
Spot unexpected cost spikes and alert your team before the bill lands.
dbt integration
Map costs directly to dbt models and see which models are costing the most.
Self-hosted
Your data stays in your infrastructure. No SaaS fees, no vendor lock-in.
// free forever
FrostWatch is completely free and open-source
No Pro tier, no freemium — just good software, maintained in public. If it's useful to you, a GitHub star goes a long way.
// support
Need help with FrostWatch?
Submit a private support ticket, request a feature, or book a consulting session. I personally respond to every ticket.