A secure, read-only Snowflake execution layer designed for governed data exploration and automated SQL analysis.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install snowflake
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install snowflake using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Snowflake Data Engineering Skill?
The Snowflake Data Engineering Skill provides a robust and governed interface for interacting with Snowflake data warehouses. It is engineered specifically for scenarios where data integrity and security are paramount, enforcing a strict SELECT-only policy that prevents any unauthorized data modification or schema changes. By utilizing this skill within the Openclaw Skills ecosystem, developers can safely integrate live data lookups and complex analytical queries into their automated workflows without risking accidental DDL or DML execution.
This skill acts as a middleware execution layer that wraps every request with security checks, including keyword blacklisting and execution timeouts. It is an ideal solution for teams that need to provide AI agents or automated scripts with access to sensitive data while maintaining a high level of governance and auditability.
Snowflake Data Engineering Skill Use Cases
- Safely performing ad-hoc data exploration within Openclaw Skills environments.
- Generating automated reports and data summaries from Snowflake tables.
- Integrating live data lookups into multi-agent engineering workflows.
- Monitoring data trends without the risk of altering source datasets.
How Snowflake Data Engineering Skill Works
- The user or agent submits a SQL query to the skill interface.
- The skill analyzes the query string to ensure it only contains SELECT statements and does not include forbidden keywords.
- The skill applies mandatory row limiting and statement timeouts to protect system resources.
- The query is executed using a dedicated, read-only Snowflake role configured in the backend.
- The result set is processed and returned as a structured JSON response, accompanied by detailed execution metadata.
Snowflake Data Engineering Skill Setup
To deploy this skill, ensure you have a Snowflake service account with a read-only role assigned. Configure your environment variables as follows:
export SNOWFLAKE_ACCOUNT="your_account_identifier"
export SNOWFLAKE_USER="your_username"
export SNOWFLAKE_PASSWORD="your_password"
export SNOWFLAKE_ROLE="READ_ONLY_ROLE"
export SNOWFLAKE_WAREHOUSE="your_warehouse"
Ensure the Openclaw Skills agent has access to these environment variables during runtime to authenticate successfully.
Snowflake Data Engineering Skill Data Schema & Taxonomy
The skill returns data in a structured format to ensure compatibility with other Openclaw Skills.
| Field | Description |
|---|---|
status |
Indicates if the query was successful or blocked by security rules |
data |
An array of JSON objects representing the result rows |
metadata |
Contains query_id, execution_time, and total_rows_returned |
errors |
Detailed error messages if the query fails validation or execution |
Snowflake Data Engineering Skill Advanced Features
- Enforced SELECT-only execution to prevent DDL/DML operations.
- Automated forbidden keyword blocking for enhanced SQL injection protection.
- Configurable row limiting to optimize performance and prevent memory exhaustion.
- Structured JSON output optimized for integration with other Openclaw Skills tools.
- Detailed execution metadata return for performance auditing and tracking.
SKILL.md
Loading
Related Openclaw Skills
Family Todo Manager
A lightweight, multi-user todo list manager for families powered by Node.js and JSON storage.
TikTok Dark-Motivation Video Generator
A full AI pipeline to create dark motivational TikTok and Reels videos using real video footage and multi-agent orchestration.
Zeelin Social Watch
A powerful integration for monitoring social media sentiment, trending events, and cross-platform account data via the GSData open platform.
ZeeLin Report Publisher
Automates the end-to-end process of publishing technical reports to the ZeeLin platform, including asset management and Pull Request creation.
IPinfo Geolocation
A high-performance IP intelligence tool for resolving IP addresses into precise geographic and organizational data.
GiftDrop Skill
A specialized skill for Solana that enables humans and AI agents to distribute and claim crypto gift drops through a simplified API.
Featured*
