Snowflake Failover Readiness Drill

What it does

When your agent uses it

• An owner needs a Business Critical disaster-recovery preflight
• Replication failure diagnosis
• Dangling-reference check
• Operator-executed drill proof

Example prompts

• “Snowflake failover drill”
• “replication RPO”
• “failback proof”
• “/snowflake-failover-readiness-drill”

Requirements

• Python 3
• Compatibility (from SKILL.md): Model-agnostic workflow; requires Python 3.10+; optional Snowflake CLI for live read-only evidence collection
• Pre-approved tools (allowed-tools): Read, Bash(python3:*)

Workflow steps

4 steps, taken from the first numbered list in SKILL.md.

1. 1Have the recovery owner approve an exact policy containing every in-scope
2. 2Collect replication-current in both source and target accounts. Collect
3. 3Build the exact schema-2 wrapper in
4. 4Run the analyzer; it writes only to stdout

What it can do on your machine

Read from SKILL.md and the folder at commit cfae287. It shows what the files ask for, not the result of running them.

• Tool permissions

  Pre-approves these tools, so the agent can use them without asking each time:

  • Read
  • Bash(python3:*)

  From allowed-tools in the SKILL.md frontmatter.

• Runs code

  Ships 7 files in scripts/ (Python), which the agent can run.

  Shell commands in SKILL.md call:

  • python3

  From the folder's file list and the shell code blocks in SKILL.md.

• Network

  No URLs in SKILL.md.

  From URLs in SKILL.md, links to its own repository left out.

• Credentials

  Names no API keys, tokens, secrets or passwords.

  From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.

• Compatibility

  Model-agnostic workflow; requires Python 3.10+; optional Snowflake CLI for live read-only evidence collection

  From compatibility in the SKILL.md frontmatter.

Context cost

Snowflake Failover Readiness Drill loads about 2.1k tokens when it runs, and up to ~4.7k if it reads all its reference files. Until then it costs about 128 tokens; SKILL.md has 771 words of instructions outside code blocks.

Always · name and description, kept in context so the agent knows when to use it

~128

When it runs · the whole SKILL.md, loaded when a task matches

~2.1k

With references · SKILL.md plus every file in references/, read only if the agent opens them

~4.7k

Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.

Safety

Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); the scripts in this folder are not scanned.

SKILL.md

The full file from jeremylongshore/tons-of-skills-marketplace at commit cfae287, republished under its MIT licence (© jeremylongshore). 771 words, ~2,074 tokens.

name

snowflake-failover-readiness-drill

description

Analyze Snowflake failover-group RPO/RTO readiness from independently trusted, privacy-preserving live receipts without executing refresh, failover, failback, redirect, cancellation, resume, or session changes. Use when an owner needs a Business Critical disaster-recovery preflight, replication failure diagnosis, dangling-reference check, or operator-executed drill proof. Trigger with "Snowflake failover drill", "replication RPO", "failback proof", or "secondary refresh".

allowed-tools

Read, Bash(python3:*)

compatibility

Model-agnostic workflow; requires Python 3.10+; optional Snowflake CLI for live read-only evidence collection

argument-hint

[schema-2-evidence.json]

version

3.16.0

author

Jeremy Longshore <jeremy@intentsolutions.io>

license

MIT

tags

saas, snowflake, disaster-recovery, failover, replication, rpo, rto

python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface replication-current --connection source-observer \
  --output ./source-current.json

python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface replication --connection target-observer \
  --window-start "$WINDOW_START_UTC" --window-end "$WINDOW_END_UTC" \
  --output ./target-history.json

python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface replication-progress --connection target-observer \
  --window-start "$WINDOW_START_UTC" --window-end "$WINDOW_END_UTC" \
  --output ./target-progress.json

python3 "${CLAUDE_SKILL_DIR}/scripts/collect_snowflake_evidence.py" \
  --surface replication-dangling --connection source-observer \
  --replication-group DR_CORE --output ./source-dangling.json

© jeremylongshore, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file

Files

SKILL.md and 10 other files (scripts, references) in skills/.curated/snowflake-failover-readiness-drill of jeremylongshore/tons-of-skills-marketplace.

• SKILL.md
• eval-spec.yaml
• references/evidence-contract.md
• references/source-notes.md
• scripts/analyze_failover_readiness.py
• scripts/collect_snowflake_evidence.py
• scripts/sql/replication-current.sql
• scripts/sql/replication-dangling.sql
• scripts/sql/replication-progress.sql
• scripts/sql/replication.sql
• scripts/test_analyze_failover_readiness.py

Open the folder on GitHubat commit cfae287