Data & AI skills

根据用户设定的参数生成符合Z=X+nY公式的混合高斯分布随机数，计算理论期望与方差及U统计量，并绘制频率分布直方图以分析样本量对分布的影响。

The English summary is being prepared. Showing the original description.

依据用户提供的特定规则执行MySQL数据库开发任务，涵盖命名约束、索引设计策略及海量数据归档方案。

The English summary is being prepared. Showing the original description.

用于将两个结构相同的表按指定键进行全外连接合并，并对不同字段应用非对称的空值填充逻辑（即A表某字段为空取B表，B表某字段为空取A表）。

The English summary is being prepared. Showing the original description.

使用Fluentd的regexp插件解析MySQL慢查询日志，将其切分为时间、用户、查询时间和SQL内容四个字段，并配置字段长度限制以避免解析错误。

The English summary is being prepared. Showing the original description.

用于生成MySQL应付账款统计查询，按到期时间（当前、1个月内、3个月内）分组统计金额，并确保时间范围互不重叠。

The English summary is being prepared. Showing the original description.

Expert AI art prompt engineer for Midjourney and Stable Diffusion. Generates high-quality prompts including unified batch illustrations, marketing designs, interactive compositions, and structured framework prompts with translations.

The English summary is being prepared. Showing the original description.

在对具有多层索引的Pandas DataFrame进行分组计算时，确保返回的结果保留原始的完整索引结构，而不是仅保留分组键。

The English summary is being prepared. Showing the original description.

针对Oracle SQL查询请求，仅输出纯文本SQL语句，不使用Markdown代码块，不提供任何解释，以避免终端显示乱码。

The English summary is being prepared. Showing the original description.

根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。

The English summary is being prepared. Showing the original description.

编写MySQL函数，根据指定的日期范围和字段，按自然周汇总数据并返回特定格式的字符串结果。

The English summary is being prepared. Showing the original description.

针对Pandas DataFrame，按行计算非空且非零元素的排名分位数，并返回该行每个元素对应的分位数值。用于数据标准化或特征工程。

The English summary is being prepared. Showing the original description.

Generates images and text via reverse-engineered Gemini Web API. Supports text generation, image generation from prompts, reference images for vision input, and multi-turn conversations. Use when other skills need image generation backend, or when user requests "generate image with Gemini", "Gemini text generation", or needs vision-capable AI generation.

The English summary is being prepared. Showing the original description.

Build a throwaway prototype to flesh out a design before committing to it. Routes between two branches — a runnable terminal app for state/business-logic questions, or several radically different UI variations toggleable from one route. Use when the user wants to prototype, sanity-check a data model or state machine, mock up a UI, explore design options, or says "prototype this", "let me play with it", "try a few designs".

The English summary is being prepared. Showing the original description.

Operately frontend data fetching with TanStack Query. Use when adding or changing page loaders, model hooks, Api.* calls, mutations, useLoadedData, Pages.useRefresh, or any web UI backend request. New code must use TanStack. When fixing or extending an existing surface, migrate that surface's API calls to TanStack in the same change.

The English summary is being prepared. Showing the original description.

Rules for Operately schema migrations (app/priv/repo/migrations/) and data migrations (app/lib/operately/data/change_*.ex). Use when adding, renaming, reviewing, or generating database migrations, ecto.gen.migration, Operately.Data.Change* modules, backfills, schema_migrations version collisions, mix ecto.migrate, or make gen.migration.

The English summary is being prepared. Showing the original description.

Compose an image prompt with subject, composition and style layers while labeling unverified generator parameters. Use for this Bot Generator Bot template; creates drafts or simulations within its declared scope.

The English summary is being prepared. Showing the original description.

Refine task prompts and propose controlled comparisons without claiming to change model settings or activate plugins. Use for this Bot Generator Bot template; creates drafts or simulations within its declared scope.

The English summary is being prepared. Showing the original description.

Plans architecture migrations with compatibility, data safety, rollout and recovery; does not execute them.

The English summary is being prepared. Showing the original description.

Build secure, reusable data access patterns with DTOs, taint checks, and colocated authorization in Next.js. Use when centralizing database queries, transforming raw data to DTOs, adding server-only guards, or preventing sensitive data from reaching Client Components.

The English summary is being prepared. Showing the original description.

Implement Fetch API, Caching, and Revalidation strategies in Next.js. Use when fetching data, configuring cache behavior, or implementing revalidation in Next.js.

The English summary is being prepared. Showing the original description.

Write idiomatic Kotlin 1.9+ with null safety, sealed classes, data classes, extension functions, delegates, collections, inline/reified generics, and expression syntax. Use for Kotlin language constructs, Java-to-Kotlin migration, lazy delegates, data classes, backing properties, or inline/reified generics; keep language constructs in scope even inside response models, and defer coroutine configuration, Android Context/framework, Retrofit/OkHttp client setup, and other library-specific recipes.

The English summary is being prepared. Showing the original description.

Write performant Eloquent queries with eager loading, reusable scopes, and strict lazy-loading prevention in Laravel. Use when defining model relationships, creating query scopes, or processing large datasets with chunk/cursor.

The English summary is being prepared. Showing the original description.

Implement local persistence with SwiftData, Core Data, and secure storage. Use when setting up SwiftData models, Core Data stacks, or local persistence in iOS.

The English summary is being prepared. Showing the original description.

Apply PostgreSQL standards for migrations, indexing, transactions, and ORM boundaries. Use when editing entities, Prisma schema, migrations, RLS, or query-performance work for PostgreSQL.

The English summary is being prepared. Showing the original description.