Skill UI

This guide details how to implement robust and secure authentication for Shopify applications using the official @shopify/shopify-api SDK. It covers three main authentication methods: OAuth flow for public apps, session token exchange for embedded apps, and private access for custom apps. Use this skill when setting up, connecting, or debugging any application that requires deep integration and secure API access to Shopify's admin or storefront data.

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.

Set up comprehensive observability for Shopify app integrations. This skill tracks crucial metrics like GraphQL query costs, REST rate limit consumption, webhook delivery success, and API latency. It is essential for production monitoring, setting up robust Prometheus metrics, and configuring alerts for performance bottlenecks in e-commerce SaaS environments.

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.

Master the art of building fault-tolerant e-commerce applications for Shopify. This guide covers essential reliability patterns, including implementing circuit breakers for API outages, ensuring webhook idempotency to handle retries, and utilizing queue systems and cached fallbacks for graceful degradation. Essential for building highly resilient integrations that withstand API failures and webhook storms.

A comprehensive guide to production-ready patterns for the Shopify API SDK. Covers advanced topics like typed GraphQL clients, multi-tenant architecture, cursor-based pagination, bulk operations, and robust error handling. Use this when developing scalable and maintainable e-commerce integrations for Shopify.

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 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.

Master the deployment of applications connected to Snowflake across various cloud environments, including serverless functions (AWS Lambda, Cloud Run) and containers. This guide covers best practices for secure connection management, connection pooling, handling secrets (like private keys), and ensuring application reliability in production settings.

This guide provides comprehensive steps to install and configure Snowflake SDKs for Node.js and Python. It covers various authentication methods, including password, secure Key Pair authentication (ideal for CI/CD), and enterprise-grade SSO/OAuth integration. Use this when setting up data pipelines or applications that require reliable and secure connectivity to the Snowflake data warehouse.

This guide establishes a fast, reproducible local development loop for Snowflake. It covers setting up isolated dev warehouses, implementing connection wrappers, and structuring unit and integration tests (including mocking) to ensure rapid iteration and reliable development against a simulated or real Snowflake environment.

Master event-driven patterns within Snowflake using native alerts, email integrations, external functions, and cloud notification services (S3/GCS). This skill is essential for building robust, reactive pipelines that trigger actions (like sending alerts, calling external APIs, or ingesting data) in response to data changes or specific system events. Use cases include data quality checks, real-time monitoring, and automated notifications.