Snowflake Automation
Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.
npx skills add composio-community/awesome-codex-skills --skill snowflake-automation --agent codex
Same command for any agent — swap --agent for claude-code, cursor, copilot.
Weekly change comes from our own snapshots, not the repository page — it measures attention, not adoption.
# 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 (second
- Setup
- Core Workflows
- 1. List Databases
- 2. Browse Schemas
- 3. List Tables
- 4. Execute SQL Statements
- Known Pitfalls
- Quick Reference
What does the Snowflake Automation skill do?
Automate Snowflake data warehouse operations -- list databases, schemas, and tables, execute SQL statements, and manage data workflows via the Composio MCP integration.
How do I install it?
Run `npx skills add composio-community/awesome-codex-skills --skill snowflake-automation --agent claude-code` — it drops the skill into your project so the agent can pick it up. Swap the --agent value for codex, cursor or copilot if you use one of those.
Where does this skill come from?
From composio-community/awesome-codex-skills, a repository with 15,591 stars. We read it straight from the repository tree rather than a submitted listing, so what you see here is what is actually published.
Is a popular skill a good skill?
Not necessarily. Stars measure attention, not adoption — a repository can trend for a week and be abandoned. That is why we show the weekly change from our own snapshots next to the total, instead of a single flattering number.