Skill UI

This guide provides a comprehensive setup for Continuous Integration (CI) and Continuous Deployment (CD) for SerpApi integrations. It outlines using fixture-based unit tests via GitHub Actions for Pull Requests (preventing API credit consumption) and controlled live integration tests on the main branch. This ensures robust and reliable search result parsing validation.

This wrapper integrates Shopify's official AI Toolkit MCP server with Claude Code. It provides essential developer capabilities, including real-time GraphQL schema validation, Liquid template linting (checking for deprecated filters and anti-patterns), and instant search across Shopify's extensive documentation. Use this skill when setting up complex Shopify MCP integrations, ensuring code quality, or debugging API calls.

This guide helps developers choose the optimal architecture pattern for building on Shopify. It compares four validated variants: Embedded Remix App (for admin tools), Headless Storefront (for custom e-commerce experiences using Hydrogen), Backend Integration (for system syncing like ERP), and Theme App Extension (for storefront widgets). Use this resource when starting a new Shopify project to determine the correct development path and technology stack.

A comprehensive guide for diagnosing and fixing common Shopify API errors, including HTTP status codes (401, 403, 422, 429) and GraphQL userErrors. This tool helps developers quickly identify the root cause of failed API requests, whether due to incorrect scopes, expired tokens, or validation issues, and provides actionable steps for resolution.

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.

Implement comprehensive automated policy enforcement for Shopify apps, ensuring security and adherence to App Store guidelines. This skill includes ESLint rules for detecting hardcoded API secrets, enforcing GraphQL query cost budgets, and running pre-commit hooks and CI checks for critical compliance validations (e.g., GDPR webhooks). Use it when hardening a production-ready Shopify application.

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.

A comprehensive guide detailing the process of migrating data warehouses to Snowflake from major sources like Amazon Redshift, Google BigQuery, or on-premise databases. This resource covers critical steps including schema conversion (handling dialect differences like STRUCT/ARRAY to VARIANT), robust data transfer methods (S3/Cloud Storage, Python/Pandas), data validation techniques (checksums, row counts), and essential SQL syntax translation patterns.

This skill provides comprehensive guidance on implementing robust data governance and security guardrails within Snowflake. It covers advanced features such as network rules, mandatory authentication policies (MFA, Key Pair), session timeouts, and statement-level controls. Use this when enforcing strict security policies, achieving regulatory compliance, or structuring robust data access controls for a Snowflake environment.

This comprehensive checklist guides the deployment of Snowflake data pipelines and integrations into a production environment. It covers critical areas such as authentication best practices, warehouse configuration, data pipeline readiness, access control, monitoring setup, and disaster recovery planning. Use it when preparing for a go-live or validating the stability of your production Snowflake setup.

This comprehensive guide provides step-by-step instructions for upgrading Snowflake drivers (Node.js and Python) and managing complex data warehouse migrations. It covers prerequisite checks, reviewing release notes, handling common API breaking changes (e.g., cursor types, async connections), and performing post-migration validation to ensure application stability during platform or edition upgrades.

This skill provides essential guidance on managing key WebContainer lifecycle events, including server readiness, port changes, and error handling. It is crucial for developers integrating with WebContainers or using the StackBlitz SDK to ensure robust and reliable application state management in development environments.