connect-snowflake SKILL.md skillB

connect-snowflake from ai-analyst-lab/ai-analyst is an agent skill: a SKILL.md folder an AI agent loads when a task calls for it.

Install it, pinned
mdr add ai-analyst-lab/ai-analyst/connect-snowflake@git:20260930.0a47c0b

Pins git:20260930.0a47c0b in mdr.lock. Pin the fingerprint instead.

Audit grade
B, 16 of 17 checks passed
Kind
SKILL.md skill
Repository
ai-analyst-lab/ai-analyst
Path
.claude/skills/connect-snowflake/SKILL.md
Versions recorded
5
Latest version
git:20260930.0a47c0b, committed Sep 30, 2026
First version recorded
Aug 27, 2026
Size
5,664 bytes
Repository stars
322
License
MIT

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.

Collected from public GitHub. Every version is saved exactly as it was and never changes. Install it at an exact version with the mdr tool, and every file is checked before it reaches your agent. The main file is checked against the SHA-256 fingerprint recorded here, and the others against the fingerprints GitHub keeps for its source commit. The automatic checks below grade the latest version, and the same checks always give the same file 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

The exact contents, by fingerprint
mdr add ai-analyst-lab/ai-analyst/connect-snowflake@sha256:1766a0f496645a60

The line at the top of this page pins the label git:20260930.0a47c0b, which is what most people want. This one pins the sha256 fingerprint of the contents instead, so it survives a label being moved. Either way the exact version is written to mdr.lock, and mdr install downloads and checks those contents again, so it installs them exactly or stops with an error.

Badge

mdr badge

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

4 badge image fetches in 30 days. What the badge shows.

Versions

The registry has recorded 5 versions of this file, between Aug 27, 2026 and Sep 30, 2026, about one every 8 days. Its first recorded version is graded A and its latest B.

versioncommittedcommitsizeaudit
git:20260930.0a47c0b latest2026-09-30 0a47c0b 5,664 BB view · diff
git:20260917.a038f7a2026-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. Fixed automatic checks with no AI involved, so the same checks give the 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 (5664 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

Starting a new one? Use a template for SKILL.md on mdpantry, which passes every one of these checks and says what to change in it.

Source

GitHub

ai-analyst-lab/ai-analyst · 322 stars · license MIT · pushed 2026-09-30 · 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/1766a0f496645a6077cb4277ad85c9da7d0878e47dd7bf77ff454f1bd7c9ae6f

Your AI assistant 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.

Guides: the SKILL.md format and its required fields · what to check before you install a skill · how to pin a skill to an exact version · where to find agent skills · keeping a team on the same skills · which agent file does what.

More from ai-analyst-lab/ai-analyst

always-compare SKILL.md 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 · 322 stars
analysis-design SKILL.md 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 · 322 stars
analyst-core SKILL.md 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:20260930.0a47c0b · audit A · 322 stars
archaeology SKILL.md 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 · 322 stars
archive-analysis SKILL.md 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 · 322 stars
auth-preflight SKILL.md 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 · 322 stars
business SKILL.md 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 · 322 stars
causal SKILL.md 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 · 322 stars
chart-to-drive SKILL.md 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 · 322 stars
close-the-loop SKILL.md 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 · 322 stars
codex-review SKILL.md 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 · 322 stars
compare-datasets SKILL.md 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 · 322 stars

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

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