AI · DataOpen SourceFree

FrostWatch

Self-hosted Snowflake cost & query observability — free, open-source SELECT.dev alternative

PythonSnowflakeLLMdbtObservability

GitHub ↗

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

// compared with

FrostWatch as an alternative

FrostWatch focuses on Snowflake teams comparing paid observability platforms but wanting a free, self-hosted way to track warehouse cost and query behavior.

Alternative to SELECT.devAlternative to Chaos GeniusAlternative to KeeboAlternative to Seemore Data

A good fit if you are looking for Snowflake cost monitoring open source self-hosted, especially around Snowflake query observability self-hosted, Snowflake cost monitoring open source self-hosted, Snowflake credit usage tracking tool, Snowflake cost optimisation tool free.

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

⭐ Star on GitHub Report an Issue

// support

Need help with FrostWatch?

Submit a private support ticket, request a feature, or book a consulting session. I personally respond to every ticket.

Get Support Request Feature Consulting