如何安装 schemachange？

运行命令：npx killer-skills add sfc-gh-dflippo/snowflake-dbt-demo/schemachange。支持 Cursor、Windsurf、VS Code、Claude Code 等 19+ IDE/Agent。

schemachange 适用于哪些场景？

典型场景包括：使用版本控制和CI/CD管道部署和管理Snowflake数据库变更、使用Versioned脚本为一次性结构变更生成迁移脚本、使用Always脚本创建每次部署都运行的幂等脚本。

schemachange 支持哪些 IDE 或 Agent？

该技能兼容 Cursor, Windsurf, VS Code, Trae, Claude Code, OpenClaw, Aider, Codex, OpenCode, Goose, Cline, Roo Code, Kiro, Augment Code, Continue, GitHub Copilot, Sourcegraph Cody, and Amazon Q Developer。可使用 Killer-Skills CLI 一条命令通用安装。

schemachange 有哪些限制？

需要Snowflake数据库连接；仅限dbt功能用于数据库管理；需要CI/CD管道设置以实现自动化部署。

schemachange

安装 schemachange，这是一款面向AI agent workflows and automation的 AI Agent Skill。查看评审结论、使用场景与安装路径。

SKILL.md

Readonly

Upstream Repository Material

The section below is imported from the upstream repository and should be treated as secondary evidence. Use the Killer-Skills review above as the primary layer for fit, risk, and installation decisions.

Supporting Evidence

Schemachange

Name: schemachange
Availability: InStock
Author: sfc-gh-dflippo

Deploy and manage Snowflake database changes using version control and CI/CD pipelines with schemachange's migration-based approach.

Quick Start

Script Types:

V__ (Versioned) - One-time structural changes (run exactly once)
R__ (Repeatable) - Objects that can be safely recreated (runs when new/modified)
A__ (Always) - Scripts that run every deployment (must be idempotent)

Script Naming

Versioned Scripts (V__)

sql
1V1.0.0__initial_setup.sql
2V1.1.0__create_base_tables.sql
3V2.0.0__restructure_schema.sql

Use for: CREATE TABLE, ALTER TABLE, CREATE SCHEMA

Repeatable Scripts (R__)

sql
1R__Stage_01_create_views.sql
2R__Stage_02_alter_procedures.sql
3R__Stage_03_utility_functions.sql

Use for: CREATE OR ALTER VIEW, CREATE OR ALTER PROCEDURE, CREATE OR REPLACE STREAM

Always Scripts (A__)

sql
1A__refresh_permissions.sql
2A__update_config_values.sql

Use for: Jobs that must run every deployment (idempotent only)

Key Concepts

Execution Order

Versioned scripts (V__) in numeric order
Repeatable scripts (R__) in alphabetic order (use naming to control)
Always scripts (A__) in alphabetic order

CREATE OR ALTER vs CREATE OR REPLACE

CREATE OR ALTER - Preserves data, tags, policies, grants (preferred)
CREATE OR REPLACE - Drops and recreates (loses metadata)

See CREATE_OR_ALTER_REFERENCE.md for supported objects.

Configuration

yaml
1# schemachange-config.yml
2root-folder: migrations
3create-change-history-table: true
4connection-name: default
5change-history-table: MY_DB.SCHEMACHANGE.CHANGE_HISTORY

Deployment

bash
1# Dry run
2schemachange deploy --config-folder . --dry-run
3
4# Deploy
5schemachange deploy --config-folder .
6
7# With variables
8schemachange deploy --vars '{"env":"prod","schema":"data"}'

Resources

schemachange-config.yml - Complete configuration template
SCRIPT_PATTERNS.md - Examples for V**, R**, A__ scripts (coming soon)
CREATE_OR_ALTER_REFERENCE.md - Supported object types (coming soon)
CI_CD_EXAMPLES.md - GitHub Actions and Azure DevOps patterns (coming soon)

schemachange — community schemachange, snowflake-dbt-demo, community, ide skills

关于此技能

Killer-Skills Review

核心价值

适用 Agent 类型

↓ 赋予的主要能力 · schemachange

! 使用限制与门槛

Why this page is reference-only

Source Boundary

先决定动作，再继续看上游仓库材料

先进入安装与验证

回到可信合集再做一次复核

如果要进团队流转，转到工作流集合

Browser Sandbox Environment

⚡️ Ready to unleash?

常见问题与安装步骤

? FAQ

schemachange 是什么？

如何安装 schemachange？

schemachange 适用于哪些场景？

schemachange 支持哪些 IDE 或 Agent？

schemachange 有哪些限制？

↓ 安装步骤

! 参考页模式