michalvavra/snowcli
archive/skills/snowcli/SKILL.md
CLI for Snowflake. Query data, manage warehouses, databases, schemas, tables, and stages. Use when working with Snowflake data platform.
$ install --global
skillsauthnpx skillsauth add michalvavra/agents snowcliInstall this skill globally with one command. Works with Claude Code, Cursor, and Windsurf.
Security Scan Results
3 of 9 scanners reported clean
Some scanners were skipped, did not run, or reported a non-clean status. Review each row below.
3
Scanners Passed
9
Scanners in report
Clean
TrivyContainer and dependency vulnerability scanner
95%
Clean
SemgrepStatic code analysis for vulnerabilities
95%
Clean
mcp-scan (Snyk)Model Context Protocol security validation
95%
Skipped
Snyk (dep)Open source security scanning
50%
Skipped
Socket.devSupply chain security analysis
50%
Skipped
VirusTotalMulti-engine malware detection
50%
Skipped
CrowdStrikeAdvanced threat intelligence
50%
Skipped
OSV-ScannerOpen Source Vulnerability database check
50%
Skipped
OWASP Dep-Check
50%
Last scanned: May 12, 2026, 6:07 AM151.3s3 files scanned
SKILL.md
- name:
- snowcli
- description:
- CLI for Snowflake. Query data, manage warehouses, databases, schemas, tables, and stages. Use when working with Snowflake data platform.
- compatibility:
- Requires snow CLI (docs.snowflake.com/en/developer-guide/snowflake-cli). Needs ~/.snowflake/config.toml with connection config.
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.
Related Skills
michalvavra/version-releases
devops
VerifiedTrustedCommunity
Use when preparing, reviewing, or documenting versioned app releases, changelogs, SemVer bumps, release commits, git tags, or tag-gated production deploys
14SKILL.mdUpdated May 12, 2026
michalvavra/architecture-review
development
VerifiedTrustedCommunity
Staff-level codebase health review. Finds monolithic modules, silent failures, type safety gaps, test coverage holes, and LLM-friendliness issues.
14SKILL.mdUpdated May 12, 2026
michalvavra/write-docs
documentation
VerifiedTrustedCommunity
Write AI-scannable technical documentation.
14SKILL.mdUpdated May 12, 2026
michalvavra/search-hexdocs
development
VerifiedTrustedCommunity
Search HexDocs documentation for Elixir and Erlang packages. Use when looking up package APIs or guides.
14SKILL.mdUpdated May 12, 2026