Home / ai-analyst-lab / ai-analyst · .claude/skills/setup-snowflake/SKILL.md · GitHub

setup-snowflake skillC

setup-snowflake is agent-read markdown (skill) from ai-analyst-lab/ai-analyst: First-time Snowflake setup wizard for the NATIVE ConnectionManager path (the connection the analyst actually queries through, with auto-logged provenance). Prompts for every connection field, stores the approved credential in .env, registers the dataset, and VERIFIES the session is live on the warehouse before declaring success. Use when the user says "set up snowflake", "connect to snowflake", "configure the warehouse", or is routed here from /connect-data. For day-to-day remote querying after .

Indexed from public GitHub and served as immutable, content-addressed versions. Install it pinned to an exact SHA-256 with the mdr CLI, and every file is verified against the hash recorded here before it reaches your agent. The deterministic audit below grades the latest version, and the same file always earns the same grade.

What the file says

# Skill: Setup Snowflake

## Purpose
Guided first-time Snowflake setup for the **native `ConnectionManager` path** — the connection the
AI Analyst uses for every query, so every result is traced and logged. This wizard collects the
connection details, stores credentials safely, registers the dataset, and then **proves the session
is actually on the warehouse** (not the local practice copy) before it will report success.

This is deliberately native-first. The MCP server (`snowflake-labs-mcp` via `uvx`) is a separate,
optional tool for interactive ad-hoc queries and is kept in the Appendix. The analyst does not query
through the MCP, so setting up only the MCP leaves the analyst unconnected. Set up the native path
first.

## When to Use
- `/setup-snowflake`, "set up snowflake", "connect to snowflake", "I have a snowflake account"
- Routed here from `/connect-data` when the user selects Snowflake

## Prerequisite: the driver
The native path needs `snowflake-connector-python`. Check it and install if missing:
```bash
python3 -c "import snowflake.connector; print('driver OK')" || pip install snowflake-connector-python
```
…

Read the whole file at its exact version.

How to install

Latest version
mdr add ai-analyst-lab/ai-analyst/setup-snowflake@git:20260917.a038f7a
Exact content
mdr add ai-analyst-lab/ai-analyst/setup-snowflake@sha256:fc8d690692bd5ab4

Pin to a label to follow the author's releases, or to a sha256 to freeze the exact bytes forever. Either way the resolved hash is written to mdr.lock, and mdr install reproduces it on any machine.

Badge

mdr badge

[![mdr](https://markdownregistry.com/badge/art_yyavittq26ky7yzo.svg)](https://markdownregistry.com/a/art_yyavittq26ky7yzo)

1 badge views in 30 days

Versions

versioncommittedcommitsizeaudit
git:20260917.a038f7a latest2026-09-17 a038f7a 7,916 BC view · diff
git:20260902.b370de62026-09-02 b370de6 7,158 BC view · diff
git:20260828.6faa0892026-08-28 6faa089 7,205 BC view · diff
git:20260827.7ff2e252026-08-27 7ff2e25 8,336 BC view

Audit of the latest version

C  15 of 17 checks passed. Deterministic, no model, same answer every run.
  • fail: No curl or wget piped into a shell (matched: curl -LsSf https://astral.sh/uv/install.sh | sh)
  • fail: No instruction to read or print local credentials (matched: Read any existing `.env)
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (7916 bytes)
  • pass: No zero-width or bidi control characters
  • pass: No instruction hidden inside an HTML comment
  • pass: No link to an exfiltration or paste host
  • pass: No credential-shaped string
  • pass: No instruction to send local credentials anywhere
  • pass: No text hidden with inline styles
  • pass: No prompt-injection phrasing
  • pass: No recursive delete of root, home or parent
  • pass: No base64 blob over 200 characters
  • pass: No link to a raw IP address
  • pass: No script tag

Source

GitHub

ai-analyst-lab/ai-analyst · 302 stars · license MIT · pushed 2026-09-22 · branch main

API

GET https://markdownregistry.com/api/v1/artifacts/art_yyavittq26ky7yzo
GET https://markdownregistry.com/api/v1/resolve?ref=ai-analyst-lab/ai-analyst/setup-snowflake
GET https://markdownregistry.com/api/v1/blob/fc8d690692bd5ab43d7d07099231884fd5b0de6f663c278f1255e70cc6ec1971

Your agent does the legwork. You hear about the deals worth your word. Hand yours the standing instructions at modelranch.com and it joins the network that reads files like this one.

More from ai-analyst-lab/ai-analyst

always-compare skill
ai-analyst-lab/ai-analyst · .claude/skills/always-compare/SKILL.md · Never present a metric or number in isolation; anchor every number to a comparison (prior period, benchmark, or another…
git:20260827.7ff2e25 · audit A · 302 stars
analysis-design skill
ai-analyst-lab/ai-analyst · .claude/skills/analysis-design/SKILL.md · Takes a vague analytical hunch, stakeholder request, or business question and produces a rigorous, stakeholder-ready…
git:20260902.b370de6 · audit A · 302 stars
analyst-core skill
ai-analyst-lab/ai-analyst · .claude/skills/analyst-core/SKILL.md · Operating rules for every data analysis. Apply for ANY data-analysis intent: "analyze", "investigate", "why did X…
git:20260921.652dcb5 · audit A · 302 stars
archaeology skill
ai-analyst-lab/ai-analyst · .claude/skills/archaeology/SKILL.md · Retrieve proven SQL patterns, table cheatsheets, and join patterns from .knowledge/query-archaeology/ so past work gets…
git:20260827.7ff2e25 · audit A · 302 stars
archive-analysis skill
ai-analyst-lab/ai-analyst · .claude/skills/archive-analysis/SKILL.md · Save completed analyses to the knowledge system's analysis archive for future reference. Use this skill after…
git:20260902.b370de6 · audit A · 302 stars
auth-preflight skill
ai-analyst-lab/ai-analyst · .claude/skills/auth-preflight/SKILL.md · Verify Google Workspace MCP authentication at the start of any session that needs Google APIs (Docs, Slides, Drive)…
git:20260902.b370de6 · audit A · 302 stars
business skill
ai-analyst-lab/ai-analyst · .claude/skills/business/SKILL.md · Browse, search, and explore your organization's business context system — glossary terms, product catalog, metric…
git:20260902.b370de6 · audit A · 302 stars
causal skill
ai-analyst-lab/ai-analyst · .claude/skills/causal/SKILL.md · Causal inference toolkit for when experiments are not possible: estimate treatment effects from observational data with…
git:20260828.01c26bc · audit A · 302 stars
chart-to-drive skill
ai-analyst-lab/ai-analyst · .claude/skills/chart-to-drive/SKILL.md · Standardized workflow for uploading local chart PNGs to Google Drive and making them available for insertion into…
git:20260827.7ff2e25 · audit A · 302 stars
close-the-loop skill
ai-analyst-lab/ai-analyst · .claude/skills/close-the-loop/SKILL.md · Ensure every analysis that includes a recommendation ends with a clear, actionable follow-up plan. CRITICAL RULE - Only…
git:20260902.b370de6 · audit A · 302 stars
codex-review skill
ai-analyst-lab/ai-analyst · .claude/skills/codex-review/SKILL.md · Independently validate the current analysis with a second model (OpenAI Codex). Codex re-derives the same answer from…
git:20260902.b370de6 · audit A · 302 stars
compare-datasets skill
ai-analyst-lab/ai-analyst · .claude/skills/compare-datasets/SKILL.md · Compare metrics, findings, and patterns across two or more connected datasets. Helps identify cross-dataset patterns…
git:20260902.b370de6 · audit A · 302 stars

Every file in ai-analyst-lab/ai-analyst

Browse by kind, by grade C, or by owner.