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

Enter fullscreen mode

Exit fullscreen mode

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…