数据与 AI技能

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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.

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

编写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.

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

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.

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

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.

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

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

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

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

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

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.

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

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.

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

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

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

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.

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

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

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

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.

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

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.

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

Design, audit, and improve analytics tracking systems that produce reliable, decision-ready data. Use when the user wants to set up, fix, or evaluate analytics tracking (GA4, GTM, product analytics, events, conversions, UTMs). Focuses on measurement strategy, signal quality, and validation — not just firing events.

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

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

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