Agent skill
snowcli
CLI for Snowflake. Query data, manage warehouses, databases, schemas, tables, and stages. Use when working with Snowflake data platform.
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
# 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):
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
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.
Recommended Agent Skills
Expand your agent's capabilities with these related and highly-rated skills.
brave-search
Web search via the Brave Search API. Use to retrieve search results from Brave when web lookups are needed.
write-docs
Write AI-scannable technical documentation.
dogfood
Systematically explore and test a web application to find bugs, UX issues, and other problems. Use when asked to "dogfood", "QA", "exploratory test", "find issues", "bug hunt", "test this app/site/platform", or review the quality of a web application. Produces a structured report with full reproduction evidence -- step-by-step screenshots, repro videos, and detailed repro steps for every issue -- so findings can be handed directly to the responsible teams.
qmd-knowledge
Knowledge management with QMD (Quick Markdown Search). Search, retrieve, and organize your personal knowledge base, notes, docs, and meeting transcripts. Use when asking about past notes, documentation, meetings, or when needing to recall information from your indexed markdown files.
compare-tech
Compare technologies using a weighted scoring matrix. Use when evaluating libraries, frameworks, SaaS, or infrastructure options.
asncli
CLI for Asana. Manage projects and tasks.
Didn't find tool you were looking for?