Can I access deleted tables using this skill?

Yes, by setting the 'history' parameter to true in discovery tools, you can view dropped objects that are still within the Snowflake Time Travel retention period.

How does the skill prevent SQL injection?

The SNOWFLAKE_EXECUTE_SQL tool includes a specific 'bindings' parameter for user-supplied values, ensuring all queries are parameterized and handled securely.

Is case sensitivity an issue with Snowflake Automation?

Yes, names for databases, schemas, warehouses, and roles are case-sensitive when using the SNOWFLAKE_EXECUTE_SQL tool.

Does this skill require a running Snowflake warehouse?

Yes, while discovery commands like SHOW DATABASES do not typically require a warehouse, compute-bound queries such as SELECT, INSERT, or UPDATE statements require an active warehouse.

Snowflake Automation

Name: Snowflake Automation
Author: ComposioHQ

byComposioHQ

•

47,560

•

Database Management

Automates Snowflake data warehouse operations including metadata discovery, SQL execution, and data pipeline integration.

This skill empowers Claude to interact directly with Snowflake data warehouses, enabling seamless database exploration and management. It allows users to browse schemas, list tables with detailed metadata like row counts and clustering keys, and execute complex SQL statements—ranging from data analysis queries to administrative DDL and DML operations. By providing a secure, parameterized environment for SQL execution and supporting Snowflake-specific features like Time Travel, it is an essential tool for data engineers and analysts seeking to automate routine warehouse maintenance or perform ad-hoc data investigations via AI.

Key Features

0147,560 GitHub stars

02Secure parameterized query bindings to prevent SQL injection.

03Support for Snowflake Time Travel to access dropped or historical objects.

04Automated discovery of databases, schemas, and tables with metadata.

05Execution of complex SQL including SELECT, DDL, and DML statements.

06Multi-statement execution support for complex data workflows.

Use Cases

01Automating daily data warehouse maintenance and schema audits.

02Orchestrating data transformation pipelines within cross-app workflows.

03Performing AI-assisted ad-hoc data analysis and exploration.

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add composiohq/awesome-claude-skills snowflake-automation

For use in Claude.ai and ChatGPT

Download Skill