I built a Claude Code plugin that adds Snowflake capabilities through Cortex Code and it is now available in Claude's official marketplace.

Run these inside Claude Code:

/plugin marketplace add anthropic/claude-plugins-official
/plugin install snowflake-cortex-code

This is how it works:

• You type a prompt in Claude Code
• A keyword filter (regex with word boundaries) checks if it's Snowflake-related. If ambiguous, a scoring system weighs Snowflake indicators (SQL patterns, Cortex skill triggers, "warehouse", "dynamic table") against non-Snowflake ones (git, local files, other databases).
• If Snowflake wins, it spawns a Cortex Code session and pipes the response back
• If not, Claude handles it normally

The permission model: Every tool call goes through a hard gate so Cortex asks permission before executing anything, and an envelope policy decides allow/deny.

The default envelope is RW: SQL writes are fine, but destructive bash (rm -rf, sudo, force push) gets blocked. Switch to RO and even CREATE/INSERT gets denied at the gate. It also keeps session state across turns, so follow-ups like "describe the largest one" work without re-explaining context.

Check it out and let me know what you think.

Cheers,
Dash