Skill UI

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.

Implements robust Role-Based Access Control (RBAC) for Juicebox, an AI-powered platform for recruiting and sales. This system defines granular permissions for various roles (Admin, Recruiter, Analyst, etc.), controlling access to sensitive candidate databases, data enrichment capabilities, outreach functions, and data export. It ensures data governance, maintains compliance (e.g., SOC 2), and segments user access based on job function and need-to-know principles.

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 comprehensive guide details the end-to-end process of building Retrieval-Augmented Generation (RAG) pipelines using LangChain. It covers critical steps: loading diverse document types (PDF, CSV, TXT), splitting text into manageable chunks, generating high-quality embeddings (OpenAI), storing them in various vector databases (FAISS, Pinecone), and finally constructing the full runnable chain for accurate and context-aware querying.

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.

A comprehensive guide and tool for building and configuring complex, multi-step AI agent workflows. Users can define sophisticated automation pipelines by chaining together customizable triggers (e.g., email, webhook), actions (e.g., Slack post, database update), conditional logic, and external knowledge bases. Ideal for automating business processes like customer support triage, data processing, and complex notifications, ensuring deterministic and scalable AI operations.

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.

This deep-dive guide provides a comprehensive framework for migrating complex operational data into the MaintainX platform. It systematically guides users through assessing source data quality from legacy CMMS systems (like Maximo), spreadsheets, or custom databases. The process covers essential steps including data assessment, schema mapping, and executing robust ETL processes for work orders and assets, ensuring a smooth re-platforming transition.

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.