What is snowflake-architecture-diagram-standalone?

A skill for creating Snowflake data architecture diagrams without connecting to a Snowflake account. Snowflake is a cloud data platform, and the skill can compose a diagram from the request or adapt one of 14 known reference designs when the match is clear.

Use it to draft diagrams for data platforms such as a bronze/silver/gold lakehouse, or other Snowflake architectures described in a prompt.

It lets someone create an exportable architecture diagram before a Snowflake connection is available. Its rules also keep reference templates from replacing prompt-specific design work.

snowflake-architecture-diagram-standalone — Skill by sfc-gh-abannerjee

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent

npx skills add sfc-gh-abannerjee/SnowGram --skill standalone

Clone the repo

git clone --depth 1 https://github.com/sfc-gh-abannerjee/SnowGram

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

README.md

[![agentmods](https://agentmods.dev/badge/skills/sfc-gh-abannerjee/snowgram/standalone/github.svg)](https://agentmods.dev/skills/sfc-gh-abannerjee/snowgram/standalone)

Your own site

<a href="https://agentmods.dev/skills/sfc-gh-abannerjee/snowgram/standalone"><img src="https://agentmods.dev/badge/skills/sfc-gh-abannerjee/snowgram/standalone/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

Your own site · 80×15

<a href="https://agentmods.dev/skills/sfc-gh-abannerjee/snowgram/standalone"><img src="https://agentmods.dev/badge/skills/sfc-gh-abannerjee/snowgram/standalone.svg" alt="Reviewed on agentmods" width="80" height="20"></a>

Per session 66 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.

When invoked 2,419 The whole file, excluding the scripts and references it only reads on demand.

Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.

Origin original No closer match found in the catalogue.

Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

Model	Per session	Once invoked
Fable 5.1	$0.00066	$0.02419
Opus 5.5	$0.00026	$0.00968
Sonnet 5.5	$0.00013	$0.00484
Haiku 4.5	$0.00007	$0.00242

Measured 2mo ago against content hash fe9e76eb50e9, method: parsed. Prices are Anthropic first-party input rates as of 2026-10-07, from the pricing page.

Security

Grade A, and why

snowflake-architecture-diagram-standalone scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 2mo ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/snowflake-architecture-diagram/modes/standalone/SKILL.md · 193 lines

How it starts

The opening of the file, as written. The whole thing — 193 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Standalone mode

Generate exportable Snowflake architecture diagrams without needing a deployed SnowGram agent or any Snowflake connection. The default path composes a fresh diagram from flow_builder informed by cortex search docs and Snowflake-expert SME skills. The 14 bundled reference-architecture templates serve as fallbacks for prompts that cleanly match a known pattern (e.g. "medallion lakehouse with bronze/silver/gold").

Design rule (enforced by the rule store):

Templates are FALLBACKS, not the default generation path. Generate from-scratch (rich-state authoring) when the prompt does not closely match a known template pattern. Only fall back to a template when the prompt's intent maps cleanly onto one of the 14 reference architectures, AND in that case still apply prompt-driven customizations rather than emitting the template verbatim.

Path resolution (do this once)

This sub-skill uses $SKILL_DIR/... paths. Resolve them by sourcing the canonical helper:

source "<SKILL_BASE_DIR>/assets/scripts/skill_paths.sh"
# Sets $SKILL_DIR, $TEMPLATES_DIR, $COMPOSER_DIR, $VIEWER_DIR, $SCRIPTS_DIR, $STATE_FILE.

For Python helpers, import assets/scripts/skill_paths.py analogously. The parent SKILL.md shows the importlib pattern.

Workflow

Step 1 — Gather domain knowledge (PRIMARY, not optional)

Quality of the rendered diagram depends on having current Snowflake best-practice context BEFORE composition. Skip this step ONLY for trivial / one-off requests; for any production-quality diagram, do all three sub-steps.

1a. Detect pipeline type

PIPELINE_TYPE=$(python3 "$COMPOSER_DIR/intent_router.py" --detect-type "<user prompt>" | python3 -c "import sys,json;print(json.load(sys.stdin)['pipeline_type'])")

1b. Run targeted documentation queries

python3 "$COMPOSER_DIR/intent_router.py" --queries-for "$PIPELINE_TYPE"
# → 3 queries to feed cortex search docs

Read the full file on GitHub · 193 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

2mo ago First seen · 193 lines · 66 tokens per session scan A fe9e76eb50e9

Subscribe to this mod's changes

snowflake-architecture-diagram-standalone is a skill published in the GitHub repository sfc-gh-abannerjee/SnowGram (2 stars, last pushed 1mo ago), licensed MIT. It adds 66 tokens to every session and 2,419 once invoked, about $0.0003 per session on Opus 5.5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-31.

Databases Design and UX

snowflake-architecture-diagram-standalone next to 6 skills from other repositories
Mod	Type	Stars	Last push	Licence	Scan	Tokens	Works with
snowflake-architecture-diagram-standalonesfc-gh-abannerjee/SnowGram	Skill	2	1mo ago	MIT	A	66	Claude Code, Codex
slidesgridaco/grida	Skill	2.7k	yesterday	Apache-2.0	A	46	Claude Code, Codex
dotcanvasgridaco/grida	Skill	2.7k	yesterday	Apache-2.0	A	69	Claude Code, Codex
datamodellmnimbalyst/nimbalyst	Skill	2.0k	2d ago	MIT	A	45	Claude Code, Codex
svggridaco/grida	Skill	2.7k	yesterday	Apache-2.0	A	39	Claude Code, Codex
er-diagramsexcalimate/excalimate	Skill	100	5d ago	MIT	A	52	Claude Code, Codex
dashboard-designDeepSQLAI/deepsql	Skill	40	5d ago	Apache-2.0	A	43	Claude Code, Codex