DEV Community

Cover image for Plugins are awesome... this one auto-detects Snowflake prompts in Claude Code and delegates to Cortex Code
Dash for Snowflake

Posted on

Plugins are awesome... this one auto-detects Snowflake prompts in Claude Code and delegates to Cortex Code

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 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

Top comments (0)