Data & Analytics

writer Bundle

Recommend optimal product placement within warehouse zones and pick locations using velocity-based slotting, ergonomic analysis, product affinity grouping, and space utilization modeling to minimize travel time and maximize throughput.

magnus919 Bundle

Compare intended product outcomes against observed results to close the launch-to-learning loop: collect post-launch evidence, distinguish expected from observed from uncertain from inferred claims, update assumptions, assess feature health, and choose among continue/improve/harvest/pivot/pause/retire — including retirement lifecycles with deprecation, migration, customer treatment, and retained reusable learning. Do not use for incident postmortems or root-cause analysis (routes to incident-learning or site-reliability-engineering); do not use for analytics instrumentation or metric dashboard design (routes to product-analytics-and-measurement); do not use arbitrary thresholds as universal retirement rules — decisions require human judgment and context.

writer Bundle

Optimize provider scheduling templates using demand pattern analysis, appointment type modeling, buffer optimization, and patient access analytics to maximize throughput, reduce wait times, and improve provider satisfaction.

prorise-cool Bundle

全面的电子表格创建、编辑和分析，支持公式、格式、数据分析和可视化。当 Claude 需要处理电子表格（.xlsx、.xlsm、.csv、.tsv 等）时：(1) 创建带有公式和格式的新电子表格，(2) 读取或分析数据，(3) 在保留公式的同时修改现有电子表格，(4) 在电子表格中进行数据分析和可视化，或 (5) 重新计算公式

lonsdale201 Bundle

Audits WordPress PHP data access for slow or unbounded SQL, LIMIT/OFFSET degradation, N+1 queries, missing cache priming, expensive postmeta joins, LONGTEXT sorting/aggregation, leading-wildcard LIKE, oversized result transfer, unsuitable indexes, cache stampedes, stale invalidation, and direct-write cache bypass. Use when reviewing $wpdb queries, WP_Query loops, metadata loops, admin reports, imports, migrations, bulk tools, transients, object-cache behavior, EXPLAIN plans, or performance problems that grow with posts/users/orders/meta rows.

lonsdale201 Skill

Work safely with WooCommerce order statuses, payment completion, status hooks, order items, line-item meta, totals, stock side effects, and paid analytics/conversion idempotency. Covers `payment_complete()` vs `update_status()`, status-hook ordering, `woocommerce_thankyou` vs paid events, replay-safe external side effects, concrete order-item classes, totals, HPOS-safe CRUD, and stock handling. Use when reacting to orders, changing statuses/items, provisioning, fulfillment, stock logic, external conversion events, or debugging paid orders that skipped lifecycle side effects.

writer Bundle

Identify early warning signals of clinician burnout using Maslach Burnout Inventory dimensions, operational proxy metrics, and workforce analytics to enable proactive intervention and retention strategies.

gabeujin Skill

Review legacy SQL and mapper queries for correctness, performance, binding safety, pagination issues, and maintainability.

lonsdale201 Bundle

Audit WordPress custom-table export, import, restore, merge, and date-range deletion workflows for relational integrity. Covers root selection and dependency closure, shared dimensions, portable identity and ID remapping, schema-versioned manifests, checksums, staging/conflict policy, transaction boundaries, post-import verification, streaming, compressed-size limits, and resumable batches. Use when code emits SQL/CSV/JSON backups, preserves auto-increment IDs, uses INSERT IGNORE, imports into non-empty databases, deletes analytics/log/session data by time range, or promises backup/restore for related custom tables.

asiaostrich Skill

Guide database design, migration, and query optimization. Use when: schema design, migration planning, query optimization, index strategy. Not for: application code migration or framework upgrades — use /migrate; the API contract over the data — use /api-design. Keywords: database, schema, migration, SQL, index, query.

jarle Skill

Bun provides native bindings for working with SQL databases through a unified Promise-based API that supports PostgreSQL, MySQL, and SQLite.

community-access Skill

Score repository health (0-100, A-F grades), priorities, and delta tracking. Includes velocity metrics, confidence levels, and bottleneck detection.

bookforge-ai Skill

Plan and execute architectural-scale refactoring campaigns that take weeks to months — the four named patterns for large-scale structural restructuring from Fowler and Beck's Chapter 12. Use when: an inheritance hierarchy is doing two distinct jobs and subclass names share the same adjective prefix at every level (Tease Apart Inheritance); a codebase written in an object-oriented language uses a procedural style with long methods on behavior-less classes and dumb data objects (Convert Procedural Design to Objects); GUI or window classes contain SQL queries, business rules, or pricing logic instead of just display code (Separate Domain from Presentation); a single class has accumulated so many conditional statements that every new case requires editing the same class in multiple places (Extract Hierarchy). Applies when code-smell-diagnosis has surfaced Parallel Inheritance Hierarchies, Data Class, or Large Class with deep conditional branching and the fix is too large for a single refactoring session. Distingu

crestapps Skill

Skill for using SQL-based content indexing in Orchard Core. Covers content item indexing tables, field indexing tables, database schema reference, querying indexed data with C#, Razor views, Liquid templates, and GraphQL, and SQL indexing performance patterns. Use this skill when requests mention Orchard Core SQL Indexing, Query SQL-Indexed Content, Enabling SQL Field Indexing, ContentItemIndex Schema, LocalizedContentItemIndex Schema, Content Field Index Tables, or closely related Orchard Core implementation, setup, extension, or troubleshooting work. Strong matches include work with OrchardCore.ContentFields.Indexing.SQL, OrchardCore.ContentManagement, ContentItemIndex, ISession, LocalizedContentItemIndex, ContentPart, ContentField, BooleanFieldIndex, ContentPickerFieldIndex. It also helps with LocalizedContentItemIndex Schema, Content Field Index Tables, Querying from C#, plus the code patterns, admin flows, recipe steps, and referenced examples captured in this skill.

bookforge-ai Skill

Add scarcity and urgency layers to a completed offer to increase conversion rate and perceived value without changing the offer itself. Use this skill when you have a defined offer but conversion is sluggish, when prospects say "I'll think about it" or "maybe later," when you are launching a promotion and need a legitimate reason to act now, or when you want to build pent-up demand between sales cycles. Scarcity limits quantity (how many can buy); urgency limits time (when they can buy). Used together they create the psychological conditions where action now is more compelling than waiting. Trigger phrases: "how do I get people to buy now", "how do I stop prospects from procrastinating", "add urgency to my offer", "create scarcity for my service", "how do I run a limited-time offer", "set up a launch deadline", "get more people off the fence", "use fear of missing out", "make my offer feel exclusive", "why aren't people buying after the call", "how do I fill my cohort faster", "people keep saying they'll thin

crestapps Skill

Skill for adding the MiniProfiler performance widget to Orchard Core front-end and admin pages. Covers enabling the feature, permissions, database connection profiling, and shape rendering timings. Use this skill when requests mention Orchard Core Mini Profiler, MiniProfiler, performance profiling, request timings, SQL query profiling, slow page diagnosis, or closely related Orchard Core implementation, setup, extension, or troubleshooting work. Strong matches include work with OrchardCore.MiniProfiler, MiniProfilerFilter, MiniProfilerConnectionFactory, CurrentDbProfiler, ShapeStep, ViewMiniProfilerOnFrontEnd, and ViewMiniProfilerOnBackEnd permissions. It also helps with diagnosing slow shapes, profiling YesSql database calls, and the configuration patterns captured in this skill.

crestapps Skill

Skill for building and using the CrestApps OrchardCore Reports framework. Covers report contracts, admin report pages, date range filters, metric and table documents, charts, CSV and OpenXml exports, permissions, custom filters, and report registration. Use this skill when requests mention CrestApps.OrchardCore.Reports, IReport, ReportDocument, IReportExportFormat, or related reporting implementation and troubleshooting.

crestapps Skill

Skill for the CrestApps Orchard Core AI Agent module that provides 50+ natural-language AI tools for managing an Orchard Core site. Covers content management, content definitions, feature toggling, tenant management, recipe execution, user and role lookup, workflow management, email/SMS/notification sending, AI profile inspection, and chat analytics. Use this skill when requests mention AI Agent tools, natural language site management, CrestApps.OrchardCore.AI.Agent, AI-powered content operations, or closely related Orchard Core AI tool integration and troubleshooting work. Strong matches include searchForContentItems, createOrUpdateContentItem, importOrchardCoreRecipe, createTenant, enableSiteFeature, sendEmail, sendNotification, listWorkflowTypes, listAIProfiles, queryChatSessionMetrics, and the code patterns, admin flows, recipe steps, and tool categories captured in this skill.

crestapps Skill

Skill for bulk content import and export in Orchard Core using CrestApps Content Transfer. Covers CSV and Excel formats, transfer templates, mappings, background jobs, chunked uploads, filters, custom file-format providers, and content-type transfer settings. Use this skill when requests mention Orchard Core bulk import, bulk export, CSV content transfer, Excel content transfer, spreadsheet mappings, import rows, or closely related Orchard Core implementation, setup, extension, or troubleshooting work. Strong matches include work with CrestApps.OrchardCore.ContentTransfer, CrestApps.OrchardCore.ContentTransfer.OpenXml, IContentImportManager, IContentTransferFileFormatProvider, IContentImportHandler, IContentImportRowFilter, and ContentImportOptions.

crestapps Skill

Skill for configuring AI Chat Session Analytics in Orchard Core with CrestApps modules. Covers session metrics tracking (unique visitors, handle time, containment rate, abandonment rate), dashboard reports (overview, time-of-day, day-of-week, user segments, performance, conversion, feedback), date range and profile filtering, CSV export, and per-profile analytics settings including conversion goals. Use it for CrestApps.OrchardCore.AI.Chat.Analytics, usage analytics, and related Orchard Core setup, extension, or troubleshooting work.

crestapps Skill

Skill for adding PDF and OpenXml text extraction to CrestApps Orchard Core AI Documents. Covers PDF, DOCX, XLSX, PPTX, processor registration, supported file types, upload processing, and extraction troubleshooting. Use this skill when requests mention AI Documents extractors, PDF document processing, OpenXml document processing, document text extraction, or document upload formats. Strong matches include work with CrestApps.OrchardCore.AI.Documents.Pdf, CrestApps.OrchardCore.AI.Documents.OpenXml, AddCoreAIPdfDocumentProcessing, AddCoreAIOpenXmlDocumentProcessing, PdfPig, and DocumentFormat.OpenXml.

crestapps Skill

Skill for verifying and revalidating phone numbers on Orchard Core content items with pluggable providers. Covers provider configuration, PhoneNumberVerificationPart, provider results, revalidation, SQL indexing, queues, and Omnichannel contact integration. Use this skill when requests mention Orchard Core phone verification, phone validation APIs, verification queues, or revalidating contact numbers. Strong matches include work with CrestApps.OrchardCore.PhoneNumbers.Verifications, IPhoneNumberVerificationManager, IPhoneNumberVerificationProvider, PhoneNumberVerificationPart, PhoneNumberVerificationResult, and PhoneNumberRevalidationBackgroundTask.

oimiragieo Bundle

Distributed computing for larger-than-RAM pandas/NumPy workflows. Use when you need to scale existing pandas/NumPy code beyond memory or across clusters. Best for parallel file processing, distributed ML, integration with existing pandas code. For out-of-core analytics on single machine use vaex; for in-memory speed use polars.

oimiragieo Bundle

Use this skill for processing and analyzing large tabular datasets (billions of rows) that exceed available RAM. Vaex excels at out-of-core DataFrame operations, lazy evaluation, fast aggregations, efficient visualization of big data, and machine learning on large datasets. Apply when users need to work with large CSV/HDF5/Arrow/Parquet files, perform fast statistics on massive datasets, create visualizations of big data, or build ML pipelines that do not fit in memory.

oimiragieo Bundle

Focuses on pandas-specific rules for data manipulation, including method chaining, data selection using loc/iloc, and groupby operations.

oimiragieo Bundle

Parse FCS (Flow Cytometry Standard) files v2.0-3.1. Extract events as NumPy arrays, read metadata/channels, convert to CSV/DataFrame, for flow cytometry data preprocessing.

oimiragieo Bundle

Fast in-memory DataFrame library for datasets that fit in RAM. Use when pandas is too slow but data still fits in memory. Lazy evaluation, parallel execution, Apache Arrow backend. Best for 1-100GB datasets, ETL pipelines, faster pandas replacement. For larger-than-RAM data use dask or vaex.

gptomics Bundle

Filters germline and somatic variant callsets at the site and genotype level with GATK VQSR (VQSLOD, truth-sensitivity tranches), VETS/ScoreVariantAnnotations, NVScoreVariants, hard filters with per-annotation thresholds, and bcftools/cyvcf2 expressions, plus Ti/Tv-based QC. Use when deciding between VQSR, hard filtering, and ML recalibration by cohort size and platform, setting SNP vs indel thresholds, replicating the missing-annotation-passes rule so hom-alt sites survive, applying genotype-level GQ/DP filters, or validating filter impact. Not for VCF normalization (see variant-calling/variant-normalization) or summary statistics (see variant-calling/vcf-statistics).

g1joshi Skill

SQL database queries, joins, aggregations, subqueries, and optimization. Use for .sql files and database operations.

aradotso-trending-skills Skill

Terminal-based spreadsheet TUI tool written in Go for editing CSV files in the terminal with vim-like keybindings

oimiragieo Bundle

Statistical visualization with pandas integration. Use for quick exploration of distributions, relationships, and categorical comparisons with attractive defaults. Best for box plots, violin plots, pair plots, heatmaps. Built on matplotlib. For interactive plots use plotly; for publication styling use scientific-visualization.

aradotso-trending-skills Skill

Local token cost analytics dashboard for Claude Code sessions — reads JSONL transcripts and provides per-prompt cost breakdowns, heatmaps, and usage insights.

gptomics Bundle

Compare cell-type composition and spatial features across conditions in IMC/MIBI cohorts with the patient as the experimental unit, covering pseudoreplication, per-patient aggregation, mixed models, compositional (Dirichlet/scCODA) differential abundance, diffcyt, per-image-to-patient spatial differential testing (SpaceANOVA), batch covariates, and FDR. Use when testing whether a cell type or spatial niche differs between groups, avoiding cell-level pseudoreplication, choosing a differential-abundance method, or correctly powering an IMC cohort comparison.

oimiragieo Bundle

Excel spreadsheet generation using openpyxl and xlsxwriter. Convert Claude output, data analysis results, and tabular data into formatted .xlsx files with charts, formulas, conditional formatting, and multiple sheets. Use for generating Excel reports programmatically.

g1joshi Skill

DuckDB analytical database for OLAP workloads. Use for embedded analytics.

g1joshi Skill

Oracle Database with PL/SQL, RAC, and enterprise features. Use for enterprise systems.