agent-skills

Guide to Snowflake Cortex AI functions — SQL-native LLM inference, text classification, extraction, sentiment analysis, embeddings, and document processing without infrastructure management

Best practices for Snowflake Dynamic Tables — declarative data pipelines with automatic incremental refresh, replacing complex Streams + Tasks patterns

MUST USE when reviewing Snowflake schemas, queries, warehouses, or data pipelines. Contains 25 rules that MUST be checked before providing recommendations. Always read relevant rule files and cite specific rules in responses. Triggers: snowflake, create table, warehouse, clustering key, query optimization, data loading, copy into, variant, semi-structured, cost optimization, snowflake security.

Guide to Snowflake Postgres — managed PostgreSQL with pg_lake (Iceberg tables on object storage), pg_incremental (automated archival), and zero-ETL bridge to Snowflake analytics

Best practices for building Snowpark Python applications — DataFrame API, UDFs, UDTFs, stored procedures, and deployment patterns

Containerize an application with a production-grade Dockerfile, Docker Compose for local development, and optional Dev Container configuration. Use for: Dockerizing apps, multi-stage builds, Compose local dev stacks, .dockerignore, image size optimization, dev containers. Triggers: docker, dockerfile, compose, container, containerize, dockerize, docker-compose, devcontainer, dev container, docker setup, docker image, docker build.

Scaffold a Drizzle ORM project with TypeScript schema, relations, database client, and migrations. Use for: setting up Drizzle from scratch, designing table schemas, configuring drizzle-kit, writing type-safe queries, multi-database support (PostgreSQL, MySQL, SQLite). Triggers: drizzle, drizzle orm, drizzle setup, drizzle schema, drizzle migration, drizzle-kit, typescript orm, sql-like orm, drizzle config, drizzle relations, drizzle project.

Scaffold a Supabase project with database schema, Row Level Security policies, and auth integration. Use for: setting up RLS policies, debugging 'RLS not working', multi-tenant access control, auth.uid() patterns, team/org membership, profile triggers. Triggers: supabase, supabase rls, row level security, supabase auth, rls policy, supabase setup, supabase permissions, multi-tenant supabase, supabase project, rls not working.

Stream data into Snowflake using the Java Snowpipe Streaming SDK. Use for: setting up RSA auth, building the JAR, running single or parallel streaming, JVM Arrow flags, troubleshooting. Triggers: java streaming, snowpipe java, stream data java, parallel streaming java, streaming SDK java, maven streaming, stream orders java.

Stream data into Snowflake using the Python Snowpipe Streaming SDK. Use for: setting up RSA auth, configuring profiles, running single or parallel streaming, staging vs production, reconciliation, troubleshooting JWT errors. Triggers: python streaming, snowpipe python, stream data python, parallel streaming python, streaming SDK python, stream orders python.

Validates, deploys, and operationalizes SnowConvert AI (SCAI) Replatform output — SSIS to dbt and Snowflake TASKs migrations. Use when user has SnowConvert Replatform output, converted SSIS packages, deploy dbt projects, deploy orchestration, validate replatform, deploy converted ETL, replatform deploy, SSIS to dbt deploy, SCAI replatform, SSIS migration, convert SSIS, migrate ETL, SnowConvert output, replatform output, dtsx migration, ETL to Snowflake.