Agent skill · software engineering · composiohq
Snowflake Automation
Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.
Why this skill is useful
Adds executable scripts for automating Snowflake operations that are not commonly known or documented.
What it needs
Requires composio installed locally. Requires snowflake account access. About 2k tokens when loaded. Last updated 2026-07-24. 71,973 stars on the source repository.
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 --- 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 SNOWFLAKESHOWDATABASES to discover available databases with optional filtering and Time Travel support. 2. Browse Schemas Use SNOWFLAKESHOWSCHEMAS to list schemas within a database or across the account. 3. List Tables Use SNOWFLAKESHOWTABLES to discover tables with metadata including row counts, sizes, and clustering keys. 4. Execute SQL Statements Use SNOWFLAKEEXECUTESQL for SELECT queries, DDL (CREATE/ALTER/DROP), and DML (INSERT/UPDATE/DELETE) with parameterized bindings. Examples: "SELECT FROM mytable LIMIT 100;" "CREATE TABLE test (id INT, name STRING);" "ALTER SESSION SET QUERYTAG='mytag'; SELECT COUNT() FROM mytable;" --- Known Pitfalls Pitfall Detail --------- -------- Case sensitivity Database, schema, warehouse, and role names are case-sensitive in SNOWFLAKEEXECUTESQL. 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 fromname for cursor-based pagination. Time Travel Set history: true to include dropped objects still within the retention period. …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills composiohq/snowflake-automation