Skill UI

This guide provides comprehensive steps for deploying Shopify applications (including extensions and functions) to various production cloud hosting platforms, such as Vercel, Fly.io, and Google Cloud Run. It covers critical aspects like environment configuration, setting up necessary webhooks, utilizing the Shopify CLI for deployment, and best practices for securely handling platform-specific secrets and ensuring production stability. Use this when moving a local Shopify app to a live e-commerce environment.

This guide provides a minimal, working example of connecting to a Shopify store using the GraphQL Admin API. It demonstrates how to initialize the API client, authenticate the connection, and execute a query to retrieve product and variant details. Ideal for developers starting a new e-commerce integration, testing API connectivity, or learning basic Shopify data retrieval patterns.

This guide provides a comprehensive framework for load testing Shopify app integrations, specifically designed to respect strict API rate limits. It teaches users how to plan and benchmark system capacity for high-traffic events like Black Friday/Cyber Monday (BFCM) or flash sales using tools like k6. Users learn to optimize for burst events, analyze GraphQL cost, and configure infrastructure scaling for reliable e-commerce performance.

This guide provides a comprehensive and reproducible local development workflow for Shopify applications. It details how to use the Shopify CLI for scaffolding and hot reloading, integrate ngrok for stable webhook tunneling, and set up Vitest for robust API testing, enabling developers to achieve rapid and reliable iteration cycles.

This guide details how to use Shopify Metafields and Metaobjects via the GraphQL Admin API. Metafields allow attaching key-value custom data to existing resources (like products or orders), while Metaobjects enable defining entirely new, structured content types. Together, they provide a powerful way for developers to model complex custom data, often eliminating the need for external databases to extend e-commerce functionality.

A comprehensive skill for managing Shopify's unique rate limiting systems, covering both the REST API's leaky bucket mechanism and the GraphQL API's calculated query cost. It provides robust techniques for handling 429 errors, implementing exponential backoff, and optimizing queries to ensure stable, high-throughput e-commerce integrations.

This skill provides comprehensive guidance on implementing security best practices for Shopify applications. It covers critical topics such as secure API credential storage, verifying incoming webhooks using HMAC signatures, enforcing least-privilege access scopes, and setting Content Security Policies (CSP). Use this guide when building, auditing, or scaling a secure e-commerce integration.

This skill guides developers through advanced techniques to optimize Shopify store performance and improve Core Web Vitals (LCP, CLS, INP). It covers fixing lazy-loaded hero images, migrating to the modern `image_url` filter for responsive images, profiling slow Liquid renders, and optimizing font delivery, ensuring a fast and professional e-commerce experience.

This guide provides comprehensive steps for upgrading Shopify API versions (quarterly releases) and migrating your application from the legacy REST Admin API to the modern GraphQL Admin API. It details how to check supported versions, identify breaking changes (like ProductInput splits), and update configurations, ensuring your codebase remains current with Shopify's evolving API standards.

This comprehensive guide demonstrates how to establish a robust Continuous Integration/Continuous Deployment (CI/CD) pipeline for Snowflake data warehousing. It integrates SchemaChange for managing version-controlled database migrations, GitHub Actions for automated testing and deployment triggering, and Terraform for provisioning and managing underlying Snowflake infrastructure (databases, warehouses, roles). Use this when setting up reliable, repeatable, and automated deployment workflows.

This skill provides comprehensive SQL queries and procedures to analyze and optimize Snowflake usage costs. It covers budgeting via resource monitors, right-sizing compute warehouses, tuning auto-suspend settings, and minimizing storage costs. Use it when reviewing billing, implementing cost controls, or reducing credit consumption in your Snowflake environment.

This comprehensive guide details how to implement robust data governance and privacy controls within Snowflake. Learn to apply column-level masking policies, row access policies, and object tagging to secure PII data. It provides practical SQL examples for achieving GDPR/CCPA compliance, managing data subject rights (access, erasure, rectification), and setting up automated data retention tasks.