Agent skill · software engineering · aiskillstore
snowtower-admin
Advanced skill for SnowTower infrastructure administrators. Use for SnowDDL operations, user provisioning, role management, CI/CD deployments, troubleshooting, and Snowflake administration. Triggers on mentions of snowddl, deploy, user creation, role grants, infrastructure changes, or admin operations.
Why this skill is useful
Provides specific commands and workflows for managing Snowflake infrastructure that the AI wouldn't reliably generate on its own.
What it needs
Requires uv installed locally. Requires snowflake account access. About 5k tokens when loaded. Last updated 2026-08-07. 405 stars on the source repository.
What this skill does
SnowTower Administrator Guide A comprehensive skill for administrators managing Snowflake infrastructure through SnowTower. Who This Skill Is For Infrastructure administrators managing SnowDDL deployments Security admins handling user provisioning and roles DevOps engineers managing CI/CD pipelines On-call engineers troubleshooting production issues --- Quick Command Reference --- Core Operations SnowDDL Deployment Workflow CRITICAL: Always use deploy-safe, never raw snowddl-apply Why deploy-safe? SnowDDL excludes SCHEMA objects from management, which can cause it to revoke schema-level grants. The deploy-safe wrapper automatically restores these grants after every deployment, preventing dbt and other tools from losing permissions. Understanding Plan Output Red flags to watch for: Unexpected DROP statements Mass REVOKE statements (might be schema drift) Changes to admin roles (ACCOUNTADMIN, SECURITYADMIN) --- User Management Creating a New User Option 1: Interactive wizard (recommended) Option 2: Edit YAML directly Option 3: Non-interactive User Types Type Use For MFA Required Network Policy ------ --------- -------------- ---------------- PERSON Human users Yes (by 2026) Applied SERVICE Service accounts No Not applied Encrypting Passwords RSA Key Setup for Users --- Role Hierarchy SnowDDL Role Naming Convention Role Assignment Flow Creating Roles Business Role (snowddl/businessrole.yaml): Technical Role (snowddl/techrole.yaml): --- Database & Schema Management Creating a Database Creating a Schema Schema Types Parameter Effect ----------- -------- istransient: true No Time Travel, no Fail-safe issandbox: true Creates as TRANSIENT schema --- CI/CD Operations GitHub Actions Workflows Workflow Trigger Purpose ---------- --------- --------- ci.yml PRs, pushes Lint + test validation release.yml Tags v Create GitHub release labeler.yml PRs Auto-label by file type changelog.yml Push to main Update changelog Making Infrastructure Changes via PR Release Process --- Troubles …
How to use it
Reference it in AdaL, Claude Code, Cursor or any coding agent — nothing to install:
@skills aiskillstore/snowtower-admin