数据与 AI技能

在PostgreSQL中格式化数字显示，去除小数点后的尾随零，并在小数点后无数字时去除小数点。

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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".

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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.

中文简介正在准备中。当前显示原文说明。

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

中文简介正在准备中。当前显示原文说明。