Open Skills Logo
Open Skills

Snowflake Automation

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

Author

@ComposioHQ

Category

Development Tools

Install

Hot:48

Download and extract to your skills directory

Copy command and send to AI Agent for auto-install:

Download and install this skill https://openskills.cc/api/download?slug=composiohq-composio-skills-snowflake-automation&locale=en&source=copy

Snowflake Automation - Snowflake Data Warehouse Automation Tool

Skills Overview


Snowflake Automation is an automation tool integrated via Composio MCP. It is used to manage Snowflake data warehouse operations, supporting database discovery, table structure browsing, and automatic execution of SQL statements.

Use Cases


  • Daily data warehouse maintenance: Automatically list databases, Schemas, and table structures to quickly locate and browse data assets, without manually writing queries

  • Batch SQL execution: Execute SELECT queries, DDL (CREATE/ALTER/DROP), and DML (INSERT/UPDATE/DELETE) operations; supports parameterized binding to prevent injection

  • Cross-application data integration: Integrate Snowflake data operations into multi-application workflows to enable automated data transfer between different systems

    • Core Features


  • Database and table structure discovery: Uses SNOWFLAKE_SHOW_DATABASES, SNOWFLAKE_SHOW_SCHEMAS, and SNOWFLAKE_SHOW_TABLES to support wildcard filtering, prefix matching, and time-travel queries, quickly discovering available data assets and their metadata (row counts, sizes, clustering keys, etc.)

  • Automated SQL execution: Executes any SQL via SNOWFLAKE_EXECUTE_SQL (including multi-statement batch operations); supports parameterized binding, session-level parameter configuration, and timeout control

  • Flexible filtering and pagination: All SHOW commands support like_pattern, starts_with, limit (max 10000), and cursor pagination via from_name, enabling efficient browsing of large data warehouses

    • FAQ

    What SQL operations does Snowflake Automation support?


    It supports the full range of SQL operations, including SELECT queries, DDL (CREATE/ALTER/DROP), and DML (INSERT/UPDATE/DELETE). You can execute single or batch statements (separated by semicolons) via SNOWFLAKE_EXECUTE_SQL, with support for parameterized binding and session parameter configuration.

    How do I connect to a Snowflake account?


    First, add the Composio MCP server (https://rube.app/mcp) to the client, and then connect the Snowflake account when prompted. It supports two authentication methods: account credentials or a key pair.

    Does Snowflake automation require a Warehouse?


    SELECT and DML queries require a running Warehouse to provide compute resources, but SHOW commands (such as SHOW DATABASES) do not. Users can specify compute resources via the warehouse parameter, and control execution permissions via the role parameter.