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
