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

connect-snowflake skillB

connect-snowflake is agent-read markdown (skill) from ai-analyst-lab/ai-analyst: Query the live/remote Snowflake warehouse instead of the local practice copy. Use when the user says "connect to snowflake", "use the live data", "go remote", "query the warehouse", or asks "is this hitting snowflake or duckdb?". Assumes credentials already exist (first-time setup is /setup-snowflake); opts into remote via ConnectionManager and verifies the connection type before any query runs..

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: Connect to Live Snowflake

## Purpose
Run queries against the **live Snowflake** warehouse — not the local
DuckDB practice copy. This is the runbook for "actually go remote." Credentials
and config already exist; this skill is about *opting into remote and verifying
you landed there*.

This is distinct from `/setup-snowflake` (the first-time wizard that collects the
connection fields, stores the approved credential in `.env`, and verifies the native
ConnectionManager session). Use **this** skill when the
warehouse is already configured and you just want to query the live data through
`ConnectionManager`.

## When to Use
Trigger on any request to use the live/remote Snowflake data, e.g.:
- "connect to snowflake", "query snowflake", "use the live data / live warehouse"
- "run this against snowflake / the real data / production", "go remote"
- "is this hitting snowflake or duckdb?", "query the live tables"
- Any analysis where the user explicitly wants live warehouse numbers rather than
  the local DuckDB practice snapshot

## How the repo decides local vs. remote
`detect_active_source()` (in `helpers/data/data_helpers.py`) defaults to the **local
…

Read the whole file at its exact version.

How to install

Latest version
mdr add ai-analyst-lab/ai-analyst/connect-snowflake@git:20260917.a038f7a
Exact content
mdr add ai-analyst-lab/ai-analyst/connect-snowflake@sha256:3f80b05c3a1ee0a4

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_nidmhrxmoadvbqhm.svg)](https://markdownregistry.com/a/art_nidmhrxmoadvbqhm)

1 badge views in 30 days

Versions

versioncommittedcommitsizeaudit
git:20260917.a038f7a latest2026-09-17 a038f7a 5,249 BB view · diff
git:20260902.b370de62026-09-02 b370de6 5,201 BB view · diff
git:20260828.6faa0892026-08-28 6faa089 5,309 BA view · diff
git:20260827.7ff2e252026-08-27 7ff2e25 5,011 BA view

Audit of the latest version

B  16 of 17 checks passed. Deterministic, no model, same answer every run.
  • fail: No instruction to read or print local credentials (matched: cat `.env)
  • pass: Frontmatter block present
  • pass: Frontmatter declares a name
  • pass: Frontmatter declares a description
  • pass: Size between 200 bytes and 200 KB (5249 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 curl or wget piped into a shell
  • 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_nidmhrxmoadvbqhm
GET https://markdownregistry.com/api/v1/resolve?ref=ai-analyst-lab/ai-analyst/connect-snowflake
GET https://markdownregistry.com/api/v1/blob/3f80b05c3a1ee0a4dffce46fc1c98616d41d1d011ffe3b2801137282a5e8a2a3

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 B, or by owner.