Skill UI

This workflow provides a complete, end-to-end solution for building and deploying robust web scrapers using Crawlee on the Apify platform. It guides users through every stage: defining input schemas, setting up the Actor with a sophisticated router pattern, extracting structured data (e.g., product details), saving results to datasets, and managing the full lifecycle from local testing to cloud deployment via apify-cli.

This guide details how to set up and test Apify Actors locally using the Apify CLI. It emulates the full platform environment (including datasets, key-value stores, and request queues), allowing developers to run scrapers, test data handling, and debug the entire development lifecycle before deploying to the cloud. Perfect for rapid iteration and rigorous local testing.

A comprehensive guide to building robust, production-ready applications using the Apify SDK and apify-client in TypeScript. Covers advanced topics like standardized client singleton patterns, selecting the right Crawlee crawler (Cheerio, Playwright, Puppeteer), implementing robust Actor lifecycles, and managing dataset/key-value store operations.

A robust reference architecture designed for integrating multi-property portfolios with the AppFolio Stack API. It manages complex tasks such as real-time vacancy tracking, tenant lifecycle management, work order routing, and financial accounting reconciliation (e.g., QuickBooks/Xero). Key components include a service layer, multi-level caching strategies for optimal data freshness, and an event-driven pipeline (using webhooks and message queues) to ensure data consistency and idempotency across all transactions, addressing potential rate limits and failure modes.

This skill provides robust mechanisms to handle real-time webhook events from the AppFolio property management platform. It processes critical lifecycle events such as tenant onboarding, lease signings, rent payments, and maintenance work order updates. By utilizing these webhooks, developers can securely and instantly sync AppFolio data with external systems (e.g., CRM, accounting, custom dashboards), avoiding inefficient API polling and ensuring data consistency.

A comprehensive guide for working with Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. This skill covers full lifecycle development, including schema management, data migration (e.g., MySQL to DSQL), multi-tenant patterns, IAM authentication, and advanced query plan explainability. Essential for building robust, scalable applications.

This guide provides production-ready patterns for using the @clickhouse/client library in Node.js. It covers critical, real-world scenarios such as safe typed queries, streaming large data inserts (with backpressure handling), robust batch operations with retries, and streaming SELECT queries for low memory consumption. It also includes best practices for comprehensive error handling and connection lifecycle management, ensuring stable and scalable ClickHouse integrations for data pipelines.

This skill provides comprehensive handling for sensitive data extracted from the ClickUp API. It includes automated PII detection (emails, phone numbers, SSN), data redaction for secure logging, and mechanisms to ensure GDPR/CCPA compliance through structured data exports. Furthermore, it enforces data retention policies, managing data lifecycle from collection to secure deletion.

This comprehensive guide outlines essential security protocols for integrating with the Figma API. It covers best practices including securely storing Personal Access Tokens (PATs), implementing least-privilege scopes, managing token rotation lifecycles, and verifying incoming webhook payloads. Use this when setting up, auditing, or maintaining production-grade Figma integrations to ensure data integrity and prevent unauthorized access.

A comprehensive guide to managing the full application lifecycle on Fly.io. This workflow covers deploying applications, configuring the environment using fly.toml, managing sensitive secrets, scaling resources across multiple regions, and controlling the application's operational state (including suspension and destruction). Ideal for setting up production-grade, resilient cloud services.

A comprehensive TypeScript SDK providing production-ready patterns for interacting with the Fly.io Machines REST API. It includes a typed client for managing the entire machine lifecycle—creation, state polling, and deletion—across multiple global regions. Features like robust error handling, rate-limit retries, and deployment builders ensure reliable multi-region orchestration for edge computing applications.

This skill provides comprehensive best practices for securing highly sensitive financial and tax data processed by SaaS platforms, such as handling SSNs, EINs, and bank details. It covers critical security mechanisms including API key lifecycle management, webhook signature verification (HMAC), robust input validation (Zod), and PII redaction to ensure compliance with standards like SOC 2 and industry best practices.