Snowflake Expert
This gives Claude comprehensive Snowflake expertise, from virtual warehouse tuning and resource monitors to streams, tasks, and continuous loading with Snowpipe. It covers the stuff you actually deal with in production: clustering strategies, external stages across S3 and Azure, change data capture patterns, and query optimization. The examples are practical, like setting up auto-suspend warehouses to control costs or using streams with tasks for incremental processing. Use it when you're building or maintaining a Snowflake data platform and need help with architecture decisions, SQL optimization, or debugging issues with materialized views and external tables. It knows the Snowflake-specific quirks like time travel and zero-copy cloning that make it different from other warehouses.
- skills.sh installs
- 236
- GitHub stars
- 44
- last updated
- Aug 21, 2026
Install
$ npx -y skills add personamanagmentlayer/pcl --skill snowflake-expert --agent claude-codeInstalls into .claude/skills of the current project.
Files
Snowflake Expert
You are an expert in Snowflake with deep knowledge of virtual warehouses, data sharing, streams, tasks, time travel, zero-copy cloning, and SQL optimization. You design and manage enterprise-scale data warehouses that are performant, cost-effective, and secure.
Best Practices
1. Warehouse Sizing and Management
- Start with smaller warehouses and scale up as needed
- Use multi-cluster warehouses for concurrency
- Set AUTO_SUSPEND to 5-10 minutes to avoid cold starts
- Monitor credit usage with resource monitors
- Use separate warehouses for different workloads (ETL, BI, ad-hoc)
2. Data Organization
- Use databases for major boundaries (prod/dev/test)
- Use schemas for logical grouping
- Implement clustering for large tables (>1TB)
- Use transient tables for temporary data to reduce storage costs
- Leverage zero-copy cloning for development/testing
3. Cost Optimization
- Use table types appropriately (permanent, transient, temporary)
- Set data retention periods based on needs
- Monitor and drop unused objects
- Use result caching for repeated queries
- Implement query timeouts to prevent runaway queries
4. Performance Optimization
Sponsors
Agent CaffeineSponsoredClose your lid, come back to finished work
SnugSponsoredThe clipboard manager for the AI eraPromote your product hereReach 125k+ visitors monthly
WaxSponsoredBlock anything with supervision, without erasing your iPhonePromote your product hereReach 125k+ visitors monthly
knobsSponsoredSee your site on any phone, any day, in any languageDetails
- Repository
- github.com/personamanagmentlayer/pcl
- Category
- Databases
- First seen
- Jun 3, 2026
More from personamanagmentlayer/pcl
All 99- Biological Expert233
- Security Expert228
- Aws Expert226
- Aerospace Expert225
- Scala Expert224
- Standards Expert224
- Flask Expert223
- Csharp Expert219
- Maritime Expert219
- Kafka Expert218
- Fastapi Expert216
- Nodejs Expert214
- Databricks Expert212
- Kubernetes Expert212
- Spring Boot Expert209
- Devops Expert207
- Elasticsearch Expert203
- Testing Expert203
- Kotlin Expert201
- Sre Expert201
- React Expert197
- Performance Expert196
- Javascript Expert195
- Elixir Expert192
Recommended
More Databases
axiom-database-migrationcharleswiltgen/axiomUse when adding/modifying database columns, encountering "FOREIGN KEY constraint failed", "no such column", "cannot add NOT NULL column" errors, or creating sch173skills.sh installs
dynamodbitsmostafa/aws-agent-skillsAWS DynamoDB NoSQL database for scalable data storage. Use when designing table schemas, writing queries, configuring indexes, managing capacity, implementing s147skills.sh installs
database-designcloudai-x/claude-workflow-v2Designs database schemas, indexing strategies, query optimization, and migration patterns for SQL and NoSQL databases. Use when designing tables, optimizing que139skills.sh installs
sql-server-table-reconciliationgithub/awesome-copilotUse when: comparing SQL Server tables across instances, data migration validation, ETL verification, row mismatch detection, schema drift, reconciliation report104skills.sh installs
SQL Injection Testingdavila7/claude-code-templatesThis skill should be used when the user asks to "test for SQL injection vulnerabilities", "perform SQLi attacks", "bypass authentication using SQL injection", "0skills.sh installs
diagnose-clickhouse-errorsfrankchen021/datastoriaDiagnose ClickHouse runtime query failures when the user wants database-level cause and fix guidance from an error or numeric error code, not source-code root c0skills.sh installs