Skill UI

A comprehensive guide for implementing standardized, robust error handling in modern APIs. It utilizes RFC 7807 Problem Details, centralized middleware, and typed error classes to convert diverse failure types (validation, auth, database, upstream service) into consistent, machine-readable responses with correct HTTP status codes. Essential for building production-grade, resilient backends.

Generates and implements backup strategies for databases and applications, producing configuration files and automation scripts that ensure secure, scalable protection and disaster recovery readiness across platforms.

Automates choosing and configuring database audit logging strategies, offering trigger/application/CDC/log-based options, schema templates, and guidance for compliance or debugging workflows.

Implements multi-tier database caching using Redis, in-memory stores, and CDN integration to reduce load, lower query latency, and support scalable cache-aside, write-through, or read-through workflows when users ask for caching optimizations.

Automated backend guidance for Kafka producer and consumer workflows, offering best practices, code samples, and configuration help for Node.js, Python, Go, databases, caching, messaging, and microservices scenarios.

This skill provides comprehensive guidance for senior-level Laravel engineering. It focuses on building production-grade, maintainable, and highly secure applications using modern architectural patterns (clean architecture, services, etc.). Use this when developing new features, refactoring complex code, designing robust APIs, or optimizing database interactions within a Laravel environment. Adheres to best practices like Eloquent optimization and proper authentication flows.

This skill provides comprehensive patterns for synchronizing, backing up, and maintaining data consistency between a local database and the Linear API. It covers full pagination sync, efficient webhook-based incremental updates, and conflict resolution. Implement this when building client applications that require a reliable, up-to-date local mirror of Linear issue data.

Execute comprehensive load, stress, and soak tests to validate API performance, identify scaling bottlenecks, and establish throughput baselines. This tool simulates realistic, high-volume traffic patterns using industry-standard tools like k6 or Artillery, allowing users to define complex scenarios (e.g., e-commerce checkout flows, traffic spikes) and assert performance thresholds (p95 latency, error rates). It helps pinpoint resource limitations in databases, network layers, or compute resources, ensuring the API is ready for production scalability.

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.

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.