snowflake-automationlisted

# 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_