Data & AI skills

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

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

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

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函数，根据指定的日期范围和字段，按自然周汇总数据并返回特定格式的字符串结果。

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应付账款统计查询，按到期时间（当前、1个月内、3个月内）分组统计金额，并确保时间范围互不重叠。

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

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

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.

Complete knowledge domain for Firecrawl v2 API - web scraping and crawling that converts websites into LLM-ready markdown or structured data. Use when: scraping websites, crawling entire sites, extracting web content, converting HTML to markdown, building web scrapers, handling dynamic JavaScript content, bypassing anti-bot protection, extracting structured data from web pages, or when encountering "content not loading", "JavaScript rendering issues", or "blocked by bot detection". Keywords: firecrawl, firecrawl api, web scraping, web crawler, scrape website, crawl website, extract content, html to markdown, site crawler, content extraction, web automation, firecrawl-py, firecrawl-js, llm ready data, structured data extraction, bot bypass, javascript rendering, scraping api, crawling api, map urls, batch scraping

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

Generate professional clinical decision support (CDS) documents for pharmaceutical and clinical research settings, including patient cohort analyses (biomarker-stratified with outcomes) and treatment recommendation reports (evidence-based guidelines with decision algorithms). Supports GRADE evidence grading, statistical analysis (hazard ratios, survival curves, waterfall plots), biomarker integration, and regulatory compliance. Outputs publication-ready LaTeX/PDF format optimized for drug development, clinical research, and evidence synthesis.

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

Create technical diagrams using Mermaid syntax for architecture, sequences, ERDs, flowcharts, and state machines. Use for visualizing system design, data flows, and processes. Triggers: diagram, mermaid, architecture diagram, sequence diagram, flowchart, ERD, entity relationship, state diagram, C4 model, component diagram, visualize, draw.

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

Master advanced prompt engineering techniques to maximize LLM performance, reliability, and controllability in production. Use when optimizing prompts, improving LLM outputs, or designing production prompt templates.

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

Statistical analysis toolkit. Hypothesis tests (t-test, ANOVA, chi-square), regression, correlation, Bayesian stats, power analysis, assumption checks, APA reporting, for academic research.

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

Creates effective data visualizations using various libraries and tools, with focus on clarity and insight communication. Trigger keywords: chart, graph, plot, visualization, dashboard, matplotlib, d3, plotly, visualization.

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

Use this skill when working with scientific research tools and workflows across bioinformatics, cheminformatics, genomics, structural biology, proteomics, and drug discovery. This skill provides access to 600+ scientific tools including machine learning models, datasets, APIs, and analysis packages. Use when searching for scientific tools, executing computational biology workflows, composing multi-step research pipelines, accessing databases like OpenTargets/PubChem/UniProt/PDB/ChEMBL, performing tool discovery for research tasks, or integrating scientific computational resources into LLM workflows.

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

Master SQL query optimization, indexing strategies, and EXPLAIN analysis to dramatically improve database performance and eliminate slow queries. Use when debugging slow queries, designing database schemas, or optimizing application performance.

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

Design a PostgreSQL-specific schema. Covers best-practices, data types, indexing, constraints, performance patterns, and advanced features

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

This skill calculates key financial ratios and metrics from financial statement data for investment analysis

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

Intelligent pattern selection for Fabric CLI. Automatically selects the right pattern from 242+ specialized prompts based on your intent - threat modeling, analysis, summarization, content creation, extraction, and more. USE WHEN processing content, analyzing data, creating summaries, threat modeling, or transforming text.

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

AI 视频生成全流程：通过 6 个阶段（剧本→角色/场景设计→分镜→参考图→视频生成→后期剪辑）将用户想法转化为完整视频。支持临时工作台（单独调用 LLM、VLM、文生图、图生图、视频生成）。触发词：视频生成、AI视频、AIGC、创作视频、制作视频、AI画图。

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