Snowflake CLI Integration

Free v1.0.0

Execute Snowflake SQL queries with the snow CLI, auto-building schema knowledge across sessions

Requires Claude Code CLI

This skill integrates with Snowflake through Claude Code. Install Claude Code and add this skill to use it.

Available Actions

Execute SQL Query

Run any SQL query against your Snowflake warehouse

Parameters

Name Type Required Description
query string Required SQL query to execute
database string Optional Override default database
schema string Optional Override default schema
format string Optional Output format

Returns

string Query results in the specified format

Try saying...

  • "Run this SQL in Snowflake: SELECT * FROM customers LIMIT 10"
  • "Query Snowflake for total sales by region"
  • "Execute this Snowflake query and return JSON"

Run SQL File

Execute SQL statements from a file

Parameters

Name Type Required Description
file_path string Required Path to SQL file

Returns

string Query results

Try saying...

  • "Run the SQL file at /path/to/query.sql in Snowflake"
  • "Execute this Snowflake script file"

List Databases

Show all accessible databases in your Snowflake account

Returns

array List of database names and metadata

Try saying...

  • "Show me all Snowflake databases"
  • "List databases in my Snowflake account"
  • "What databases do I have access to?"

List Warehouses

Show all virtual warehouses in your Snowflake account

Returns

array List of warehouses with status and size

Try saying...

  • "List all Snowflake warehouses"
  • "Show me available compute warehouses"
  • "What warehouses can I use?"

List Schemas

Show all schemas in a database

Parameters

Name Type Required Description
database string Required Database name

Returns

array List of schema names

Try saying...

  • "List schemas in the ANALYTICS database"
  • "Show me schemas in my Snowflake database"
  • "What schemas exist in PROD_DB?"

List Tables

Show all tables in a schema

Parameters

Name Type Required Description
database string Required Database name
schema string Required Schema name

Returns

array List of table names with metadata

Try saying...

  • "List tables in ANALYTICS.PUBLIC"
  • "Show me all tables in the RAW schema"
  • "What tables are in PROD_DB.CORE?"

Describe Table

Get column definitions for a table

Parameters

Name Type Required Description
table string Required Fully qualified table name or just table name if context is set

Returns

array Column names, types, and constraints

Try saying...

  • "Describe the customers table in Snowflake"
  • "What columns are in the orders table?"
  • "Show me the schema of ANALYTICS.PUBLIC.EVENTS"

Test Connection

Verify your Snowflake CLI configuration works

Returns

string Connection status message

Try saying...

  • "Test my Snowflake connection"
  • "Is Snowflake configured correctly?"
  • "Verify Snowflake credentials"

View Schema Context

View the accumulated schema knowledge from previous sessions

Returns

string Contents of the schema context file

Try saying...

  • "Show me what you know about my Snowflake schema"
  • "What tables have you discovered?"
  • "View Snowflake schema context"

Clear Schema Context

Reset the schema knowledge to start fresh

Returns

string Confirmation that context was cleared

Try saying...

  • "Clear the Snowflake schema context"
  • "Forget what you know about my schema"
  • "Reset schema knowledge"

Getting Started

CLI Authentication Easy Setup
  1. 1 Install Snowflake CLI: brew install snowflake-cli (macOS) or pipx install snowflake-cli (Linux/Windows)
  2. 2 Create config directory: mkdir -p ~/.snowflake && chmod 700 ~/.snowflake
  3. 3 Create ~/.snowflake/config.toml with your account, user, and password
  4. 4 Set permissions: chmod 600 ~/.snowflake/config.toml
  5. 5 Test connection: snow connection test

Verify Setup

snow connection test

Success: Connection established successfully

View full setup guide

Security & Access

Access Scope

Full SQL access to your Snowflake account based on your user's role and permissions. Can read, write, and modify any data your Snowflake user has access to.

  • The CLI has full access to everything your Snowflake user can access
  • Store config.toml with 600 permissions (owner read/write only)
  • Never commit ~/.snowflake/config.toml to version control
  • For automation, use key-pair authentication instead of passwords
  • Consider using environment variables for sensitive credentials
  • Queries may incur compute costs on your Snowflake account

Limitations

  • Requires Snowflake CLI to be installed and configured
  • Query results are limited by terminal output size for TABLE format
  • For very large result sets, use JSON/CSV format and redirect to file
  • Interactive mode (snow sql without args) requires TTY

Get This Skill

Quick Reference

Type
CLI
Auth
CLI Authentication
Setup
Easy Setup
Tools Required
Bash Read Write
CLI Dependencies
snow

Documentation

Have Feedback?

Help us improve this skill by sharing your ideas and suggestions.

Request Improvements