Skillget

snowflake-ai-kit

skill
Security Audit
Fail
Health Warn
  • License — License: Apache-2.0
  • Description — Repository has a description
  • Active repo — Last push 0 days ago
  • Low visibility — Only 5 GitHub stars
Code Fail
  • execSync — Synchronous shell command execution in bin/install.mjs
  • rm -rf — Recursive force deletion command in install.sh
  • rm -rf — Recursive force deletion command in plugins/cortex-code/scripts/router/execute_cortex.py
Permissions Pass
  • Permissions — No dangerous permissions requested
Purpose
This toolkit provides developer utilities for building AI applications on Snowflake. It features a one-command installer for setting up Snowflake CLI and Cortex Code CLI, alongside a Claude Code plugin that automatically routes Snowflake-related prompts to Cortex.

Security Assessment
Overall Risk: Medium

The tool does not request explicitly dangerous permissions and lacks hardcoded secrets. However, there are significant security concerns in the installation and execution scripts. The automated installer uses synchronous shell command execution (`execSync`), which is generally discouraged due to potential blocking and injection risks. Additionally, multiple scripts—including the bash installer and a Python execution script—utilize recursive force deletion commands (`rm -rf`). While this is common for setting up file structures, it raises the risk of unintended data loss or malicious directory wiping if the scripts are altered. Developers should carefully inspect the shell and Python scripts before running the installer to ensure safe execution.

Quality Assessment
The project is actively maintained, with repository pushes occurring as recently as today, and is properly licensed under Apache-2.0. However, community trust and visibility are currently very low. With only 5 GitHub stars, the project is extremely new and untested by the broader open-source community. It appears to be an official or experimental project from the Snowflake-Labs organization, but users should expect early-stage software with potential rough edges.

Verdict
Use with caution — while actively maintained and officially licensed, the tool's early-stage community validation and risky scripting patterns warrant a careful manual review of the code before executing the installers.
SUMMARY

Snowflake AI Kit: Cortex Code plugin for automatic Snowflake routing, envelope-based permission policy, and one-command installers for Snowflake CLI + Cortex Code CLI.

README.md

Snowflake AI Kit

Developer tools for building on Snowflake with AI coding agents. Includes a one-command installer for Snowflake CLI + Cortex Code CLI and a Claude Code plugin that automatically routes Snowflake prompts to Cortex Code.

Table of Contents

Get Started

The installer sets up Snowflake CLI and Cortex Code CLI. The Cortex Code plugin for Claude Code is installed separately via the Claude Code plugin marketplace -- it automatically detects Snowflake prompts and routes them to Cortex Code.

What's Included

This repo includes:

Component What it does Install location
Snowflake CLI (snow) Manage Snowflake objects, deploy apps, run SQL from the terminal System PATH (via pipx/pip/brew)
Cortex Code CLI (cortex) AI coding assistant for Snowflake — generate code, explore data, build apps System PATH (via official installer)
Cortex Code plugin for Claude Code Auto-route Snowflake prompts from Claude Code to Cortex Code Claude Code marketplace (separate install)

Install

git clone https://github.com/Snowflake-Labs/snowflake-ai-kit.git
cd snowflake-ai-kit

Installer Options

Flag Description
--check / -Check Check installation status without installing
--update / -Update Re-install (overwrite existing)
--help / -Help Show help

macOS / Linux

bash install.sh

Windows (PowerShell)

.\install.ps1

npx (any platform)

npx @snowflake-labs/ai-kit

Snowflake Connection

Snow CLI and Cortex Code CLI both share the same Snowflake connection config (~/.snowflake/connections.toml). Set one up with:

snow connection add

Usage

After installing, open a terminal and run:

cortex                         # Start Cortex Code (interactive AI assistant)
snow connection list           # Verify your Snowflake connection
cortex skill list              # Browse 40+ built-in skills

With the plugin installed, Claude Code automatically routes Snowflake prompts to Cortex Code:

claude                         # Start Claude Code — Snowflake queries auto-route to Cortex

Ask naturally ("show me my tables", "check data quality on SALES_DATA") and it routes to Cortex Code. Non-Snowflake prompts stay in Claude Code.

To explicitly invoke Cortex Code (bypassing auto-routing):

$cortex-run analyze query performance for the last 7 days

See the plugin docs for security model and configuration.

Skills

Bundled Skills (Cortex Code CLI)

Cortex Code CLI ships with 40+ built-in skills that activate automatically based on your prompt. No setup required -- they're included in every install.

View all available skills:

cortex skill list

Skills are organized by source:

Category Description
BUNDLED Ship with the CLI binary. Updated automatically on cortex update.
GLOBAL User-installed skills in ~/.snowflake/cortex/skills/. Shared across all projects.
EXTERNAL Added via cortex skill add <path>. Point to local directories or Git repos.
PROJECT Discovered from the current working directory (e.g. .claude/skills/).

Examples of bundled skills: semantic-view, cortex-agent, data-quality, dynamic-tables, cost-intelligence, machine-learning, iceberg, data-governance, cortex-ai-functions, deploy-to-spcs, lineage, dbt-projects-on-snowflake, snowflake-notebooks, security-investigation, workload-performance-analysis.

Add a custom skill from a local path or GitHub:

cortex skill add /path/to/my-skill
cortex skill add owner/repo

Plugins

Cortex Code Plugin for Claude Code

Automatically route Snowflake work from Claude Code to Cortex Code. When you ask about your Snowflake data, the plugin detects the intent and delegates to Cortex Code -- no slash command needed. Just ask naturally:

  • "Show me the top 10 customers by revenue"
  • "Check data quality for the SALES_DATA table"
  • "Create a dynamic table that refreshes hourly"

Non-Snowflake prompts ("fix the bug in auth.py", "write a unit test") stay in Claude Code as usual.

Install via Claude Code marketplace

Coming soon: This plugin will be available from the official Anthropic marketplace.

No clone required. Run these commands inside Claude Code:

# Add the Snowflake AI Kit as a Claude Code marketplace
/plugin marketplace add Snowflake-Labs/snowflake-ai-kit

# Install the plugin
/plugin install cortex-code@snowflake-ai-kit

To update later: /plugin update cortex-code

See plugins/cortex-code/ for full documentation, security model, and configuration.

Troubleshooting

Problem Fix
snow: command not found Make sure ~/.local/bin (pipx) or your Python scripts dir is in $PATH. Try opening a new terminal.
cortex: command not found Re-run the installer. If it still fails, install manually from the Cortex Code CLI docs.
pip/pipx not found Install Python 3.10+ first: python.org
Connection errors Run snow connection add to create ~/.snowflake/connections.toml. Docs: Specify credentials
Installer hangs on Windows Run PowerShell as Administrator, or download and run the script manually.
Plugin not routing Make sure the plugin is enabled: check ~/.claude/settings.json has "enabledPlugins": { "cortex-code@snowflake-ai-kit": true }

Contributing

All PRs run CI automatically on macOS and Windows via GitHub Actions (test.yml). The full test suite (209 tests) must pass on both platforms before merging.

To run tests locally:

bash tests/run-tests.sh --verbose        # macOS / Linux
.\tests\run-tests.ps1 -Verbose           # Windows (PowerShell)

License

Copyright (c) Snowflake Inc. All rights reserved.

The skills in this project are licensed under the Snowflake Skills License.

All other content is licensed under the Apache 2.0 license.

Reviews (0)

No results found