Skill UI

This document provides a comprehensive, production-grade reference architecture for integrating with the SalesLoft API. It details the best practices for building robust systems, including structured API clients with rate-limit handling, dedicated service layers for business logic (e.g., People Sync), reliable webhook processing, and background job scheduling. Use this guide when designing scalable, resilient, and maintainable integrations with external SaaS platforms.

This comprehensive guide outlines best practices for securing SalesLoft API access and integrations. It details secure token lifecycle management (OAuth refresh), implementing robust webhook signature verification using HMAC-SHA256 to prevent replay attacks, and enforcing scope minimization for least-privilege access. Use this when designing production-grade, secure enterprise integrations.

This guide provides comprehensive steps for migrating existing integrations interacting with the SalesLoft REST API. It focuses on critical transitions, such as moving from deprecated static API keys to secure OAuth 2.0 flows (including client credentials and token refreshing). It also covers adopting new features, such as the Cadence Import/Export API, and best practices for handling endpoint changes and schema updates during major platform upgrades.

This guide outlines production-ready patterns for integrating SerpApi into robust search services. It covers essential best practices, including defining typed result interfaces for type safety, implementing LRU caching to conserve API credits, and building multi-engine abstractions to handle various search types (web, news, images). It also demonstrates asynchronous search processing for non-blocking operations.

This guide outlines essential security best practices for managing and protecting your SerpApi API key. Since the key grants full account access, developers must never expose it in client-side code. It details how to implement secure backend proxies, manage environment variables using secret managers, set up rate limiting to prevent abuse, and monitor usage patterns in production environments.

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.

A comprehensive checklist for deploying Shopify apps to production or submitting to the App Store. It covers critical areas including API versioning, mandatory GDPR compliance webhooks, webhook security best practices, rate limit resilience, and App Store listing requirements. Use this guide when preparing for a major launch or auditing existing compliance gaps to ensure maximum stability and security.

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.

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 comprehensive guide details how to set up robust, isolated, and secure development, staging, and production environments within Snowflake. It utilizes best practices like zero-copy cloning for efficient data replication, implements granular Role-Based Access Control (RBAC), and defines environment-specific compute resources (warehouses) and data masking policies. This ensures data integrity, compliance, and cost optimization across all stages of the data lifecycle.

A comprehensive guide to optimizing query performance in Snowflake. Learn advanced techniques such as implementing clustering keys, utilizing materialized views, leveraging result caching, and analyzing query profiles. This guide also covers best practices for warehouse tuning and optimizing common SQL anti-patterns to ensure efficient data querying and cost management.

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.