Generates or improves technical documentation for the 'Detailed information about an alarm record' section in a cloud-based gateway management platform, adhering to a specific field schema and style preferences.
Создание и корректировка SQL-запросов для базы данных ClickHouse (таблица ComponentsRaw.flow) с учетом специфических правил преобразования типов портов и синтаксических ограничений.
Generates a Logical Framework (Logframe) in a table format with specific columns for project planning and evaluation.
Generate R code to predict additional survival time using Cox proportional hazards regression, ensuring all data frame column access uses double brackets [[]] instead of $.
Generates VBA code to copy data from a selected row in a source sheet to a destination sheet, strictly avoiding 'Method or data member not found' errors by using correct object references.
Generates structured slide content for AWS services, organized by specific functional categories and formatted with a fixed schema.
Implement a custom DataFrame class in Python with specific methods (__init__, __getitem__, __repr__, etc.) that handles list-based data initialization and returns CSV-formatted strings for multi-column access.
Design a comprehensive star schema data model from business KPIs, generate MySQL DDL scripts, and create secure Python ETL scripts for daily data synchronization using upserts and complex SQL queries.
Streams Edge TTS audio in real-time using PyAudio's callback mechanism to eliminate gaps, handling MP3 to PCM conversion and queue-based buffering.
Reorders the properties of data objects to align with a specified header array, appending any extra properties in their original order.
Generates standard SCP Foundation formatted logs (Test, Discussion, Event) featuring SCP-085 (Cassy), utilizing a detailed transition workflow for test logs with enhanced clinical formatting and specific interview protocols.
Generates structured presentation slide content for cloud services based on a specific schema and categorization order.
Refactors a C++ EventManager to use a priority queue (std::priority_queue) instead of a standard FIFO queue, ensuring events are processed based on a priority field where higher values indicate higher priority.
Generates detailed conceptual designs for autonomous, deep-space exploration spacecraft, focusing on bio-inspired forms (e.g., spermatozoa cell), advanced multi-layered shielding systems (hydrogen aerogel, boron-polyethylene, tungsten), self-replicating maintenance drones ('crabbie fellows'), and long-duration power/data solutions (nuclear reactors, 5D crystalline storage).
Designs a modular and scalable Firestore database schema (dataverse) for a superapp ecosystem. It unifies core entities like users, orders, and vehicles across multiple services (e.g., shops, logistics, water) to ensure data isolation, reduce technical debt, and allow for 'plug and play' addition of new mini-apps.
Estimates gas fees dynamically using provider.send('eth_gasPrice') for environments where getGasPrice is unavailable. Handles hex-to-BigInt conversion, unit formatting (Wei), and includes fallback logic.
Manages the full lifecycle of Firestore expense data, including date-based initialization, additive array updates across time granularities, and time-series visualization using Jetpack Compose and Vico.
ByteHouse 多模态检索 Skill，支持文本、图片、视频的向量化存储和混合检索。当用户需要在ByteHouse数据库中进行多模态向量化存储和混合检索时，使用此Skill。
Analyze spring-data-relational version changes and identify required updates for the current project. Use when upgrading spring-data-relational versions or syncing with upstream changes.
Apply Change Data Capture (CDC) with apply_changes API in Spark Declarative Pipelines. Use when user needs to process CDC feeds from databases, handle upserts/deletes, maintain slowly changing dimensions (SCD Type 1 and Type 2), synchronize data from operational databases, or process merge operations.
