Agent skill

snowcli

CLI for Snowflake. Query data, manage warehouses, databases, schemas, tables, and stages. Use when working with Snowflake data platform.

Stars 6
Forks 1

Install this agent skill to your Project

npx add-skill https://github.com/michalvavra/agents/tree/main/archive/skills/snowcli

SKILL.md

snowcli

CLI for Snowflake via Snowflake CLI.

Quick Reference

bash
# Run SQL query (use --format json for pipeable output)
snow sql -q "SELECT * FROM table LIMIT 10" --format json

# Show objects
snow sql -q "SHOW WAREHOUSES" --format json
snow sql -q "SHOW DATABASES" --format json
snow sql -q "SHOW SCHEMAS" --format json
snow sql -q "SHOW TABLES" --format json
snow sql -q "SHOW TABLES IN database.schema" --format json

# Describe table structure
snow sql -q "DESCRIBE TABLE database.schema.table" --format json

# Object commands
snow object list warehouse --format json
snow object list database --format json
snow object list schema --format json
snow object list table --format json

# Connection test
snow connection test

Output Formats

Always use --format json for agent workflows (pipeable to jq):

bash
snow sql -q "SHOW TABLES" --format json | jq '.[].name'
snow sql -q "SELECT * FROM t" --format json | jq 'length'

Available formats: json, csv, tsv, plain, table (default).

Specifying Connection

bash
snow sql -q "SHOW TABLES" -c connection_name

See references/setup.md for configuration and authentication. See references/examples.md for query patterns and workflows.

Expand your agent's capabilities with these related and highly-rated skills.

Didn't find tool you were looking for?

Be as detailed as possible for better results