snowflake-labs
- 305 skills
- 0 followers
- 54 repo stars
- 2 days ago last updated
- ▌ Dynamic Tables Tutorial · snowflake-labs bundleInteractive tutorial that teaches Snowflake Dynamic Tables hands-on. The agent guides users step-by-step through building data pipelines with automatic refresh, incremental processing, and CDC patterns. Use when the user wants to learn dynamic tables, build a DT pipeline, or understand DT vs streams/tasks/materialized views.
- ▌ Cortex Classify Notebook · snowflake-labs bundleDeploy the Cortex CLASSIFY_TEXT tutorial notebook to the user's Snowflake account and provide a link to open it in Snowsight. Use when user wants to learn text classification through a Jupyter notebook experience.
- ▌ Cortex Classify Tutorial · snowflake-labs bundleInteractive tutorial teaching Snowflake Cortex CLASSIFY_TEXT for categorizing unstructured text. Guide users through classifying customer reviews using Python and SQL. Use when user wants to learn text classification, Cortex LLM functions, or analyze unstructured feedback data.
- ▌ Cortex Agents With Custom Tools Tutorial · snowflake-labs bundleAdvanced tutorial teaching Snowflake Cortex Agents with custom tools. Extends the base tutorial by adding stored procedure-based tools (inventory lookup, price calculator, product summary) alongside Cortex Analyst and Cortex Search. Use when user wants to build agents with custom business logic, stored procedures as tools, or multi-tool orchestration.
- ▌ Aviation Cleanup · snowflake-labs bundleDiscover and remove all Snowflake objects created by the aviation-ops-intelligence skills. Uses the COMMENT tracking tag (sf_sit-is-aviation) to find objects, generates DROP statements in dependency-safe order, and optionally executes them. Use when: cleaning up after a demo, removing airport analytics objects, tearing down an environment, removing a specific airport. Do NOT use for: dropping objects not created by these skills, production cleanup without review, provisioning or deploying airports. Triggers: aviation-cleanup, cleanup airport, teardown aviation, remove airport analytics, remove airport objects, drop aviation objects, reset aviation environment.
- ▌ Aviation Dashboard · snowflake-labs bundleDeploy the Airport Analytics dashboards: Streamlit-in-Snowflake plus the React dashboard via SPCS (Docker build + CREATE SERVICE). Create the Streamlit app, build/push the Docker image, create the SPCS service, and verify the URLs. Use when: deploying dashboard, setting up airport analytics UI, installing flight tracker, monitoring page, SPCS dashboard, React dashboard. Do NOT use for: installing airport data pipeline (use aviation-installer), cleaning up objects (use aviation-cleanup). Triggers: deploy dashboard, aviation dashboard, airport analytics UI, streamlit airport, install dashboard, flight tracker app, react dashboard, SPCS dashboard.
- ▌ Aviation Installer · snowflake-labs bundleInstall and configure an airport analytics platform in Snowflake. Routes to sub-skills for base infrastructure setup, ADS-B real-time ingestion, flight schedule ingestion, TSA checkpoint throughput ingestion, and derived analytics pipelines. Use when: installing airport analytics, setting up a new airport, deploying aviation platform, provisioning airport database. Do NOT use for: deploying the Streamlit dashboard (use aviation-dashboard), cleaning up objects (use aviation-cleanup), viewing flight data. Triggers: install airport, setup airport, deploy aviation, provision airport, aviation installer, new airport setup, airport analytics platform.
- ▌ Base Setup · snowflake-labs bundleCreate airport database infrastructure, schemas, cost-attribution tags, airport properties from Overture Maps, gate and runway geometry, and airline reference dimension. Subskill of aviation-installer — must be invoked from the router, not independently. Use when: setting up base airport infrastructure as part of installation workflow. Do NOT use for: standalone execution, ADS-B ingestion (use adsb-ingestion), derived analytics (use derived-analytics). Triggers: base setup, airport infrastructure, airport properties, setup airport database.
- ▌ Adsb Ingestion · snowflake-labs bundleSet up real-time ADS-B aircraft position ingestion from adsb.lol: create tables, network rules, external access integrations, Python ingestion procedures, flight-matching enrichment, scheduled tasks, and optional historical backfill. Subskill of aviation-installer — must be invoked from the router, not independently. Use when: configuring ADS-B data pipeline as part of installation. Do NOT use for: standalone execution, flight schedules (use flight-schedules), derived analytics (use derived-analytics). Triggers: ADS-B ingestion, aircraft tracking setup, adsb.lol, realtime aircraft data.
- ▌ Tsa Throughput · snowflake-labs bundleSet up TSA checkpoint throughput ingestion: create PDF stages, throughput table, network rule, external access integration, Python PDF-fetch and AI_EXTRACT procedures, and weekly scheduled tasks. Optional subskill of aviation-installer. Use when: configuring TSA throughput data as part of installation. Do NOT use for: standalone execution, ADS-B ingestion (use adsb-ingestion), flight schedules (use flight-schedules). Triggers: TSA throughput, passenger throughput, checkpoint data, TSA pipeline.
- ▌ Flight Schedules · snowflake-labs bundleSet up Aviationstack flight schedule ingestion: create schedule tables, network rule, external access integration with API key secret, Python ingestion procedure, ETL procedure, and scheduled task. Conditional subskill of aviation-installer — only runs when user provides an Aviationstack API key. Use when: configuring flight schedule data as part of installation with API key. Do NOT use for: standalone execution, ADS-B ingestion (use adsb-ingestion), derived analytics (use derived-analytics). Triggers: flight schedules, Aviationstack setup, schedule ingestion, flight timetable.
- ▌ Derived Analytics · snowflake-labs bundleCreate the airport analytics Dynamic Table pipeline: gate analysis (6 DTs), traffic facts (4 DTs), runway crossings, flight tracker, monitoring views, operational KPIs, and the full task DAG. Subskill of aviation-installer — must be invoked from the router after ADS-B ingestion completes. Use when: deploying derived analytics layer as part of installation. Do NOT use for: standalone execution, base setup, ADS-B ingestion. Triggers: derived analytics, deploy derived analytics, dynamic tables, setup dynamic tables, gate analysis, runway crossings, runway crossings detection, traffic analysis, airport analytics pipeline, DT pipeline.
- ▌ Cortex AI Function Studio · snowflake-labs bundleCreate, evaluate, and optimize custom AI functions using Snowflake Cortex AI Complete. Supports text, image, and document inputs. Use when: building LLM-powered functions, evaluating AI function performance, tuning prompts, selecting models, checking async job status. Triggers: ai function builder, custom ai function, user defined ai function, build my own llm function, evaluate ai function, tune ai function, optimize ai function, demo ai function, resume ai function job, image classification, document analysis, multimodal ai function.
- ▌ Demos · snowflake-labsInteractive demos for custom AI functions. Use when: demo, example, walkthrough, show me, how does this work, try it, hands-on, tutorial.
- ▌ Create AI Function · snowflake-labsCreate a new custom AI function. Supports table-based or manual input specification, single or variant outputs. Direct AI_COMPLETE calls or additional pre- and post-processing.
- ▌ Evaluate AI Function · snowflake-labsEvaluate an AI function's performance against a labeled dataset using a Python stored procedure.
- ▌ Optimize AI Function · snowflake-labsOptimize an AI function through automated function body optimization, including prompts, model references, and SQL pre/post-processing.
- ▌ Synthetic Data · snowflake-labsGenerate synthetic data or pseudo-label input-only tables for AI function evaluation and optimization. Triggers: generate data, synthetic data, test data, create test cases, make training data, pseudo label, label my input-only table.
- ▌ Redaction Demo · snowflake-labsInteractive demo [Experimental]: Build a PII redaction function using Agent Research mode — the agent searches the web for techniques, proposes SQL UDF architectures with pre/post-processing, and you pick the approach. Then optimize the full function body.
- ▌ Classification Demo · snowflake-labsQuick Start demo: Build a toxicity classifier and evaluate it — the fastest way to experience the core create → evaluate workflow.
- ▌ Legal Doc Extraction Demo · snowflake-labs bundleInteractive demo: Build a legal contract field extractor and create a weighted composite metric that scores 4 fields independently. Showcases custom evaluation metrics for multi-field AI functions.
- ▌ PDF Field Extraction Demo · snowflake-labs bundleInteractive demo: Extract structured fields from SEC 10-K filing PDFs using multimodal AI, create a custom composite metric for per-field scoring, and evaluate extraction accuracy with per-field analysis.
- ▌ Clothing Classification Demo · snowflake-labsInteractive demo: Build a multimodal clothing condition classifier using expert-labeled garment images, then evaluate and optimize across models via GEPA optimization.
- ▌ Insurance Claim Routing Demo · snowflake-labs bundleInteractive demo: Generate pseudo-labels from a strong teacher model, build a cheap student function, and evaluate accuracy. Showcases pseudo-labeling and teacher-student distillation.
- ▌ Policy Conditioned Routing Demo · snowflake-labs bundleInteractive demo: Build a policy-conditioned ticket router where a seed prompt performs poorly, then watch prompt optimization close the accuracy gap through prompt evolution and Pareto cost/quality analysis. The canonical demo for prompt optimization.
- ▌ Routing Agent · snowflake-labs bundleDeploy the routing TOOL_* procedures (AI-geocoded directions, isochrones, POI-in-isochrone, optimization, catchment, delivery/network demos) into FLEET_INTELLIGENCE.ROUTING_TOOLS. These are wrapped by the synapse ROUTING_MCP verbs that the app-level FLEET_AGENT attaches - there is no separate standalone routing agent. Use when: setting up the ORS routing tool substrate the fleet app depends on, integrating directions/isochrones/optimization with Cortex. Do NOT use for: deploying fleet intelligence demos, route deviation analysis, or changing ORS configuration. Triggers: openrouteservice demo, routing tools, ORS tool procedures, routing substrate.
- ▌ Dwell Analysis · snowflake-labs bundleDeploy the Dwell & Congestion Analysis demo: create a 12-step Dynamic Table pipeline for state detection, dwell sessionization, H3 congestion heatmaps, SLA alerts, facility utilization, and daily trends. Works with any vehicle type from SYNTHETIC_DATASETS.UNIFIED, configured via CONFIG table. Use when: setting up dwell analysis demo, congestion analytics, SLA breach monitoring, facility utilization tracking. Do NOT use for: route deviation analysis (use route-deviation), e-bike fleet (use fleet-intelligence-ebike), car fleet (use fleet-intelligence-car). Triggers: deploy dwell analysis, dwell analytics, congestion analysis, SLA alerts, facility utilization, dwell demo, H3 heatmap.
- ▌ Route Deviation · snowflake-labs bundleDeploy the Route Deviation Analysis demo: create projection views from SYNTHETIC_DATASETS.UNIFIED, run 3-step ETL pipeline, and register React dashboard pages. Works with any vehicle type configured via CONFIG table. Use when: setting up route deviation demo, detour analytics, fleet deviation analysis. Do NOT use for: general fleet tracking, real-time GPS monitoring, or non-deviation routing tasks. Triggers: deploy route deviation, deploy detour analytics, setup deviation analysis, route deviation demo.
- ▌ Skill Optimiser · snowflake-labs bundleOptimize, audit, create, and improve Cortex Code skills following official best practices from the Anthropic skill-building guide. Use when: creating a new skill, reviewing an existing skill, optimizing skill description or triggers, improving SKILL.md structure, auditing skill quality, fixing undertriggering or overtriggering, restructuring skill for progressive disclosure. Do NOT use for: general code review, non-skill markdown editing, MCP server development. Triggers: optimize skill, audit skill, review skill, create skill, improve skill, fix skill triggers, skill best practices, skill quality check.
- ▌ Freight Exchange · snowflake-labs bundleDeploy the Freight Exchange page: a dispatcher-grade marketplace cockpit that mirrors what users do today on Timocom, WTransnet, Teleroute, B2P (NA: DAT, Truckstop, Convoy, Uber Freight). Adds a parallel React route to the ORS Control App that lets dispatchers browse, filter, and inspect synthesized freight offers per active preset, with trust scores (credit/KYC/blacklist), market-rate badges (vs. weekly p25/p50/p75 USD/km from a RATE_INDEX dynamic table), and partner lane history. Reads from FLEET_INTELLIGENCE.MARKETPLACE projection views over per-preset SYNTHETIC_DATASETS.UNIFIED data, so switching preset auto-refreshes the page. Use when: setting up the Freight Exchange demo, dispatcher cockpit, freight marketplace, load board, trust-score badges, market-rate badges, Timocom-style UI parity. Do NOT use for: solver-led fleet-wide backload (use backload-matching), route-optimization VRP, route-deviation, retail-catchment, fleet-intelligence car/e-bike demos. Triggers: freight exchange, freight marketplace, l
- ▌ Retail Catchment · snowflake-labs bundleDeploy the Retail Catchment Analysis demo with Overture Maps data. Use when: setting up retail catchment demo, deploying catchment analysis, creating retail location analysis app, retail isochrone analysis, competitor mapping demo. Do NOT use for: fleet intelligence demos (use fleet-intelligence-car or fleet-intelligence-ebike), route optimization (use route-optimization), route deviation analysis (use route-deviation), or dwell analysis (use dwell-analysis). Triggers: retail demo catchment, deploy retail catchment demo, retail isochrone analysis, competitor mapping demo, retail location analysis, trade area analysis.
- ▌ Backload Matching · snowflake-labs bundleDeploy the Backload Matching Engine demo: a fleet-wide VRP solve over idle-bound trailers + internal volumes + external freight-exchange offers, anchored on the OPENROUTESERVICE_APP.CORE.OPTIMIZATION function. The page picks one or many trailers, calls OPTIMIZATION once, and renders empty/loaded legs, KPI savings, and a Cortex rationale. Use when: setting up the DHL Freight backload demo, asset velocity / trailer rotation use cases, freight-exchange aggregation, internal-first vs external-second proposals, multi-trailer joint dispatch. Do NOT use for: route optimization VRP from PLACES (use route-optimization), route deviation analysis (use route-deviation), retail catchment (use retail-catchment), fleet intelligence car/e-bike demos, or single-leg directions tests (use FunctionTester). Triggers: backload, backload matching, empty mile, empty leg, asset velocity, trailer rotation, freight exchange, freight exchanges, idle trailer, idle-bound trailer, Timocom, WTransnet, Teleroute, B2P, DHL, DHL Freight, dispa
- ▌ Emergency Response · snowflake-labsRegion-generic Emergency Response evacuation-planning demo: a multi-step wizard in the FLEET_SA_APP that, for whatever region/dataset is active, colors the map by procedural hazard-zone risk (flood/wildfire), seeds participants inside the drive-time isochrone union of the region's health-anchor care centers, and solves a capacitated multi-depot evacuation VRP. Data is produced by Data Studio (generates_hazard + generates_anchors + generates_participants); the wizard binds to the FLEET_APP.EMERGENCY_RESPONSE contract + evac_seed/evac_solve verbs. Use when: setting up emergency response demo, evacuation planning, hazard risk, flood or wildfire exposure, paratransit evacuation routing, participant pickup optimization. Do NOT use for: standard fleet tracking (use fleet-intelligence-car), retail trade area analysis (use retail-catchment), route deviation analytics (use route-deviation), generic dispatch (use route-optimization). Triggers: emergency response, evacuation planning, hazard risk, wildfire risk, flood r
- ▌ Install Fleet Apps · snowflake-labs bundlePrimary one-command installer for the synapse-based, vehicle/industry-AGNOSTIC fleet analytics architecture on Snowflake: the FLEET_SA_APP consumer app, the FLEET_ADMIN_APP build console, the three role-scoped synapse MCP tool bundles, the neutral FLEET_APP data contract, roles, Cortex agents, and (by default) the live ORS/VROOM routing engine. Use when: install the fleet apps, deploy FLEET_SA_APP and FLEET_ADMIN_APP, set up the agnostic fleet analytics solution, install the synapse fleet stack, provision the routing engine. Self-owning and idempotent: detects-and-reuses-else-creates SPCS infra, seed data, and the ORS engine; pass --no-engine to skip the heavy engine build. Do NOT use for: changing routing maps/profiles (use routing-customization) or the legacy per-vehicle demo skills (fleet-intelligence-car, route-deviation, etc.). Triggers: install fleet apps, install-fleet-apps, deploy fleet sa app, deploy fleet admin app, install synapse fleet stack, set up agnostic fleet solution, provision routing engin
- ▌ Route Optimization · snowflake-labs bundleDeploy the Route Optimization demo including Marketplace data and notebook. Use when: setting up the route optimization demo after ORS app deployment. Do NOT use for: fleet intelligence demos (use fleet-intelligence-car), route deviation analysis (use route-deviation), or retail catchment analysis. Triggers: deploy route optimization demo, setup route optimization demo, run route optimization demo.
- ▌ Sap Fleet Connector · snowflake-labs bundleBind landed SAP (EAM/SD/TM) plus fleet telematics into the existing FLEET_APP neutral contract and SV_FLEET_OPS semantic view, so the fleet dashboards, Cortex agent, and Cortex Analyst run on a customer's real SAP data with no edits above the contract. The connector maps SAP equipment/delivery/maintenance + telematics to the neutral entities via a mandatory configurable ASSET_CROSSWALK, dedupes CDC-landed SAP tables to current rows, and repoints the UNIFIED_FLEET source seam. Use when: onboarding an SAP fleet customer, swapping synthetic demo data for SAP+telematics, joining EQUI/IFLOT/IMRG/AUFK/QMEL/LIKP to GPS telemetry, building an SAP fleet POC. Do NOT use for: ingesting SAP into Snowflake (that is Fivetran/SLT/Datasphere); generating synthetic data (use install-fleet-apps + Data Studio); non-SAP fleet demos (use fleet-intelligence-car/ebike). Triggers: SAP connector, SAP fleet, EQUI telematics join, asset crosswalk, bind SAP to FLEET_APP, SAP semantic layer, SAP EAM analytics.
- ▌ Location Diagnostics · snowflake-labs bundleDeploy the Location Diagnostics demo: region-agnostic retail site cannibalisation and closure modelling built from existing Overture data (a POI subset becomes the store estate) plus the live ORS drive-time engine. Adds the FLEET_INTELLIGENCE.LOCATION layer, FLEET_APP.LOCATION contract views, SV_LOCATION, and the Site Impact + Closure Impact app views. Use when: setting up store cannibalisation / transfer modelling, closure impact, next-closest-store analysis, retail location diagnostics. Do NOT use for: fleet tracking (fleet-intelligence-car/ebike), route optimization VRP (route-optimization), single-store catchment visualization (retail-catchment). Triggers: location diagnostics, cannibalisation modelling, transfer modelling, store closure impact, next closest store, retail site impact, catchment overlap.
- ▌ Routing Customization · snowflake-labs bundleRoute customization requests to the correct subskills. Use when: changing location, changing map, changing vehicle, changing routing profile. Do NOT use for: initial ORS deployment (use install-fleet-apps), deploying demo apps, or reading ORS config only (use read-ors-configuration subskill directly). Triggers: change location, change map, change vehicle, change routing profile, change routing profiles.
- ▌ Routing Prerequisites · snowflake-labsCheck and install build prerequisites for the Routing Solution project. Use when: verifying environment setup before building, checking if Docker/Podman/snow CLI are installed, confirming readiness to build. Do NOT use for: building the routing solution itself (use install-fleet-apps), deploying demos, or changing ORS configuration. Triggers: check prerequisites, check build prerequisites, am I ready to build, what do I need installed, verify environment setup, Docker installed, Podman installed, snow CLI installed.
- ▌ Fleet Intelligence Car · snowflake-labs bundleGenerate realistic vehicle/driver location data for the Fleet Intelligence solution using Overture Maps data and OpenRouteService for actual road routes. Also supports Data Studio projection views from SYNTHETIC_DATASETS.UNIFIED for any vehicle type via CONFIG table. Configurable location (New York, London, San Francisco, etc.), number of drivers (default 80), days of simulation (default 1), and shift patterns. Use when: setting up driver location data, generating route-based simulation, deploying the fleet dashboard. Do NOT use for: e-bike fleet simulation (use fleet-intelligence-ebike), route deviation analysis (use route-deviation), or route optimization demos. Triggers: generate driver locations, create driver data, setup fleet data, fleet intelligence dashboard, car fleet simulation.
- ▌ Setup Agent Playground · snowflake-labs bundleDeploy industry-agnostic SF demo data tables required by the Agent Playground's catchment/delivery/network scenarios (TOOL_NETWORK_OPTIMIZATION, TOOL_DELIVERY_OPTIMIZATION, TOOL_CATCHMENT). Run AFTER $install-fleet-apps and $routing-agent. Creates DEMO_DELIVERY_STOPS (30), DEMO_AREA_DEMOGRAPHICS (55), DEMO_DEMAND_CATALOG (25), DEMO_KEY_SITES (6), DEMO_DEPOT (1), the FOOD_DELIVERY DELIVERIES view, updates the 6 fleet CONFIG tables to SanFrancisco/ebike defaults, and uploads agent-demos.json to the ORS stage. Triggers: setup agent playground, install agent demo data, deploy demo data, missing demo data, agent playground scenarios missing, agent-demos.json missing, catchment demo, delivery optimization demo, network optimization demo, DEMO_DELIVERY_STOPS, DEMO_AREA_DEMOGRAPHICS, DEMO_DEMAND_CATALOG, DEMO_KEY_SITES.
- ▌ Fleet Intelligence Ebike · snowflake-labs bundleE-bike fleet intelligence using synthetic datasets generated by Data Studio in ORS Control Panel. Reads from SYNTHETIC_DATASETS.UNIFIED via projection views (TRIPS, ORIGINS_ENRICHED) filtered by CONFIG table. Use when: setting up e-bike fleet data, e-bike fleet intelligence. Do NOT use for: car fleet simulation (use fleet-intelligence-car), route deviation analysis, or route optimization demos. Triggers: setup e-bike fleet, e-bike fleet intelligence, generate e-bike locations.
- ▌ Routing Solution Cleanup · snowflake-labs bundleDiscover and remove all Snowflake objects created by skills in this repo. Uses the COMMENT tracking tag (sf_sit-is-fleet) to find objects, generates DROP statements, and optionally executes them. Use when: cleaning up after a demo, removing all skill-created objects, tearing down an environment, uninstalling a specific skill's objects. Do NOT use for: dropping objects not created by these skills, production environment cleanup without review. Triggers: routing-solution-cleanup, cleanup, teardown, remove, uninstall, drop all, clean up demo, remove skill objects, reset environment.
- ▌ Location · snowflake-labsChange the OpenRouteService map region by downloading new OSM data and updating service configuration. Subskill of routing-customization - must be invoked from the router, not independently. Use when: changing ORS map region as part of customization workflow. Do NOT use for: standalone execution, reading current config, or changing routing profiles. Triggers: change location, change map, download map, new region.
- ▌ Routing Profiles · snowflake-labsEnable or disable ORS routing profiles (driving-car, driving-hgv, cycling, walking, wheelchair). Subskill of routing-customization - must be invoked from the router, not independently. Use when: changing vehicle types as part of customization workflow. Do NOT use for: standalone execution, changing map region, or deploying demo apps. Triggers: change routing profile, change vehicle type, enable profile, disable profile.
- ▌ Read Ors Configuration · snowflake-labsSubskill of routing-customization. Read current OpenRouteService configuration (region and routing profiles) and display to the user. Use when: checking current ORS settings, verifying map region, listing enabled vehicle profiles. Do NOT use for: changing configuration (use routing-customization), deploying demos, or building ORS from scratch. Triggers: ors configuration, openrouteservice config, routing simulator configuration, current map, current location, current vehicle types, current routing profiles.
- ▌ Regulatory Lookup · snowflake-labsRoutes regulatory framework queries to the correct search filters and provides structured regulatory analysis. Use when the user asks about SFDR, EU Taxonomy, MiFID II, FCA SDR, FCA Consumer Duty, AIFMD, UCITS, SEC rules, or IFRS standards. Supports cross-jurisdiction comparison.
- ▌ Executive Briefing · snowflake-labs bundleUse this skill when the user asks for a "board briefing", "executive briefing", "firm overview", or mentions preparing for a board meeting or stakeholder presentation. Also use for "comprehensive performance summary" or "how is the firm performing" questions that require multi-tool orchestration across KPIs, flows, and strategy performance.
- ▌ Brinson Attribution · snowflake-labsLegacy skill — superseded by multi-level-attribution. This skill redirects to multi-level-attribution which provides full sector/country/industry drill-down, linked period attribution (QTD/YTD/12M), factor cross-reference, and interactive stopping points.
- ▌ Covenant Monitoring · snowflake-labsUse this skill when the user asks about covenant compliance, covenant breaches, covenant headroom, watchlist borrowers, equity cures, waiver requests, or credit committee recommendations on covenant issues. Also use for "any covenants at risk", "which borrowers are in breach", "covenant deep-dive on [borrower]", or "credit committee summary".
- ▌ Historical Backtest · snowflake-labsUse this skill when the user asks to "backtest" a portfolio, test historical performance of a portfolio allocation, or run a "historical simulation". Also use when comparing two portfolio candidates over a historical period, or when the user provides weights like "60/40 AAPL/MSFT" and wants to see how it would have performed.
- ▌ Portfolio Optimizer · snowflake-labs bundleUse this skill when the user wants to optimize portfolio weights, find the efficient frontier, construct a maximum Sharpe or minimum variance portfolio, or rebalance with specific constraints like position caps, sector limits, or ESG minimums. Also use when the user says "what's the optimal allocation" or "rebalance for minimum risk".
- ▌ Earnings Intelligence · snowflake-labsUse this skill when the user asks about earnings analysis, quarterly results, management commentary, earnings call insights, guidance changes, sentiment analysis of earnings, or investment committee earnings summaries. Also use for "what did management say", "earnings surprises", "guidance raised/lowered", "tone of the call", or "red flags in earnings".
- ▌ Factor Model Explorer · snowflake-labs bundleUse this skill when the user asks which factors are driving returns, wants to compare factor performance across periods, or requests ad-hoc factor exploration like "which factors are working this quarter", "compare momentum vs value", or "factor correlations". Also use when the user needs analysis beyond what pre-computed factor views provide.
- ▌ PDF Report Generation · snowflake-labsUse this skill when the user explicitly requests a PDF document, file export, or downloadable report. Trigger on phrases like "generate PDF", "create PDF", "export as PDF", or "save as document". Do NOT trigger for general requests like "report", "summary", or "document" alone — those should produce markdown text output.
- ▌ Competitor Ma Analysis · snowflake-labsUse this skill when the user asks about competitor acquisition opportunities, divisional sales, or strategic M&A. Also use for "model acquiring [target]", "EPS accretion analysis", or any question about evaluating an M&A target that requires combining news, geographic segment data, and financial simulation.
- ▌ Credit Risk Calculator · snowflake-labs bundleUse this skill when the user asks about a borrower's default probability, credit risk drivers, PD scores, risk ratings, or wants to run what-if scenarios on credit metrics like "what if revenue drops 20%" or "recalculate PD with adjusted inputs". Also use when explaining why a borrower received a particular risk rating, SHAP analysis, or comparing risk across borrowers.
- ▌ Equity Research Report · snowflake-labs bundleGenerates institutional-format equity research reports with 10 sections including recommendation, scenario analysis (Bull/Base/Bear), and monitoring plan. Use when the user asks for an "equity research report", "research report with scenarios", "full research report", or comprehensive company analysis with price target.
- ▌ Esg Mandate Compliance · snowflake-labsUse this skill when the user asks about ESG mandate compliance, ESG grade breaches, SFDR Article 8/9 requirements, or ESG portfolio screening. Detects breaches, checks engagement history, and generates remediation plans.
- ▌ Monte Carlo Simulation · snowflake-labsUse this skill when the user asks for a "Monte Carlo" simulation, wants to know the probability of reaching a financial target, or needs forward-looking risk analysis. Also use for retirement planning questions, DCA analysis, or any query about probabilistic portfolio outcomes like "what are the odds of reaching $2M" or "how risky is this allocation".
- ▌ Portfolio Construction · snowflake-labsUse this skill when the user asks to "build a portfolio", "construct an allocation", "create a proposal", or requests a portfolio with specific constraints (max volatility, minimum fixed income, target return, goal probability). Also use for "conservative portfolio", "aggressive growth portfolio", "balanced allocation", "60/40 split", or any request that requires selecting securities and assigning weights from scratch.
- ▌ Counterfactual Analysis · snowflake-labsUse this skill when the user asks "what if", "what would have happened if", "counterfactual", "had we held benchmark weights", "exclude a sector", "cap weight at", or "compare sector vs country classification". Maps natural language what-if questions to the RUN_COUNTERFACTUAL_ANALYSIS procedure.
- ▌ Credit Portfolio Review · snowflake-labsUse this skill when the user asks for a portfolio overview, credit quality summary, portfolio health check, concentration analysis, vintage analysis, rating migration, watchlist review, or quarterly portfolio report. Also use for "how is the portfolio", "portfolio health", "credit quality trends", "concentration risk", or "quarterly review".
- ▌ Deal Pipeline Screening · snowflake-labsUse this skill when the user asks about new deal screening, pipeline opportunities, deal flow, new investment candidates, term sheet analysis, comparable deals, or preliminary credit assessment for incoming opportunities. Also use for "what's in the pipeline", "screen this deal", "comparable transactions", or "should we bid on this".
- ▌ Implementation Planning · snowflake-labsUse this skill when the user explicitly requests an "implementation plan", "execution plan", "trading plan", or asks for specific costs and timelines for portfolio changes. Creates detailed trade plans with dollar amounts, trading costs, execution strategies, and settlement timelines.
- ▌ Multi Level Attribution · snowflake-labsUse this skill when the user asks about performance attribution, what drove returns, allocation vs selection effects, or Brinson analysis. Also use for "why did we outperform/underperform", "break down excess return", or requests for attribution by country, sector, or industry. This provides full multi-level drill-down with stopping points for interactive exploration.
- ▌ Quarterly Client Letter · snowflake-labs bundleUse this skill when the user asks to "prepare a quarterly client letter", "draft a client update", or create a "quarterly performance summary" for a specific portfolio. Also use when the user mentions preparing client communications that combine performance data with holdings and sector allocation.
- ▌ Attribution Anomaly Scan · snowflake-labsUse this skill when the user asks about anomalies, risk flags, style drift, attribution drift, concentration alerts, or anything unusual in attribution patterns. Also use proactively when generating reports to check for HIGH severity items before presenting findings.
- ▌ Competitive Intelligence · snowflake-labsUse this skill when the user asks to compare companies, analyse competitive positioning, peer analysis, market share, competitive landscape, or competitive moat. Also use for "compare X to Y", "who are the competitors", "peer group analysis", "industry positioning", or "competitive advantage".
- ▌ Data Lineage Explanation · snowflake-labsExplains where data comes from, how metrics are calculated, and traces data lineage through the pipeline. Use when the user asks "where does this data come from?", "how is X calculated?", or "what does this metric mean?".
- ▌ Rfp Response Preparation · snowflake-labs bundleUse this skill when the user asks to "prepare an RFP response", "draft an RFP", "respond to an RFP", or needs to compile firm capabilities, track record, investment process, and compliance content for a proposal. Also use when the user mentions "Request for Proposal", "mandate proposal", "tender response", or "client proposal".
- ▌ Stress Scenario Analysis · snowflake-labsUse this skill when the user asks for a "stress test", "scenario analysis", or wants to know how the portfolio would perform in a crisis. Also use for what-if questions like "what if rates rise 200bps", "impact of a COVID-like event", or "how bad could it get in a recession". Covers both historical scenario replay and custom shock construction.
- ▌ Client Review Preparation · snowflake-labsUse this skill when the user asks to "prepare for a client meeting", needs "meeting prep", or wants a "client review" briefing. Also use when the user mentions a client by name and wants talking points, relationship context, or portfolio performance summary for that client.
- ▌ Portfolio Name Resolution · snowflake-labsUse this skill to resolve portfolio short names and aliases to their full SAM portfolio names. Activate whenever the user mentions a portfolio by informal name, abbreviation, or alias like "Tech", "ESG Leaders", "Flagship", or "60/40". All Cortex Analyst queries require the full "SAM" prefix, and this skill provides the mapping.
- ▌ Rate Sensitivity Analysis · snowflake-labsUse this skill when the user asks about interest rate exposure, floating rate risk, SOFR impact, rate sensitivity, rate shock scenarios, coverage ratio impact from rate changes, PIK triggers, or SOFR floor protection. Also use for "what happens if rates rise", "floating rate exposure", "rate impact on portfolio", or "which borrowers are most vulnerable to rate rises".
- ▌ Investment Memo Generation · snowflake-labs bundleGenerates structured investment memos with thesis framing, financial analysis, risk assessment, and catalyst identification. Use when the user asks for an "investment memo", "investment thesis", or "comprehensive company analysis". Requires multi-tool orchestration across SEC data, analyst estimates, and qualitative research.
- ▌ Audience Adaptive Narrative · snowflake-labsUse this skill to adapt response depth, formatting, and language to the target audience. Activate when the user specifies an audience like "board memo", "client letter", "PM deep-dive", or when generating reports for different stakeholders, even if they don't explicitly name an audience tier.
- ▌ Attribution Report Generator · snowflake-labsUse this skill when the user asks to "generate an attribution report", "prepare attribution for the board", "write up quarterly performance", or wants a comprehensive multi-section attribution narrative. Orchestrates multiple tools into a complete report with audience-appropriate depth.
- ▌ Concentration Risk Assessment · snowflake-labsUse this skill when the user asks about "concentration risk", "which positions need attention", or "position limit breaches". Retrieves thresholds from internal policy documents and applies them to portfolio positions.
- ▌ Event Driven Risk Verification · snowflake-labsUse this skill when the user provides an external event alert or asks about the impact of a specific event on portfolio holdings. Verifies events, calculates direct and indirect exposure through supply chains, and synthesises risk assessments.
- ▌ Insider Institutional Analysis · snowflake-labsUse this skill when the user asks about insider trading, institutional ownership, Form 4 filings, 13F holdings, smart money activity, insider buying/selling, top shareholders, or ownership changes. Also use for "who owns this stock", "insider activity", "institutional holders", "smart money", or "ownership concentration".
- ▌ Rbac · snowflake-labs bundleUse when designing or refactoring Snowflake RBAC: choosing a role hierarchy, creating database/schema access roles, setting up functional roles, deciding between primary and secondary roles, or referencing roles in masking and row access policies. Routes to focused sub-flows for each layer of the hierarchy. Triggers: rbac, role hierarchy, access roles, functional roles, schema access role, database access role, warehouse access role, secondary roles, policy roles, role design, grant, managed access schema, future grants
- ▌ Mlops · snowflake-labs bundleUse when a developer or data engineer wants to assess MLOps maturity, design a promotion strategy (Code/Model/Hybrid), or implement MLOps capabilities (CI/CD, monitoring, retraining, governance) on Snowflake for traditional ML or LLM/GenAI workloads. Triggers: mlops, mlops maturity, mlops assessment, mlops strategy, mlops pattern, mlops framework, model promotion, ml ci/cd, ml monitoring, llmops, rag pipeline ops, fine-tuning ops.
- ▌ Spec Driven · snowflake-labs bundleUse when implementing a feature, fixing a bug, refactoring code, creating a spec, writing a specification, planning implementation, or following a structured development workflow. Creates specifications BEFORE implementation using EARS notation, ensuring alignment, traceability, and regression prevention. Triggers: spec-driven, specification, SDLC, EARS, implement feature, fix bug, refactor, create spec, plan implementation, design first, spec workflow, structured development.
- ▌ Dcr V1 To V2 · snowflake-labs bundleUse when migrating a Snowflake Data Clean Room from V1 (SAMOOHA Provider/Consumer API) to V2 (Collaboration API). Discovers V1 setup via introspection queries, maps constructs to Collaboration API equivalents, converts JinjaSQL templates, and generates provider/consumer setup plus cleanup scripts. Output is local files only — no live DDL/DML. Triggers: DCR migration, V1 to V2, clean room upgrade, clean room migration, migrate DCR, upgrade clean room, SAMOOHA to Collaboration API.
- ▌ Xo · snowflake-labs bundle**[REQUIRED]** XO operator workflow system — the single entry point. Triage classifies the request, routes to the right stage reference, and composes multi-stage pathways. Recording (save) and Recall run underneath. Triggers: work item, WI, task, implement, investigate, plan, review, execute, what should I do, where do I start, savepoint, resume.
- ▌ Snowpipe Bcdr · snowflake-labs bundleUse when designing or operating Snowpipe disaster recovery on Azure ADLS Gen2 — choosing between dual-pipe, RA-GRS, active-active, or Failover Group patterns, and running failover/failback/catchup. Triggers: snowpipe BCDR, snowpipe disaster recovery, snowpipe failover, dual pipe, active-active pipe, RA-GRS snowpipe, GZRS snowpipe, snowpipe catchup, pipe failback, snowpipe high availability, failover group snowpipe, snowpipe RPO RTO.
- ▌ Snowpro Study · snowflake-labs bundleGenerate SnowPro certification study materials including study plans, domain deep-dives, flashcards, and practice exam questions for any SnowPro exam. Dynamically discovers current certifications and exam versions from Snowflake. Use when asked to study, prep for, or generate content for SnowPro certifications.
- ▌ Snowflake Docs · snowflake-labs bundleUse for **ALL** Snowflake documentation lookups: feature questions, SQL syntax, best practices, how-to guides, configuration, and troubleshooting. This is the required entry point for any question about Snowflake products or features. Triggers: Snowflake docs, how do I, SQL syntax, CREATE, ALTER, DROP, warehouse, stage, Cortex, Snowpipe, dynamic table, stored procedure, UDF, MCP, Snowpark, Streamlit, Native App, data sharing, replication, security, roles, grants, what is, how does, Snowflake feature.
- ▌ Swap Databases · snowflake-labs bundleSwap the names of two Snowflake databases safely with object sync and grant mirroring. Also handles read-only databases by redirecting dependent objects from one DB to another without renaming. Also handles zerocopy swap of an imported datashare database with a catalog-linked database (CLD). Use when: swapping databases, renaming databases bidirectionally, blue-green database cutover, migrating database names, database name swap, redirecting dependencies, read-only database migration, shared database replacement, migrate shared views, redirect abstracted views, sfshares migration, zerocopy swap, datashare to CLD, imported database swap CLD. Triggers: swap databases, rename database, swap DB names, database cutover, blue-green swap, exchange databases, redirect dependencies, read-only database, replace shared database, migrate references, migrate sfshares, abstracted views, migrate views, zerocopy, datashare, catalog linked database, CLD, SYSTEM$ZEROCOPY_SWAP.
- ▌ Spark Migration · snowflake-labs bundleMigrate Spark scripts and notebooks to Snowflake. Routes to one of two bundled conversion paths and orchestrates the post-conversion pipeline. **Default path: Snowpark Connect (SCOS)**, which preserves the PySpark API surface. The SMA / Snowpark API path is invoked only when the user explicitly asks for it. Also **deploys** the output as a **Notebook** (`deploy-notebook`) or **Code Bundle** (`deploy-code-bundle`). Triggers: convert spark, migrate pyspark, migrate spark, migrate to snowpark, convert to snowpark, snowpark connect, scos, scos migration, migrate to snowpark connect, migrate to scos, snowpark api, sma cli, sma conversion, run sma, snowflake.snowpark rewrite, already migrated, already ran sma, sma dashboard, fix ewis, stage conversion, dvp orchestrator, resume dvp, assess pyspark, assess spark, assess databricks, spark assessment, databricks assessment, spark workload assessment, migration readiness, migration readiness report, spark readiness, spark compatibility, spark compatibility report, pyspa
- ▌ Quickstart Guide · snowflake-labs bundleUse when a user pastes a Snowflake Quickstart URL or asks to learn/walk through a Quickstart. Fetches the source content from GitHub, parses it into stages, checks the learner's environment, and delivers a guided build experience with two modes (learner or builder). Triggers: quickstarts.snowflake.com, snowflake.com/en/developers/guides/, walk me through this quickstart, teach me this quickstart, learn this guide, I want to do this quickstart. Do NOT use for general SQL help or non-Quickstart tutorials.
- ▌ Check Agent Access · snowflake-labs bundleAudits all (or selected) Cortex Agents in a Snowflake account. For each agent the skill reads the live specification, extracts every dependency (semantic views, Cortex Search services, UDFs, warehouses, tables), then checks whether a user-supplied role holds the required privilege on each object — including inherited grants via role hierarchy. Results are presented as a gap table grouped by agent, followed by an optional one-click remediation script. Triggers: check agent access, audit agent privileges, who can use my agents, role access to agents, missing agent grants, grant agent usage, agent USAGE check, PUBLIC can't call agent, fix agent permissions, check role permissions for Cortex Agent. Do NOT use for: general RBAC design (use `rbac`), warehouse credit audits, or auditing non-agent Snowflake objects.
- ▌
- ▌
- ▌ Review Skill Sflabs · snowflake-labs bundleUse when a contributor has built a Cortex Code skill locally and wants a pre-PR readiness check before opening a pull request against Snowflake-Labs/cortex-code-skills. Verdict: promote, adapt, or skip — with concrete fixes. Triggers: "review a skill", "is this skill ready for labs", "check this skill before PR", "audit skill for promotion", "does this skill belong in labs".
- ▌ Solutions Installer · snowflake-labs bundleUse for ALL requests to install, set up, deploy, or tear down a pre-built Snowflake industry solution. This skill reads a solution's manifest.json for metadata, then executes its setup SQL scripts against the user's Snowflake account. Triggers: install solution, coco solutions install, set up solution, deploy solution, teardown solution, uninstall solution, sf-solutions, solution accelerator, demo environment. Do NOT use for: adding pages to the solutions catalog website (use snowflake-solutions-catalog instead), building custom solutions from scratch, or general SQL authoring.
- ▌
- ▌
- ▌