grok-bot:LI4x0WdC_saRljwVwno4X

Snowflake Analyst

A read-only Snowflake analyst: ask warehouse questions in plain English, see the SQL behind each number, with cost checks.

Overview

A read-only Snowflake analyst. Ask warehouse questions in plain English; it writes and shows the SQL, labels every number with its query, checks cost before heavy scans, and never changes your data. Includes tested skills for validated ad-hoc answers, metric deep dives, cohorts, A/B readouts, query cost reviews, data-quality checks, and an optional weekly health report.

Contents

  • skill getting-started Use for a read-only Snowflake analyst bot's first conversation with a new owner: connect Snowflake's managed MCP server with a read-only role, learn which data matters, and offer the weekly health report.
  • skill snowflake-mcp-server-setup Use when a new owner needs to create a Snowflake-managed MCP server, a read-only role, and a PAT so the analyst bot can query their warehouse, or when that connection fails.
  • skill warehouse-health-report Use when running the weekly Snowflake warehouse health report: credits by warehouse, stale tables, failed loads, and failed tasks over the last 7 days, read-only.
  • skill table-profile Use when asked to profile, audit, or deeply understand a Snowflake table (or a set of tables): structure, size, column-level quality and distributions, keys, relationships, freshness, and analyst-ready findings, read-only.
  • skill question-to-sql Use for any ad-hoc business question that needs a number from Snowflake: finds the right tables, states grain and assumptions, writes the SQL, and validates joins, filters, nulls, and a cross-check before answering, read-only.
  • skill metric-deep-dive Use when asked why a metric went up or down between two periods: checks data issues first, then splits the change by dimension and into rate vs mix, read-only.
  • skill cohort-retention Use when asked about retention, churn, repeat behavior, or lifetime value by signup or first-purchase cohort: builds a cohort retention matrix, repeat rates, and cumulative value per member, read-only.
  • skill experiment-readout Use to read out an A/B test from assignment and outcome tables: sample ratio mismatch check, conversion and mean lifts with 95% CIs and p-values computed in SQL, guardrails, and caveats, read-only.
  • skill query-cost-review Use when asked which queries are slow or expensive, why warehouse spend rose, or how to tune: reviews ACCOUNT_USAGE query history and suggests fixes in plain English, read-only.
  • skill data-quality-monitor Use to check key tables for freshness, volume swings, null keys, duplicate keys, and orphaned foreign keys with PASS/WARN/FAIL per check; built for a weekly routine that alerts only on WARN or FAIL, read-only.
  • memory Memory entries · 7 items
  • plugin Plugin references · 1 items

Dependencies

Attachments

No separate attachments are published for this record.