Snowflake Automation
Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.
Get the complete skill folder, including its scripts and reference files.
This workflow depends on an external MCP integration. Check the source for the server, account access and setup it requires.
When to use this skill
Use Snowflake Automation when an AI agent needs a reusable SKILL.md workflow for this job: Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.
When not to use it
Skip Snowflake Automation when the task is outside the productivity category, or when a more specific skill in this directory already covers the same workflow with clearer triggers.
How to install
Where will you use it?
mkdir -p ~/.claude/skills/snowflake-automation # Save SKILL.md to ~/.claude/skills/snowflake-automation/SKILL.md
- Claude Code personal install: place the skill and its bundled files at ~/.claude/skills/snowflake-automation/SKILL.md. For a shared project, commit the folder at .claude/skills/snowflake-automation/ instead.
- Current Claude Code detects SKILL.md changes in watched directories during the session. If you just created a top-level skills directory, run /reload-skills. Check that the skill is listed before testing its trigger.
- For Claude chat or Cowork in the Desktop app, manage uploaded skills in Customize > Skills; copying files into a local Claude Code folder is not a Desktop install. Other agents may use different install locations.
Full install guide for Claude, Cursor, and Codex →
Try a starter prompt
After installing the skill, paste this starter prompt into your agent to verify it triggers on a small task.
Use the Snowflake Automation skill for this task: Use Snowflake Automation when this documented workflow matches the task. Confirm any required inputs or files before making changes.
What supports this recommendation?
72/100 provisional content score. This measures documentation, practical detail and source signals. It is not a measured task success rate or a security certification.
- Documentation
- 77/100
- Practical detail
- 68/100
- Source evidence
- 63/100
- Source signals
- 80/100
Model compatibility evidence
- claudeinferred
The skill text mentions Claude or a closely associated term. This is keyword-derived compatibility; no hands-on model test is recorded.
- chatgptuntested
No model-specific signal or recorded compatibility test was found.
- geminiuntested
No model-specific signal or recorded compatibility test was found.
- copilotuntested
No model-specific signal or recorded compatibility test was found.
- llamauntested
No model-specific signal or recorded compatibility test was found.
- perplexityuntested
No model-specific signal or recorded compatibility test was found.
- mistraluntested
No model-specific signal or recorded compatibility test was found.
- grokuntested
No model-specific signal or recorded compatibility test was found.
Inferred compatibility is based on content signals. Check the app, its available tools and setup requirements before running a skill.
What this skill does
# Snowflake Automation
Automate your Snowflake data warehouse workflows -- discover databases, browse schemas and tables, execute arbitrary SQL (SELECT, DDL, DML), and integrate Snowflake data operations into cross-app pipelines.
**Toolkit docs:** [composio.dev/toolkits/snowflake](https://composio.dev/toolkits/snowflake)
---
## Setup
1. Add the Composio MCP server to your client: `https://rube.app/mcp` 2. Connect your Snowflake account when prompted (account credentials or key-pair authentication) 3. Start using the workflows below
---
## Core Workflows
### 1. List Databases
Use `SNOWFLAKE_SHOW_DATABASES` to discover available databases with optional filtering and Time Travel support.
``` Tool: SNOWFLAKE_SHOW_DATABASES Inputs: - like_pattern: string (SQL wildcard, e.g., "%test%") -- case-insensitive - starts_with: string (e.g., "PROD") -- case-sensitive - limit: integer (max 10000) - history: boolean (include dropped databases within Time Travel retention) - terse: boolean (return subset of columns: created_on, name, kind, database_name, schema_name) - role: string (role to use for execution) - warehouse: string (optional, not required for SHOW DATABASES) - timeout: integer (seconds) ```
### 2. Browse Schemas
Use `SNOWFLAKE_SHOW_SCHEMAS` to list schemas within a database or across the account.
``` Tool: SNOWFLAKE_SHOW_SCHEMAS Inputs: - database: string (database context) - in_scope: "ACCOUNT" | "DATABASE" | "<specific_database_name>" - like_pattern: string (SQL wildcard filter) - starts_with: string (case-sensitive prefix) - limit: integer (max 10000) - history: boolean (include dropped schemas) - terse: boolean (subset columns only) - role, warehouse, timeout: string/integer (optional) ```
### 3. List Tables
Use `SNOWFLAKE_SHOW_TABLES` to discover tables with metadata including row counts, sizes, and clustering keys.
``` Tool: SNOWFLAKE_SHOW_TABLES Inputs: - database: string (database context) - schema: string (schema context) - in_scope: "ACCOUNT" | "DATABASE" | "SCHEMA" | "<specific_name>" - like_pattern: string (e.g., "%customer%") - starts_with: string (e.g., "FACT", "DIM", "TEMP") - limit: integer (max 10000) - history: boolean (include dropped tables) - terse: boolean (subset columns only) - role, warehouse, timeout: string/integer (optional) ```
### 4. Execute SQL Statements
Use `SNOWFLAKE_EXECUTE_SQL` for SELECT queries, DDL (CREATE/ALTER/DROP), and DML (INSERT/UPDATE/DELETE) with parameterized bindings.
``` Tool: SNOWFLAKE_EXECUTE_SQL Inputs: - statement: string (required) -- SQL statement(s), semicolon-separated for multi-statement - database: string (case-sensitive, falls back to DEFAULT_NAMESPACE) - schema_name: string (case-sensitive) - warehouse: string (case-sensitive, required for compute-bound queries) - role: string (case-sensitive, falls back to DEFAULT_ROLE) - bindings: object (parameterized query values to prevent SQL injection) - parameters: object (Snowflake session-level parameters) - timeout: integer (seconds; 0 = max 604800s) ```
**Examples:** - `"SELECT * FROM my_table LIMIT 100;"` - `"CREATE TABLE test (id INT, name STRING);"` - `"ALTER SESSION SET QUERY_TAG='mytag'; SELECT COUNT(*) FROM my_table;"`
---
## Known Pitfalls
| Pitfall | Detail | |---------|--------| | Case sensitivity | Database, schema, warehouse, and role names are case-sensitive in `SNOWFLAKE_EXECUTE_SQL`. | | Warehouse required for compute | SELECT and DML queries require a running warehouse. SHOW commands do not. | | Multi-statement execution | Multiple statements separated by semicolons execute in sequence automatically. | | SQL injection prevention | Always use the `bindings` parameter for user-supplied values to prevent injection attacks. | | Pagination with LIMIT | `SHOW` commands support `limit` (max 10000) and `from_name` for cursor-based pagination. | | Time Travel | Set `history: true` to include dropped objects still within the retention period. |
---
## Quick Reference
| Tool Slug | Description | |-----------|-------------| | `SNOWFLAKE_SHOW_DATABASES` | List databases with filtering and Time Travel support | | `SNOWFLAKE_SHOW_SCHEMAS` | List schemas within a database or account-wide | | `SNOWFLAKE_SHOW_TABLES` | List tables with metadata (row count, size, clustering) | | `SNOWFLAKE_EXECUTE_SQL` | Execute SQL: SELECT, DDL, DML with parameterized bindings |
---
*Powered by [Composio](https://composio.dev)*
Intended uses
- Use Snowflake Automation when this documented workflow matches the task.
Implementation notes
- Review the source instructions and adapt inputs before running the workflow.
Try it, then tell us how it went
A copied prompt does not tell us whether the task worked. Report your result after checking the output. We collect your tool and outcome, never your files or prompt.