Free & open source · GPL-3.0

A native SQL studio
built for Snowflake.

Thaw Studio is a free, open-source desktop workbench for analysts, data engineers, and DBAs who have outgrown Snowsight. Fast editor, deep object browser, notebooks with a built-in debugger, schema migrations, git & dbt integration, and an MCP server that connects AI agents to your warehouse.

Download for free View source on GitHub

Platform

macOS · Windows · Linux

License

Free — GNU GPL v3

Made by

Technarion Oy, Finland

thaw studio — ANALYTICS.SALES.ORDERS.sql

orders.sql

revenue_by_region.sql

-- Top customers by 30-day revenue
WITH windowed AS (
  SELECT
    o.customer_id,
    SUM(o.total) AS revenue,
    COUNT(*)     AS n_orders
  FROM ANALYTICS.SALES.ORDERS o
  WHERE o.ordered_at >= DATEADD(day, -30, CURRENT_DATE())
  GROUP BY 1
)
SELECT c.name, w.revenue, w.n_orders,
       fn_customer_tier(w.revenue) AS tier
FROM windowed w
JOIN ANALYTICS.SALES.CUSTOMERS c
  ON c.id = w.customer_id
ORDER BY w.revenue DESC
LIMIT 100;

● ran in 412 ms 100 rows · 8 cols query_id 01b3…c2f9 WH: ANALYST_XS

Built for

Snowflake power users who live in SQL all day.

Thaw Studio replaces a stack of half-working tools — the Snowsight tab, a generic IDE plugin, and a few bash scripts — with one focused desktop app. Free, open source, no account required.

// developers

Application developers

Edit stored procedures and scripting blocks with real syntax, diagnostics, and multi-cursor editing.

// analysts

Analysts

Browse schemas, preview tables, and export results to CSV / Excel or table data to CSV / JSON / Parquet.

// data eng

Data engineers

Schema migrations, dbt project scaffolding, DDL export to git, and task-graph orchestration in one place.

// CTOs

CTOs & leads

Warehouse credit dashboards, query activity history, visible query IDs, and backup sets for teams who care about governance.

What's inside

A real SQL editor, an honest object browser, and tools that respect your warehouse.

01 · SQL editor

Monaco-powered, Snowflake-aware

Multi-tab, multi-cursor, split view, code folding, hover DDL, live diagnostics for Snowflake-dialect SQL, execution-plan warnings, and a formatter with per-casing rules.

02 · Object browser

Every object, one right-click away

Tables — including dynamic, external, Iceberg, hybrid, and event tables — views, tasks, streams, pipes, stages, notebooks. Time-travel undrop, ER diagrams, and batch operations.

03 · Task graphs

Visual DAGs with live status

Interactive task graph with 3 s polling, skipped-state inference, finalizer support, and right-click suspend / resume / delete.

04 · Schema migration

Deploy DDL with strategies

Smart in-place, blue/green swap, soft cutover, or destructive rebuild — with dependency-aware passes and safety snapshots.

05 · Git & dbt

Your warehouse as a repository

Export DDL to files, commit and push with the embedded git client (no system git needed), and scaffold a working dbt project — with {{ ref() }} and {{ source() }} rewriting — from a live warehouse.

06 · AI & MCP

Bring your own AI agent

AI inline completions (OpenAI or Gemini), and a built-in MCP server that connects Claude Desktop, Cursor, or any MCP client to your warehouse — with metadata-only and read-only execution gates.

See the full feature list →

Download

Get Thaw Studio — free.

Thaw Studio is free software licensed under the GNU GPL v3. It ships as a single self-contained binary — no runtime to install, no account to create. Download it, connect to Snowflake, and go.

macOS