Snowflake profiles, minus the worksheet.
Password/MFA, key-pair, OAuth, and external-browser authentication, typed Snowflake SQL, schema snapshot, diff, and designer, encrypted archives, and administration.
Password/MFA · key-pair · OAuth · external browser
The query profile Mongrel would show you.
Click any operator below to see partitions scanned, time share, and what Mongrel would suggest. Same view you get inside the workbench.
// TableScan · analytics.events
Scans 4,218 of 4,230 micro-partitions (38.4 GB). Pruning 0.3% — the date filter can't prune because events has no clustering key. Mongrel suggests CLUSTER BY (event_date, account_id).
-- analytics · ANALYTICS_WH (X-Small) SELECT DATE_TRUNC('week', e.event_date) AS week, a.plan, COUNT(*) AS events, SUM(e.revenue) AS revenue FROM analytics.events e JOIN analytics.accounts a ON a.account_id = e.account_id WHERE e.event_date >= '2026-01-01' GROUP BY 1, 2 ORDER BY week DESC, revenue DESC; -- 1m 42s · 38.4 GB scanned · 4,218/4,230 partitions -- ✓ Proposal: clustering key on event_date ALTER TABLE analytics.events CLUSTER BY (event_date, account_id);
What Mongrel ships for Snowflake.
Visual query builder
Build SELECTs, JOINs, and aggregations visually. Output is typed Snowflake SQL — both sides stay editable.
Query profile inspector
Per-operator breakdown: partitions scanned and pruned, bytes spilled, remote I/O, and where query time actually goes.
Clustering & warehouse tuning
Proposals for clustering keys, warehouse size changes, and result-cache hits — grounded in your actual profiles.
Schema snapshots & diff
Snapshot databases, schemas, and tables. Diff any two environments and generate reversible DDL.
Schema designer
Model schemas, tables, and relationships visually. Generates clean Snowflake DDL, not worksheet spaghetti.
Auth, your way
Password with MFA, key-pair, OAuth, or external browser. Per-connection, stored securely, never in plaintext.
AI explain & rewrite
Paste a query and its profile. The assistant rewrites it, proposes clustering keys, and shows the predicted profile.
Encrypted archives
Export result sets and schema snapshots into encrypted archives. Restore or share them on your terms.
Administration
Warehouses, users, roles, and resource monitors. Query history and live activity without opening a worksheet.