Snowflake Automation by composiohq/awesome-claude-skills
npx skills add https://github.com/composiohq/awesome-claude-skills --skill 'Snowflake Automation'自动化您的 Snowflake 数据仓库工作流 —— 发现数据库、浏览模式和表、执行任意 SQL(SELECT、DDL、DML),并将 Snowflake 数据操作集成到跨应用流水线中。
工具包文档: composio.dev/toolkits/snowflake
https://rube.app/mcp使用 SNOWFLAKE_SHOW_DATABASES 来发现可用的数据库,支持可选过滤和时间旅行功能。
Tool: SNOWFLAKE_SHOW_DATABASES
Inputs:
- like_pattern: string (SQL 通配符,例如 "%test%") -- 不区分大小写
- starts_with: string (例如 "PROD") -- 区分大小写
- limit: integer (最大 10000)
- history: boolean (包含时间旅行保留期内已删除的数据库)
- terse: boolean (返回列的子集:created_on, name, kind, database_name, schema_name)
- role: string (用于执行的角色)
- warehouse: string (可选,SHOW DATABASES 不需要)
- timeout: integer (秒)
使用 来列出数据库内或整个账户中的模式。
广告位招租
在这里展示您的产品或服务
触达数万 AI 开发者,精准高效
SNOWFLAKE_SHOW_SCHEMASTool: SNOWFLAKE_SHOW_SCHEMAS
Inputs:
- database: string (数据库上下文)
- in_scope: "ACCOUNT" | "DATABASE" | "<specific_database_name>"
- like_pattern: string (SQL 通配符过滤器)
- starts_with: string (区分大小写的前缀)
- limit: integer (最大 10000)
- history: boolean (包含已删除的模式)
- terse: boolean (仅返回列的子集)
- role, warehouse, timeout: string/integer (可选)
使用 SNOWFLAKE_SHOW_TABLES 来发现表及其元数据,包括行数、大小和聚类键。
Tool: SNOWFLAKE_SHOW_TABLES
Inputs:
- database: string (数据库上下文)
- schema: string (模式上下文)
- in_scope: "ACCOUNT" | "DATABASE" | "SCHEMA" | "<specific_name>"
- like_pattern: string (例如 "%customer%")
- starts_with: string (例如 "FACT", "DIM", "TEMP")
- limit: integer (最大 10000)
- history: boolean (包含已删除的表)
- terse: boolean (仅返回列的子集)
- role, warehouse, timeout: string/integer (可选)
使用 SNOWFLAKE_EXECUTE_SQL 执行 SELECT 查询、DDL(CREATE/ALTER/DROP)和 DML(INSERT/UPDATE/DELETE),支持参数化绑定。
Tool: SNOWFLAKE_EXECUTE_SQL
Inputs:
- statement: string (必需) -- SQL 语句,多条语句用分号分隔
- database: string (区分大小写,回退到 DEFAULT_NAMESPACE)
- schema_name: string (区分大小写)
- warehouse: string (区分大小写,计算密集型查询必需)
- role: string (区分大小写,回退到 DEFAULT_ROLE)
- bindings: object (参数化查询值,防止 SQL 注入)
- parameters: object (Snowflake 会话级参数)
- timeout: integer (秒;0 = 最大 604800 秒)
示例:
"SELECT * FROM my_table LIMIT 100;""CREATE TABLE test (id INT, name STRING);""ALTER SESSION SET QUERY_TAG='mytag'; SELECT COUNT(*) FROM my_table;"| 注意事项 | 详情 |
|---|---|
| 区分大小写 | 在 SNOWFLAKE_EXECUTE_SQL 中,数据库、模式、仓库和角色名称区分大小写。 |
| 计算需要仓库 | SELECT 和 DML 查询需要运行中的仓库。SHOW 命令则不需要。 |
| 多语句执行 | 用分号分隔的多条语句会自动顺序执行。 |
| 防止 SQL 注入 | 对于用户提供的值,始终使用 bindings 参数以防止注入攻击。 |
| 使用 LIMIT 分页 | SHOW 命令支持 limit(最大 10000)和 from_name 用于基于游标的分页。 |
| 时间旅行 | 设置 history: true 以包含仍在保留期内的已删除对象。 |
| 工具标识 | 描述 |
|---|---|
SNOWFLAKE_SHOW_DATABASES | 列出数据库,支持过滤和时间旅行 |
SNOWFLAKE_SHOW_SCHEMAS | 列出数据库内或整个账户中的模式 |
SNOWFLAKE_SHOW_TABLES | 列出表及其元数据(行数、大小、聚类) |
SNOWFLAKE_EXECUTE_SQL | 执行 SQL:SELECT、DDL、DML,支持参数化绑定 |
由 Composio 提供支持
每周安装量
0
代码仓库
GitHub 星标数
42.3K
首次出现
Jan 1, 1970
安全审计
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://rube.app/mcpUse 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 (seconds)
Use SNOWFLAKE_SHOW_SCHEMAS to list schemas within a database or across the account.
Tool: SNOWFLAKE_SHOW_SCHEMAS
Inputs:
- database: string (database context)
- in_scope: "ACCOUNT" | "DATABASE" | "<specific_database_name>"
- like_pattern: string (SQL wildcard filter)
- starts_with: string (case-sensitive prefix)
- limit: integer (max 10000)
- history: boolean (include dropped schemas)
- terse: boolean (subset columns only)
- role, warehouse, timeout: string/integer (optional)
Use SNOWFLAKE_SHOW_TABLES to discover tables with metadata including row counts, sizes, and clustering keys.
Tool: SNOWFLAKE_SHOW_TABLES
Inputs:
- database: string (database context)
- schema: string (schema context)
- in_scope: "ACCOUNT" | "DATABASE" | "SCHEMA" | "<specific_name>"
- like_pattern: string (e.g., "%customer%")
- starts_with: string (e.g., "FACT", "DIM", "TEMP")
- limit: integer (max 10000)
- history: boolean (include dropped tables)
- terse: boolean (subset columns only)
- role, warehouse, timeout: string/integer (optional)
Use SNOWFLAKE_EXECUTE_SQL for SELECT queries, DDL (CREATE/ALTER/DROP), and DML (INSERT/UPDATE/DELETE) with parameterized bindings.
Tool: SNOWFLAKE_EXECUTE_SQL
Inputs:
- statement: string (required) -- SQL statement(s), semicolon-separated for multi-statement
- database: string (case-sensitive, falls back to DEFAULT_NAMESPACE)
- schema_name: string (case-sensitive)
- warehouse: string (case-sensitive, required for compute-bound queries)
- role: string (case-sensitive, falls back to DEFAULT_ROLE)
- bindings: object (parameterized query values to prevent SQL injection)
- parameters: object (Snowflake session-level parameters)
- timeout: integer (seconds; 0 = max 604800s)
Examples:
"SELECT * FROM my_table LIMIT 100;""CREATE TABLE test (id INT, name STRING);""ALTER SESSION SET QUERY_TAG='mytag'; SELECT COUNT(*) FROM my_table;"| Pitfall | Detail |
|---|---|
| Case sensitivity | Database, schema, warehouse, and role names are case-sensitive in SNOWFLAKE_EXECUTE_SQL. |
| Warehouse required for compute | SELECT and DML queries require a running warehouse. SHOW commands do not. |
| Multi-statement execution | Multiple statements separated by semicolons execute in sequence automatically. |
| SQL injection prevention | Always use the bindings parameter for user-supplied values to prevent injection attacks. |
| Pagination with LIMIT | SHOW commands support limit (max 10000) and from_name for cursor-based pagination. |
| Time Travel |
| Tool Slug | Description |
|---|---|
SNOWFLAKE_SHOW_DATABASES | List databases with filtering and Time Travel support |
SNOWFLAKE_SHOW_SCHEMAS | List schemas within a database or account-wide |
SNOWFLAKE_SHOW_TABLES | List tables with metadata (row count, size, clustering) |
SNOWFLAKE_EXECUTE_SQL | Execute SQL: SELECT, DDL, DML with parameterized bindings |
Powered byComposio
Weekly Installs
0
Repository
GitHub Stars
42.3K
First Seen
Jan 1, 1970
Security Audits
DOCX文件创建、编辑与分析完整指南 - 使用docx-js、Pandoc和Python脚本
41,800 周安装
Set history: true to include dropped objects still within the retention period. |