Skill UI

A comprehensive guide for rapid incident response when Shopify integrations fail or behave unexpectedly. It instructs users to triage issues by checking the status page, diagnosing API connectivity, and handling common errors like rate limits (429) or expired tokens (401). Includes decision trees, immediate mitigation steps, and communication templates.

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.

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 minimal working examples for connecting to Snowflake and executing core SQL operations. It comprehensively covers connection setup, running simple SELECT queries, creating databases and tables, and performing parameterized inserts using both Python and Node.js. It is ideal for initial environment setup, testing the Snowflake SDK, or learning fundamental data warehouse interactions.

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.

This guide provides production-ready, idiomatic patterns for interacting with Snowflake using official SDKs (Node.js and Python). It covers essential patterns like implementing robust connection pooling, handling asynchronous query wrappers, efficiently streaming large result sets, and utilizing context managers for reliable resource cleanup. Use this when establishing team coding standards or optimizing data access performance.

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 guide establishes a comprehensive development loop for automating TechSmith's screen capture and video editing processes (Snagit/Camtasia). It outlines the required project structure, includes PowerShell scripting examples, and details how to use Pester testing framework for robust COM API connection testing, ensuring reliable automation workflows.

Automate the Continuous Integration and Continuous Deployment (CI/CD) workflow for applications leveraging Together AI's OpenAI-compatible API. This skill sets up comprehensive GitHub Actions workflows to run unit tests (mocking completions and embeddings) on every Pull Request, and full integration tests (live API calls) upon merging to the main branch. It ensures robust validation of prompt formatting, model selection, and API connectivity for various LLMs.

A comprehensive guide and workflow for deploying static websites (e.g., Vue, React, Angular, Hugo, Jekyll) from a local environment to a production server using VSCode SFTP. This skill covers setting up secure SFTP connections, generating production-ready Nginx configurations (including security headers, caching, and HTTPS redirects), and providing a complete deployment checklist for smooth CI/CD-like workflows.

This utility collects comprehensive diagnostic evidence necessary for troubleshooting Webflow integrations and API usage. It automatically gathers crucial data points into a single, support-ready diagnostic bundle. Key metrics include the Webflow SDK version, API token validation status, rate limit headers, site connectivity reports, CMS health checks, and recent error logs, significantly streamlining the technical support process.