Data & AI skills

Collect auditable Reddit search results and full comment trees at scale, preserve the source JSON, and normalize posts and comments into analysis-ready JSONL. Use for VOC, market research, community discovery, keyword snowballing, or any task that needs Reddit post and comment text without inventing unavailable fields. Reddit data layer of the bggg VOC suite (shared project folder; orchestrated by industry-orchestrator, reported by bggg-voc-report).

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

Collect auditable public X/Twitter posts by controlling the user's already logged-in Chrome, searching X's rendered web interface, scrolling visible results, and extracting original post text and metadata from DOM into normalized JSONL. Use for VOC research, social listening, multilingual keyword discovery, competitor monitoring, or historical search when X requires the user's browser session and cookies, credentials, internal GraphQL, paid APIs, or search-engine snippets must not be exported or used. X data layer of the bggg VOC suite (shared project folder; orchestrated by industry-orchestrator, reported by bggg-voc-report).

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

Collect Amazon.com written product reviews at scale through Woot's public review AJAX route, retain every attempt and error log, reconcile partial runs, and normalize exact review text into auditable JSONL. Use for VOC, competitor review mining, low-star complaint analysis, listing research, or batch ASIN review acquisition without Amazon credentials. Amazon data layer of the bggg VOC suite (shared project folder; orchestrated by industry-orchestrator, reported by bggg-voc-report).

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

根据指定的行切片规则和列映射，将源DataFrame（df_sub）的列数据转换为长格式DataFrame，包含sub_id、trial、start_time、end_time等字段。

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

基于历史数据利用统计分析方法预测下一组数字，严格遵守前5位(1-35)和后2位(1-12)的范围限制，输出简洁的预测结果。

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

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

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

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

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

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

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

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

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.

使用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.

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

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

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

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

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

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

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

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.

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.

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.

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.

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.

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.

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

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