Skill UI

Provides a comprehensive guide for managing Amazon Aurora DSQL, a serverless, PostgreSQL-compatible distributed SQL database. It covers direct query execution, robust schema management, safe schema evolution, multi-tenant isolation patterns, and IAM authentication. Use cases include database development, complex migrations (e.g., MySQL to DSQL), and optimizing query performance using detailed plan explainability tools.

This advanced workflow allows developers to clone live websites directly into structured React or HTML code using the Anima platform. It goes beyond simple cloning by featuring post-generation customization rules (e.g., updating utility classes or imports) and a dedicated design token mapper. This ensures the generated code is immediately usable and adheres strictly to the project's existing design system tokens, while also organizing the final component structure.

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.

This comprehensive guide details how to optimize Apify Actors for maximum efficiency, cost-effectiveness, and reliability. Learn to select the appropriate crawler (e.g., Cheerio, Playwright), tune concurrency limits, manage memory consumption, and implement robust proxy rotation strategies for diverse web scraping workloads, ensuring your scraping tasks are fast and stable.

A comprehensive guide on managing rate limits when interacting with the Apify Platform API. It details best practices for building robust, high-throughput automation workflows, covering built-in retries, request queuing using p-queue, batching large payloads, and staggering concurrent operations to prevent 429 errors and maintain system stability.

This guide provides advanced strategies to optimize API call patterns when integrating with AppFolio's property management platform. By implementing techniques like local caching (TTL), batch querying, adopting webhooks instead of polling, and setting usage monitors, users can drastically reduce redundant API calls, thereby minimizing operational costs and maximizing profitability for large-scale property portfolios.

A comprehensive debug bundle designed to collect diagnostic evidence from AppFolio property management API integrations. It captures essential data points including API connectivity status for properties, tenants, and work orders; authentication status using client credentials; recent integration error logs; and environment metadata. This allows support engineers to perform root cause analysis and diagnose issues like connectivity failures or authentication rejections without needing live environment access.

This guide provides comprehensive strategies to optimize API interactions with the AppFolio property management platform. It covers implementing effective caching strategies, utilizing batch operations for bulk updates, setting up connection pooling, and robust rate limit management. Adopting these techniques significantly reduces API call volume and improves data retrieval performance for large-scale real estate portfolios.

This guide provides essential security practices for integrating with the AppFolio platform. It covers secure API credential management, implementing robust webhook signature verification, validating incoming tenant data payloads, and redacting sensitive PII (like SSNs and bank accounts) from logs. Use this when building integrations that handle owner or tenant financial data to ensure compliance and prevent data breaches.

This skill manages the complex process of upgrading AppFolio API integrations. It automatically detects current and latest API versions, handling breaking changes such as renamed fields, altered pagination models, and deprecated endpoints. The tool provides schema migration transforms and implements a robust rollback strategy, ensuring stable data synchronization during major platform updates.

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.