🎯

snowflake-automation

🎯Skill
composiohq/awesome-claude-skills2 Installs66,821Last Updated May 22, 2026

Installation

$npx skills add composiohq/awesome-claude-skills --skill snowflake-automation

Run it in a terminal; it asks which AI coding tools to install it for (Claude Code, Codex, Cursor and more).

Uses skills.sh Β· Node.js 22.20+

After installing

Ask for related work and the agent uses it on its own, or call it yourself.

Run it (Claude Code)/Snowflake Automation
Install by hand

Copy the whole skill folder from GitHub to the place below. Copying only SKILL.md can leave out files the skill uses.

Open the skill folder β†’
  • This project .claude/skills/snowflake-automation/
  • All projects ~/.claude/skills/snowflake-automation/

These paths are for Claude Code. For other tools, the command above puts it in the right place.

Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.

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


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

PitfallDetail
Case sensitivityDatabase, schema, warehouse, and role names are case-sensitive in SNOWFLAKE_EXECUTE_SQL.
Warehouse required for computeSELECT and DML queries require a running warehouse. SHOW commands do not.
Multi-statement executionMultiple statements separated by semicolons execute in sequence automatically.
SQL injection preventionAlways use the bindings parameter for user-supplied values to prevent injection attacks.
Pagination with LIMITSHOW commands support limit (max 10000) and from_name for cursor-based pagination.
Time TravelSet history: true to include dropped objects still within the retention period.

Quick Reference

Tool SlugDescription
SNOWFLAKE_SHOW_DATABASESList databases with filtering and Time Travel support
SNOWFLAKE_SHOW_SCHEMASList schemas within a database or account-wide
SNOWFLAKE_SHOW_TABLESList tables with metadata (row count, size, clustering)
SNOWFLAKE_EXECUTE_SQLExecute SQL: SELECT, DDL, DML with parameterized bindings

Powered by Composio

More from this repository10

πŸ”Œ
meeting-insights-analyzerπŸ”ŒPlugin

A Claude Code plugin that analyzes meeting notes and transcripts to extract key insights, action items, and decisions using Composio app integrations.

πŸ”Œ
video-downloaderπŸ”ŒPlugin

A Claude Code plugin from the Awesome Claude Skills collection that downloads videos from YouTube and other platforms for offline viewing, editing, or archival, with support for various formats and quality options.

πŸ”Œ
content-research-writerπŸ”ŒPlugin

A Claude Code plugin that assists in writing high-quality content by conducting research, adding citations, improving hooks, and providing section-by-section feedback.

πŸ”Œ
file-organizerπŸ”ŒPlugin

A Claude Code plugin that automatically organizes and categorizes files in your workspace using Composio integrations, helping maintain a clean project structure.

πŸ”Œ
artifacts-builderπŸ”ŒPlugin

A Claude Code plugin providing tools for creating elaborate, multi-component HTML artifacts using React, Tailwind CSS, and shadcn/ui in claude.ai.

πŸ”Œ
raffle-winner-pickerπŸ”ŒPlugin

A Claude Code skill that randomly selects winners from participant lists, spreadsheets, or Google Sheets for giveaways and contests using cryptographically secure randomness.

πŸ”Œ
zoho-crm-automationπŸ”ŒPlugin

A Claude Code plugin that automates Zoho CRM workflows including lead management, contact updates, deal tracking, account operations, and custom module interactions through Composio integration.

πŸ”Œ
brand-guidelinesπŸ”ŒPlugin

A Claude Code plugin that enforces brand consistency by checking code and content against your brand guidelines using Composio integrations.

πŸ”Œ
helpdesk-automationπŸ”ŒPlugin

A pre-built workflow skill for automating Help Scout via Composio, enabling Claude to manage conversations, customers, mailboxes, and tags through structured tool sequences and parameter guidance.

πŸ”Œ
changelog-generatorπŸ”ŒPlugin

A Claude Code plugin that automatically creates user-facing changelogs from git commits by analyzing commit history and transforming technical commits into customer-friendly release notes.