# Snowcli

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

- Skill: `michalvavra/snowcli` (Agent Skill, multi-file: 3 files)
- Install (CLI): `npx skillmds@latest add michalvavra/snowcli`
- Raw SKILL.md: https://api.skillmd.com/api/skills/michalvavra/snowcli/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: michalvavra (https://skillmd.com/u/michalvavra)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/michalvavra/snowcli

---


# snowcli

CLI for Snowflake via [Snowflake CLI](https://docs.snowflake.com/en/developer-guide/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](references/setup.md) for configuration and authentication.
See [references/examples.md](references/examples.md) for query patterns and workflows.