Data & Analytics

jpcaparas Bundle

Create .xlsx travel workbooks with itinerary, preparation, or shopping sheets for trip, holiday, or conference planning. Skip prose itineraries, recommendation chat, and calendar-only scheduling.

huifer Skill

Basic E-commerce Analytics

huifer Bundle

同群分析器 - 按注册/购买时间分组分析客户留存、收入和行为趋势

huifer Bundle

数据仓库设置 - 数据架构设计、ETL流程设计、数据建模、BI工具集成、数据治理、数据安全

huifer Bundle

预测分析器 - 销售预测、需求预测、客户行为预测、库存需求预测、现金流预测

natthasath Bundle

วิเคราะห์ข้อมูล Google Analytics 4 (GA4) ผ่าน official Google Analytics MCP (googleanalytics/google-analytics-mcp) แล้วสรุปผลเป็น web dashboard (Artifact) ที่ดูง่ายและแชร์ได้ทันที ครอบคลุม 6 use case หลัก: สรุป traffic เทียบช่วงเวลา (WoW/MoM), หน้าเว็บที่คนดูเยอะสุด (top pages/landing pages), แหล่งที่มาของทราฟฟิก (channel breakdown: organic, paid, referral, social, direct), funnel/conversion tracking, จำนวนคนออนไลน์ตอนนี้ (real-time), และข้อมูลประชากรผู้ใช้ (ประเทศ/device/ browser) ใช้ skill นี้ทันทีเมื่อผู้ใช้พูดถึง "Google Analytics", "GA4", "traffic เว็บ", "คนเข้าเว็บกี่คน", "หน้าไหนคนดูเยอะสุด", "conversion rate", "funnel", "ทราฟฟิกมาจากไหน", "real-time analytics", "รายงาน analytics", "สรุปสถิติเว็บไซต์" หรือขอให้ดึง/สรุปข้อมูลจาก property GA4 ใดๆ เรียกใช้ผ่าน `/insight-ga4` เท่านั้น — ไม่ auto-trigger จากบทสนทนา

maziyarpanahi Skill

De-identify selected free-text columns in a local CSV, JSONL, or Parquet dataset with OpenMed and produce a separate redacted dataset plus a PHI-free aggregate summary. Use when an agent must prepare a clinical dataset for analysis or sharing without overwriting the source or exposing cell values in logs.

maziyarpanahi Skill

Detects and extracts tabular laboratory panels from PDFs, scans, and images into structured rows ready for OpenMed and FHIR. Use when the user has a CBC, CMP, lipid panel, or other lab report as a scanned image / PDF / spreadsheet and needs the test name, value, unit, reference range, and abnormal flag as clean rows. Trigger keywords: lab table extraction, lab panel, OCR labs, table detection, layout analysis, header detection, reference range column, abnormal flag column, LOINC, UCUM, CBC, CMP, structured labs. Pairs before OpenMed: OCR/parse the table on-device (openmed.multimodal.ocr.ocr, read_table), de-identify embedded PHI with openmed.deidentify, then hand structured rows to LOINC/UCUM mapping and openmed.clinical lab flagging. Image/CSV/TSV intake is supported; PDF/DOCX raise UnsupportedDocumentError — render those to images or text first.

maziyarpanahi Skill

Authors computable phenotype and cohort definitions in the OHDSI ATLAS / CIRCE style over the OMOP CDM, combining standard concept sets with NLP-derived features that OpenMed extracts. Use when the user wants to define a patient cohort, write a computable phenotype, reuse PheKB or OHDSI Phenotype Library logic, build concept sets, or augment code-based criteria with text features. Trigger keywords: phenotype, cohort definition, OHDSI, ATLAS, CIRCE, OMOP CDM, concept set, PheKB, Phenotype Library, eMERGE, computable phenotype. Pairs adjacent to OpenMed: NLP features from openmed.analyze_text augment code-based phenotypes for entities that are poorly captured by structured codes. OMOP CDM and OHDSI tools are open source; restricted vocabularies (SNOMED, CPT) are user-supplied.

maziyarpanahi Bundle

Turn scanned faxes, images, and CSV/CDA exports into clean text ready for OpenMed de-identification and NER, fully on-device. Use when the user has clinical documents (image scans, photographed/faxed notes, tabular CSV/TSV exports, C-CDA XML) and needs OCR or structured intake before openmed.deidentify and openmed.analyze_text, asks about openmed.multimodal, OCR engines (Tesseract / PaddleOCR), tabular redaction, or layout and reading order. Covers the verified ocr() and redact_document() entry points and the ExtractedDocument contract. Pairs before deidentifying-clinical-text and extracting-clinical-entities.

medy-gribkov Bundle

Excel file creation, editing, analysis with openpyxl and pandas. Use for .xlsx/.csv tasks including formulas, formatting, pivot tables, charts, data cleaning, and tabular file operations.

medy-gribkov Bundle

Code security review covering OWASP Top 10, injection prevention (SQL, XSS, command injection), authentication and authorization patterns, secrets management, dependency vulnerability scanning, input validation, CORS, CSRF, rate limiting, and security headers. Language-agnostic with examples in JavaScript, Python, and Go. Use when reviewing code for security or hardening an application.

vaquarkhan Skill

Guides agents through data warehouse and schema design. Use when defining fact and dimension models, keys, grain, normalization versus denormalization, serving-layer schema boundaries, and downstream-friendly table design.

vaquarkhan Skill

Guides agents through Trino and Presto federated query design. Use when querying across heterogeneous systems, planning semantic consistency, or managing performance and governance in federated analytics.

vaquarkhan Skill

Guides agents through analytics engineering workflows with dbt. Use when building or modifying staging models, marts, tests, snapshots, documentation, exposures, or semantic-layer-facing models.

vaquarkhan Skill

Guides agents through ClickHouse-based real-time analytics design. Use when building fast analytical serving layers, event aggregations, materialized views, or low-latency metric access patterns.

vaquarkhan Skill

Guides agents through DuckDB-based local analytics and development workflows. Use when prototyping models locally, validating transformations, reproducing data issues quickly, or building lightweight analytical tooling without a full warehouse.

vaquarkhan Skill

Guides agents through ETL, ELT, and transformation-modernization decisions. Use when choosing execution boundaries, redesigning transformation layers, or moving from legacy ETL estates to warehouse- or lakehouse-centered ELT patterns.

vaquarkhan Skill

Guides agents through semantic layer and shared metric design. Use when defining business metrics, reusable dimensions, governed metric contracts, or shared semantic models consumed by dashboards, analytics tools, or other teams.

vaquarkhan Skill

Guides agents through publishing data products for internal or external consumers. Use when sharing tables, files, extracts, APIs, or reverse-ETL-ready outputs that require stable contracts, ownership, and communication.

vaquarkhan Skill

Guides agents through Unity Catalog governance workflows for Databricks lakehouses. Use when defining catalogs, schemas, external locations, access boundaries, shares, lineage, and cross-workspace governance for governed Delta Lake, ML, analytics, and serving assets.

vaquarkhan Skill

Guides agents through reverse ETL and operational data serving workflows. Use when sending curated warehouse data to business systems, SaaS tools, APIs, activation layers, or operational applications that rely on stable downstream contracts.

vaquarkhan Skill

Guides agents through data-quality operating models and tool selection. Use when designing rule portfolios, severity levels, ownership, evidence, and enforcement across dbt tests, Great Expectations, Deequ, Cuallee, Soda, warehouse-native checks, and platform monitoring workflows.

vaquarkhan Skill

Guides agents through warehouse performance and cost decisions. Use when optimizing BigQuery, Snowflake, Redshift, Athena, Synapse, or lakehouse query patterns, storage layout, and workload isolation.

vaquarkhan Skill

Guides agents through operating, hardening, and modernizing enterprise ETL and integration stacks such as Informatica, Talend, DataStage, SSIS, and Matillion. Use when legacy mappings, job orchestration, migration, or coexistence with modern lakehouse patterns must be handled safely.

xonovex Bundle

Use when editing PostgreSQL 15+ queries, schemas, or migrations. Triggers on `.sql` files, migration files, schema files, and prompts about CTEs, indexing, JSONB, RLS, EXPLAIN ANALYZE, or constraints, even when the user doesn't say 'Postgres'.

coderwanfeng Bundle

将 Excel 文件的指定工作表转换为 PDF 格式。当用户提到 Excel 转 PDF、表格转 PDF、导出 Excel 为 PDF 时使用。

coderwanfeng Bundle

自动创建 Excel 并模拟数据。当用户提到生成测试数据、mock 数据、造数据、Excel 模板、模拟数据时使用。

coderwanfeng Bundle

将多个 Excel 文件合并到一个 Excel 的不同 sheet 中。当用户提到合并 Excel、合并多个表格、多个 Excel 合并时使用。

coderwanfeng Bundle

将多个 Excel 文件的多个 sheet 合并到同一个 sheet。当用户提到合并 sheet、跨表合并、汇总多个表格时使用。

coderwanfeng Bundle

将同一个 Excel 文件的多个 sheet 拆分为独立文件。当用户提到拆分 sheet、Excel 按表拆分、拆 sheet 时使用。

coderwanfeng Bundle

在 Excel 文件中搜索指定关键词并返回文件、行号、详情。当用户提到搜索 Excel、Excel 查找、Excel 搜索内容时使用。

coderwanfeng Bundle

将 Excel 文件转换为 Markdown 格式的文档。当用户提到 Excel 转 Markdown、表格转 MD、Excel 文档化时使用。

coderwanfeng Bundle

用 OCR 技术识别增值税发票图片并导出到 Excel，支持批量处理和翻译。当用户提到发票识别、增值税发票 OCR、电子发票识别、发票汇总时使用。

coderwanfeng Bundle

按指定列的内容拆分 Excel 文件，每个唯一值一个文件。当用户提到按列拆分 Excel、按字段拆分表格时使用。

coderwanfeng Bundle

将文件夹下的所有文件名整理到一个 Excel 表格中。当用户提到文件名清单、文件名导出 Excel、文件名汇总时使用。