Skill UI

A comprehensive guide for developers upgrading the Lokalise Node.js SDK across major versions (e.g., v8 CommonJS to v9 ESM). This skill detects and resolves breaking changes, including module system shifts (require to import), updating package configurations, and modernizing pagination from offset to cursor-based methods, ensuring smooth API integration.

This skill guides developers through setting up and processing Lokalise webhooks for real-time content synchronization. It covers the API integration steps to register webhook endpoints, handling various translation lifecycle events (key creation, translation updates, file imports), and implementing secure payload verification using webhook secrets. It demonstrates building robust, asynchronous event handlers in Node.js/Express, perfect for automating workflows based on content changes in a SaaS environment.

Provides comprehensive patterns for data synchronization, ETL processes, and data migration specifically for MaintainX. Use this when needing to keep data consistent between MaintainX and external databases, data warehouses (like BigQuery), or when performing bulk data exports to formats like CSV. It covers incremental syncing, full exports, and data reconciliation checks.

This guide demonstrates how to implement robust Role-Based Access Control (RBAC) for MaintainX integrations using TypeScript and Express. It defines multiple user roles (Admin, Manager, Technician, Viewer) with specific, granular permissions across various resources (work orders, assets, locations). The implementation utilizes permission middleware and scoped API keys to ensure that users can only perform actions designated by their assigned role, enforcing security and data integrity at the API level.

This guide provides advanced techniques for optimizing API integration performance with MaintainX. It covers essential concepts such as connection pooling, implementing multi-level caching (L1/L2 using Redis), batch data loading via DataLoaders, efficient cursor-based pagination, and request deduplication. Use this skill when optimizing slow API responses or improving overall system data throughput.

A comprehensive client library pattern for interacting with rate-limited APIs. This solution implements exponential backoff, robust retry logic (handling 429/5xx errors), concurrent request queuing, and cursor-based pagination. It ensures high throughput and reliable data fetching without exceeding API limits.

This guide provides production-grade patterns for building robust integrations with the MaintainX REST API. It covers essential techniques such as creating type-safe clients using TypeScript, implementing reliable cursor-based pagination, handling API rate limits with exponential backoff retry logic, and performing efficient batch operations. Ideal for developers building scalable, resilient API wrappers.

A comprehensive guide to implementing robust, multi-layered API response caching using distributed stores like Redis and Memcached, alongside CDN integration. Learn advanced strategies such as tag-based cache invalidation, read-through/write-through patterns, TTL management, and serving stale-while-revalidate content to drastically boost application performance and scalability.

Manages database schema migrations by generating timestamped up/down scripts for PostgreSQL, MySQL, SQLite, or MongoDB, letting you create, apply, or rollback changes safely when handling schema updates.

Automates designing and implementing table partitioning strategies to keep large databases performant, optimize time-series workloads, and shorten maintenance windows, with guidance on key selection, SQL scripts, and query tuning.

Handles disaster recovery, PITR, and automated failover for production databases via the database-recovery-manager plugin, streamlining backup validation and recovery testing whenever users ask for database recovery support.

Automates database replication tasks with the database-replication-manager plugin, covering setup, failover, lag monitoring, and read scaling for PostgreSQL/MySQL clusters.