What is required to use this Snowflake skill?

This skill requires the Composio MCP server (rube.app/mcp) and a Snowflake account with valid credentials or key-pair authentication.

Is multi-statement SQL execution supported?

Yes, you can execute multiple SQL statements in a single call by separating them with semicolons; they will execute sequentially.

How does the skill handle SQL injection security?

The SNOWFLAKE_EXECUTE_SQL tool uses a 'bindings' parameter for user-supplied values, ensuring that queries are parameterized and safe from injection attacks.

Can I access dropped database objects?

Yes, by enabling the 'history' flag in discovery tools, you can view and manage dropped objects that are still within their Snowflake Time Travel retention period.

Does listing tables require a running Snowflake warehouse?

No, SHOW commands like listing databases, schemas, and tables typically do not require an active warehouse. However, SELECT and DML queries do require compute resources.

Snowflake Automation

Name: Snowflake Automation
Author: Tako3832

byTako3832

0•

Gestión de Bases de Datos

Automates Snowflake data warehouse operations including schema discovery, metadata inspection, and SQL execution via Composio MCP.

This skill empowers Claude to interact directly with Snowflake data warehouses, enabling seamless data exploration and manipulation within your AI-driven development environment. It provides a comprehensive toolkit for listing databases, schemas, and tables with full metadata support, alongside the ability to execute complex SQL statements—including SELECT, DDL, and DML. With built-in support for parameterized bindings, session parameters, and Time Travel, it is an essential tool for data engineers and developers looking to integrate Snowflake workflows into automated pipelines.

Características Principales

01Support for Snowflake Time Travel to list and interact with dropped objects

02Prevent SQL injection using secure parameterized bindings

03Execute full SQL suites including SELECT queries, DDL, and DML statements

040 GitHub stars

05Discover databases, schemas, and tables with detailed metadata and row counts

06Multi-statement execution and session-level parameter management

Casos de Uso

01Integrating warehouse data operations into cross-application automation workflows

02Performing exploratory data analysis and table metadata audits

03Automating database migrations and schema setup scripts

Características Principales

01Support for Snowflake Time Travel to list and interact with dropped objects

02Prevent SQL injection using secure parameterized bindings

03Execute full SQL suites including SELECT queries, DDL, and DML statements

040 GitHub stars

05Discover databases, schemas, and tables with detailed metadata and row counts

06Multi-statement execution and session-level parameter management

Casos de Uso

01Integrating warehouse data operations into cross-application automation workflows

02Performing exploratory data analysis and table metadata audits

03Automating database migrations and schema setup scripts