Data & Analytics

jaechang-hits Bundle

Core Python library for astronomy/astrophysics: units with dimensional analysis, celestial coordinate transforms (ICRS/Galactic/AltAz/FK5), FITS I/O, tables (FITS/HDF5/VOTable/CSV), cosmology (Planck18, distance/age), precise time (UTC/TAI/TT/TDB, Julian, barycentric), WCS pixel-world mapping, model fitting. For general tables use pandas/polars; for radio interferometry use CASA.

jaechang-hits Skill

NCBI GEO access via GEOparse and E-utilities. Search by keyword/organism/platform, download GSE series matrices, parse GPL annotations, extract GSM metadata, load expression matrices into pandas. For single-cell use cellxgene-census; for multi-DB access use gget-genomic-databases.

jaechang-hits Skill

Open-source FAIR biology data framework. Version artifacts (AnnData, DataFrame, Zarr), track lineage, validate via ontologies (Bionty), query datasets. Integrates with Nextflow, Snakemake, W&B, scVI. For scRNA-seq use scanpy; for ontology lookups use bionty.

systempromptio Skill

Deterministically audit and optimise a published documentation page. Runs a 10-section quality audit, applies 5 rewrite rules for structure, terminology, link health, and completeness. Reads website analytics and GSC data per doc URL, produces a 75-point score delta (100 with analytics), commits changes, and updates the per-doc report. Load identity and brand-voice first.

systempromptio Skill

Add or change DB columns in the marketplace extension: update the base schema SQL, write an idempotent migration, register it in schemas.rs, regenerate the sqlx offline cache, and verify local + prod DB match.

jylhis Skill

Run SQL queries against the attached DuckDB database or ad-hoc against files. Accepts raw SQL or natural language questions. Uses DuckDB Friendly SQL idioms.

jylhis Skill

Read any data file (CSV, JSON, Parquet, Avro, Excel, spatial, SQLite) or remote URL (S3, HTTPS). Use when user references a data file, asks "what's in this file", or wants to preview/profile a dataset. Not for source code.

jylhis Skill

Explore and query data on S3, Cloudflare R2, GCS, MinIO, or any S3-compatible storage. Use when the user mentions an s3://, r2://, gs://, or gcs:// URL, asks "what's in this bucket", wants to list remote files, preview remote Parquet/CSV/JSON, or query data on object storage without downloading it. Also triggers when the user wants to know the size, schema, or row count of remote datasets.

jylhis Skill

Convert any data file to another format: CSV, Parquet, JSON, Excel, GeoJSON, and more. Use when the user says "convert to parquet", "save as xlsx", "export as JSON", "make this a CSV", "turn into parquet", or any variation of format-to-format conversion for data files. Also triggers when the user wants to write Parquet, Excel, or other binary formats that Claude cannot produce natively.

peopleforrester Skill

Django security best practices. Covers CSRF, XSS, SQL injection prevention, authentication hardening, Content Security Policy, secrets management, and Django-specific security middleware configuration.

redpanda-data Skill

Analyze hook effectiveness + session retro from collected metrics. Use when user asks to audit hooks, invokes `/hook-audit`, wants to identify silent/over-aggressive/under-enforced hooks, or asks for a retro / team analytics across recent sessions.

serac-labs Skill

Move data in and out of ServiceNow — CSV parsing into import sets, GlideImportSetTransformer runs, CSV/JSON/XML exports, scheduled data sources, bulk update and deleteMultiple safety patterns.

serac-labs Skill

Build ServiceNow transform maps — sys_data_source configurations (CSV/JDBC/REST), sys_transform_map field/reference/script entries, coalesce keys for update-vs-insert, and onBefore/onAfter/onComplete transform scripts.

davidtoby Bundle

飞书云空间（云盘/云存储）：管理 Drive 文件和文件夹，包含上传/下载、创建文件夹、复制/移动/删除、查看元数据、查询权限设置、评论/权限/订阅、标题、版本、飞书文档密级标签（secure labels）和本地文件导入。用户需要整理云盘目录、处理云空间资源 URL/token、判断链接类型/真实 token/标题，或导入 Word/Markdown/Excel/CSV/PPTX/.base 为 docx/sheet/bitable/slides 时使用；doubao.com 云空间 URL/token 也按资源路径和 token 路由，不回退 WebFetch。不负责：文档内容编辑（走 lark-doc）、表格/Base 表内数据操作（走 lark-sheets/lark-base）、知识空间节点/成员管理（走 lark-wiki）、原生 Markdown 文件读写/patch/diff（走 lark-markdown）。

agentii-ai Bundle

Audit spreadsheet, formula error detection, hardcoded cell finder, cross-sheet reference audit, workbook auditor, Excel model audit, financial model QA, spreadsheet review, cell dependency trace, formula integrity check

agentii-ai Bundle

Produce formatted .xlsx financial statement workbooks from XBRL statement data. Uses Bash + openpyxl (Python) following Anthropic FSI xlsx-author conventions for professional Excel output with calculation arc cross-validation.

agentii-ai Bundle

Unit economics analysis, CAC LTV estimation, churn inference, gross margin per unit, customer economics, subscription economics, per-unit profitability, contribution margin, payback period, cohort economics

itallstartedwithaidea Skill

Data Analysis provides a structured framework for statistical analysis using pandas, numpy, and scipy, with visualization through matplotlib, seaborn, and plotly.

leolin990405 Bundle

Complete document processing toolkit - 5 format skills, 3 workflow guides, and 3 templates for PDF, Word, Excel, PowerPoint, and collaborative review.

leolin990405 Bundle

SQL 代码转 Doris ETL Shell 脚本的智能转换工具。用于： (1) 将 SQL 文件或 Markdown 中的 SQL 代码块转换为可执行的 shell 脚本 (2) 智能识别日期粒度（日/周/月）并参数化 dt 分区字段 (3) 自动添加 DELETE 语句实现幂等性 (4) 智能分组 DDL/DML 语句 (5) 生成带执行日志和耗时统计的标准化脚本 触发条件：当用户提到"SQL转脚本"、"生成ETL脚本"、"构建sh脚本"、"把SQL写成脚本"等相关操作时使用。

leolin990405 Bundle

Safe read-only query tool for Doris data warehouse (111.231.70.22:9030). Only SELECT/SHOW/DESCRIBE/EXPLAIN allowed. 60s timeout. No DDL/DML.

leolin990405 Skill

Compatibility wrapper for the legacy PM analytics workflow covering metrics, financial modeling, dashboards, and platform health.

systempromptio Skill

Daily CRM and funnel measurement. Pulls GitHub Traffic API for systemprompt-core and systemprompt-template (14d retention, MUST run daily), website analytics via systemprompt CLI, and external feedback signals. Emits 1d/7d/31d funnel deltas and a dated report. Source of truth for every hypothesis metric.

systempromptio Skill

World-class lead enrichment using 7 data sources: Gmail threads, GitHub profile, web search, company website, email domain analysis, internal CRM cross-reference, and website analytics. Builds a complete picture of who we're selling to.

madappgang Bundle

Harden or review a Bun/TypeScript service — secrets, password and token handling, SQL injection, authn/authz, rate limiting, CORS and security headers, dependency audit. Ships tested guards with measured Bun crypto behaviour.

madappgang Skill

Structured data extraction from web pages — pagination patterns, dynamic SPAs, authenticated scraping, rate limiting, anti-bot handling, JSON/CSV output.

edwinhu Bundle

Use when "query WRDS", "pull SEC filings", "access Compustat/CRSP/ExecuComp/Capital IQ", "Form 4 insider data", "13F institutional ownership (Thomson)", "13D/13G blockholders", "ISS governance/compensation/voting/directors", "proxy advisor recommendations", "TAQ intraday/NBBO", "SDC M&A or new issues", "DealScan syndicated loans", "PitchBook PE/VC deals", "FISD corporate bonds", "municipal bonds / muni trades / MSRB RTRS / SDC municipals", "Form D/ADV", "fund formation", "FJC court data", "linking datasets / join keys (gvkey-permno via CCM, cik-gvkey via wciklink, DealScan-Compustat)", or any WRDS PostgreSQL query or SAS ETL on the WRDS grid (qsub/qsas/SGE).

edwinhu Skill

Use when an EXISTING .docx, .doc, .pptx or .xlsx has to become a PDF or PNG — 'convert docx to pdf', 'docx to pdf', 'render this Word doc', 'word to pdf', 'export docx as pdf', 'make a pdf of this docx', 'pdf from the docx', 'render the document to PDF', 'the PDF has the wrong page count', 'why did the layout reflow'. Use proactively before handing any Word document to a human as a PDF, and INSTEAD OF hand-rolling soffice/libreoffice, even when no one says 'render'. NEGATIVE ROUTING: NOT for editing docx content (use the generic 'docx' skill), NOT for building a docx from markdown (use 'law-review-docx' for Bluebook footnotes or 'law-econ-docx' for author-date), NOT for building one from a Typst source (use 'docx-typst'), NOT for a damaged docx (use 'docx-repair'), NOT for inspecting or diffing individual slides (use 'pptx-render').

serac-labs Skill

Build ServiceNow Performance Analytics — pa_indicators (count/sum/avg/percentage), pa_breakdowns, pa_thresholds with severity colors, pa_widgets, and pa_dashboards for KPI tracking.

timurgaleev Bundle

Pre-landing PR review. Analyzes diff against the base branch for SQL safety, LLM trust boundary violations, conditional side effects, and other structural issues.

xu-jin-cs Bundle

archmap ETL 配置契约报告新鲜度机械闸（2026-08-16 D 域批量开关化，archmap/SKILL.md 模式 D L195 回填约定）：修改 ETL 配置后必须 /archmap sync 重生成契约报告——机械核验 {project}/archmap/etl_rules/ETL

userlg Skill

Optimiza consultas SQL, uso de memoria y latencia del backend. Identifica cuellos de botella y propone soluciones escalables.

epicenterhq Skill

Apply Drizzle ORM patterns for schemas, migrations, queries, branded types, and Postgres or D1 boundaries. Use when working with Drizzle or typed SQL, not raw `bun:sqlite` or non-Drizzle engines.

applicate2628 Bundle

Schema, migration, backfill, ETL/SQL pipelines, watermarks.

practice019 Skill

Office 文档四件套统一入口：Word(.docx) / PDF / Excel(.xlsx,.csv) / PowerPoint(.pptx) 的生成、读取、转换、填写模板与表单。当产物或输入是这四类文档时使用，先按本路由表定位到对应子技能再用 read 打开。Unified router for the office document suite (docx, pdf, xlsx, pptx): generate, read, convert, fill templates and AcroForm. Use whenever the artifact on either side is a Word, PDF, Excel/CSV, or PowerPoint file; route to the matching embedded subskill and read it.

practice019 Bundle

面向产品与业务的定量分析：数据质量检查、指标诊断、KPI 设计与汇报、看板、分析报告、图表、notebook、市场测算。当用户要做数据分析、指标诊断、看板或数据驱动建议时使用。 Use this skill for quantitative product or business analysis: data quality checks, metric diagnostics, KPI design and reporting, dashboards, analytical reports, charts, notebooks, market sizing, semantic layers, and evidence-backed recommendations. Also use it whenever Data Analytics is explicitly invoked.