snowflake
Query Snowflake data warehouse — execute SQL, manage warehouses, and query metadata via the SQL API.
Source facts
- Repository
- ThinkfleetAI/thinkfleet-engine
- Last source activity
- February 1, 2026 at 16:21
- Detected SKILL.md language
- English
- Stars
- 0
- Forks
- 0
Install options
The review-first prompt is selected by default. You can switch to a direct command or download a local copy.
Review the source files
Read SKILL.md and any companion files shown by SkillsMP before deciding whether to install.
Showing SKILL.md
SKILL.md
Source instructions · Read-only preview- name
- snowflake
- description
- Query Snowflake data warehouse — execute SQL, manage warehouses, and query metadata via the SQL API.
- metadata
- {"thinkfleetbot":{"emoji":"❄️","requires":{"bins":"[Truncated]","env":"[Truncated]"}}}
# Snowflake
Execute SQL queries and manage warehouses via the Snowflake SQL API.
## Environment Variables
- `SNOWFLAKE_ACCOUNT` - Account identifier (e.g. `abc12345.us-east-1`)
- `SNOWFLAKE_USER` - Username
- `SNOWFLAKE_PASSWORD` - Password
## Execute SQL
```bash
curl -s -X POST \
"https://$SNOWFLAKE_ACCOUNT.snowflakecomputing.com/api/v2/statements" \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $SNOWFLAKE_PASSWORD" \
-d '{"statement":"SELECT * FROM my_table LIMIT 10","warehouse":"COMPUTE_WH","database":"MY_DB","schema":"PUBLIC"}' | jq '{statementHandle, data: .data[:5]}'
```
## List databases
```bash
curl -s -X POST \
"https://$SNOWFLAKE_ACCOUNT.snowflakecomputing.com/api/v2/statements" \
-H "Content-Type: application/json" \
-H "Authorization: Bearer $SNOWFLAKE_PASSWORD" \
-d '{"statement":"SHOW DATABASES","warehouse":"COMPUTE_WH"}' | jq '.data[]'
```
## Notes
- SQL API requires key-pair or OAuth auth in production.
- Always confirm before running DDL or DML statements.
View on GitHub