Data & Analytics
Data agent skills make AI agents useful for data work: writing SQL, cleaning datasets, building pipelines, working with spreadsheets, and producing analyses. Each skill is a reviewed SKILL.md file that teaches the agent one workflow well, ready to install in seconds.
-
agentscope-ai Skill Bi Cohort Analysis把用户按同一批/同一类分组,比较各群体后续表现。触发条件:对话涉及同期群分析、分群后表现对比、用户生命周期分群跟踪等任务时触发,如出现「同期群」「cohort」「按起始特征分群后表现如何」「不同客群后续转化/留存对比」「注册周/获客渠道分群跟踪」等相似问题时触发。
-
raghuramsirigiri Bundle Sanity CheckCheck a single spreadsheet, deck, PDF or document for internal mistakes before it goes out — totals that don't reconcile or cross-foot, error cells, shares over 100%, duplicated rows, sign errors, stale as-of dates, placeholders left in, mixed units, and a summary that contradicts its own detail — ranked into what blocks sending and what merely invites a question. Use when someone asks whether a file is right, safe to send, consistent, or free of embarrassing errors, or wants it checked, proofed or sense-checked before a board, client or exec sees it. One artifact, not a period comparison.
-
raghuramsirigiri Bundle Whats ChangedCompare two periods of the same report and say what moved, by how much, and which few lines explain the total — ranked, with rate split from volume. Use when the user has this month's and last month's numbers (workbook, CSV, PowerPoint pack, PDF or Word doc) and asks what changed, what's driving it, why revenue or cost moved, or wants month-on-month or quarter-on-quarter variance commentary they can repeat in a meeting. Not a cell-by-cell diff, and it never invents a cause the source doesn't state.
-
campbellsmurphy Skill Food LogLog food the user has eaten into a food-tracking project: read the nutrition panel and scale photos they dropped in the inbox, add the food to data/foods.csv with a composition-database micronutrient proxy, append the serving to data/intake.csv, rebuild the generated log, and file the photos. Use whenever a food or nutrition-label photo appears in the inbox, or when the user says they ate something, asks what was in a meal, or asks about their intake. NOT for recipes they are keeping.
-
minihellboy Skill Factor DataValidate, resample, and ingest market data for factor mining. Schema-checks OHLCV files (CSV/Parquet/HDF5), resamples bar frequencies, and pulls live data from external MCP connectors (FactSet, Daloopa, Morningstar). Use before any mining run. Triggers on "validate data", "check my dataset", "resample", "load market data", "fetch data", "ingest prices", "is this dataset usable".
-
campbellsmurphy Bundle Costco Receipt CaptureCapture Costco (Australia) membership, rewards, order history and warehouse receipts into a markdown area, with one print-to-PDF per receipt and a full index, and mirror the financial-year transactions into a tax folder for review. Use when the user wants to refresh Costco purchase or receipt data, rebuild the Costco area, or pull Costco spending for tax. Drives costco.com.au in a logged-in browser session.
-
zerotokenclaw Skill Calc Analysis SkillsUse when computing, analyzing data, writing Excel formulas, doing statistics, financial models, scientific numerics, or choosing among math/data skills. Trigger on 计算、公式、统计、数据分析、财务模型、SymPy、pandas、numpy、DCF、 算账、单位换算、数值计算。
-
idwong Bundle Feature List从 SRS 需求规格说明书和可行性研究报告中提取并生成功能清单文档,支持导出 xlsx 或 Word 格式。 触发场景:(1) "生成功能清单" "导出功能清单" "功能清单" "功能列表" "feature list", (2) "整理功能清单" "汇总功能" "功能汇总表", (3) 用户需要将 SRS 或可研报告中的功能整理成独立的功能清单文档时触发。 支持从已有文档自动提取,也支持用户手动补充后导出。
-
padosoft Bundle Padosoft Laravel Security ReviewUse this skill before committing or reviewing a change to a Laravel application that touches a model's fillable or guarded, a Blade template printing unescaped, raw SQL, a file upload, a route exempted from CSRF, a shell call, a redirect built from input, an id coming from the request, an audit trail, or an AI/LLM call — and whenever the user asks for a security review or an audit, or says an endpoint returns somebody else's data or an error shows SQL to the user. It runs ten checks with ready pre-screens plus ownership, audit integrity and error-leak rules. Do not use it for API-side (padosoft-api-security-review) or mobile (padosoft-mobile-security-review) work, nor for infrastructure hardening.
-
djolaq Bundle Laravel Blue Team ReviewDefensive (blue team) review of Laravel PHP backend projects. Detect unsafe and non-maintainable practices - SQL injection via raw queries, mass assignment, missing authorization, N+1 queries, unescaped Blade output, committed secrets, insecure config, weak authentication/session handling, unsupported Laravel versions - and produce a severity-ranked remediation report readable by product owners and security engineers. Use when the user asks to audit a Laravel app, review PHP/Laravel code for bad practices, run a defensive security review of a Laravel backend, or get Laravel findings classified by priority. Triggers: laravel, php, blue team, defensive, code review, best practices, vulnerable, vuln, audit, securite.
-
padosoft Bundle Padosoft Logging DisciplineUse this skill whenever code writes to a log or builds an error message for a user — a catch block, an exception handler, a logger call, telemetry, a debug line added while hunting a bug — and whenever the user says a log is noisy or useless, an error message shows SQL or a stack trace, a support ticket contains data it should not, or asks what is safe to log. It gives what must never reach a log or a screen, what to keep so the log stays diagnosable, and where the redaction goes in each stack, which is not the same place. Do not use it to choose a logging library or to configure log shipping, retention or dashboards.
-
padosoft Bundle Padosoft API Security ReviewUse this skill before committing or reviewing any change to an HTTP API that touches routing, auth middleware, settings or config endpoints, logging and telemetry, SQL, error handling, response shaping, client IP, rate limits or an outbound fetch — and whenever the user asks for a security review, an audit, or says an endpoint "seems public", "returns too much" or "leaks something": it runs ten checks with ready grep pre-screens (auth on every mutating route, ownership from the authenticated id, no secrets or PII in responses, bound SQL, fail-safe env gates, resource caps, redacted logs, downstream injection, no trust from caller input, supply chain) and blocks the commit on each violation. Do not use it for infrastructure hardening (WAF, DNS, firewall) or for dependency CVE triage.
-
stbenjam Bundle Unreferenced ReachabilityGenerates styled spreadsheet reports with custom fonts and validates the output against the bundled schema. Use when the user asks for a formatted report file.
-
padosoft Bundle Padosoft Hono API ConventionsUse this skill when writing or reviewing code in a Hono API on Bun — a new endpoint, a middleware, a repository or a SQL query — and whenever the user works on a controller/repository/query layer, types a Hono context, adds a paginated or localized list, or hits a symptom like "the type of c.get is any", "it returns null instead of an empty list", "page 1 skips records", "sometimes the translation is missing" or "the middleware types don't line up": it applies the three-layer architecture, the typed-context and middleware-factory patterns, and the recurring mistakes that cost the most. Do not use it for the security review of an endpoint (padosoft-api-security-review) nor for OpenAPI spec changes.
-
stbenjam Bundle Quarterly ReportBuild the quarterly revenue report from an exported ledger CSV, including the segment breakdown and the year-over-year comparison. Use when someone asks for the quarterly numbers or a board-ready revenue summary.
-
laguagu Bundle CSV RaporttiKäytä kun käyttäjä pyytää myyntilukuja, liikevaihtoa, kuukausiraporttia tai muuta laskentaa /workspace/data-kansion CSV-tiedostoista.
-
liuyanghejerry Skill Security Review通用安全代码审查。检查 SQL 注入、XSS、硬编码密钥、不安全依赖等常见安全问题。
-
liuyanghejerry Skill TS ReviewTypeScript monorepo 审查:XSS、SQL 注入、密钥、any、console.log
-
liuyanghejerry Skill Rust ReviewRust 服务审查:panic、SQL 注入、密钥、错误吞没、遗留标记
-
liuyanghejerry Skill Python ReviewPython 遗留代码审查:bare except、SQL 注入、反序列化、密钥、调试输出
-
liuyanghejerry Skill Security Review 2检查 SQL 注入、XSS、硬编码密钥
-
lingyu9495-source Skill Excel Keep Format Edit客户拿来一张老报表说「就在原表上改个数,格式一点都不要动」——用 openpyxl 重建一次,字体、边框、合并单元格、条件格式、列宽全丢,客户一打开就知道这不是他原来那张表。 正确做法:**用 Excel COM 打开原文件的副本,只改目标单元格的值,其余原样保留。** 这套 skill 解决三个真痛点: - **格式零丢失**:复制原件再改,不重建工作簿 - **别猜行号**:先扫科目名定位实际行列再改(附「资产负债表是左右双栏、科目在 E 列、数值在 G/H 列」这个反复踩的坑) - **改完保勾稽**:财务三表调整后自动校验「资产=负债+所有者权益」,不是改完就交 适用:审计调整分录、财务测算、错账更正、报表科目重分类。 环境:Windows + Office(用 pywin32 调 COM)。 触发词:Excel改数字、保格式修改、原表修改、不动格式、xls修改、财务三表、资产负债表调整、勾稽关系、审计调整。
-
lingyu9495-source Bundle Feasibility Report Engine做可研报告,卡住的往往不是不会写,是**不知道按哪版大纲、财务测算六表和正文对不上、交付前排版被退稿**。这套是从二十多万字、131 张表的真实交付里固化的流水线。 为什么可以信这套: - **大纲判型判错整篇重写**:发改委 2023 大纲政府版 11 章 38 节、企业版 10 章 37 节,两套结构不同,先判型再动笔 - **六表必须全公式联动**:改一个参数不全表重算,表格之间立刻前后矛盾,评审一眼就能看出来 - **排版是退稿高频项**:Word 里图片跨页、表格断行、目录页码不对,都是被退回来的原因,所以交付前有一道体检 怎么做的:判型 → 联网尽调采集 → 财务测算(六表全公式)→ 按大纲成稿 → 专业排版去AI痕 → 多模型视觉验收 → 交付。 输入:项目基础信息、甲方要求、可拿到的公开数据 输出:可研报告 Word 成稿 + Excel 六表测算套表(改参数自动重算)+ 说明文档 触发词:可研报告、可行性研究报告、可行性研究、立项报告、项目建议书、发改委大纲、财务测算、六表勾稽、融资可研、政府可研、企业可研、报告排版。
-
dprakash2101 Bundle Relational Database DotnetImplement or review relational database access from .NET for PostgreSQL or Oracle. Use for ADO.NET/provider SQL, connections, transactions, commands, provider-specific mapping, or database retry decisions; compose with ef-core-safety when EF Core behavior is involved.
-
techflag Bundle Retail Analysis AcceptanceAnalyze synthetic retail CSV metrics, reconcile store totals and produce auditable reports. Use for the retail analysis acceptance task.
-
techflag Bundle Workdsh Excel Design设计、分析或审查 Excel 工作簿时确定字段、来源、真实布局、公式和可用性;能力取决于当前可用表格工具,不宣称支持完整新建或高级图表。
-
njh20030605-code Skill Vn Kans ScriptVN KANS话术 —— 越南 TikTok 韩束(KANS)直播间循环话术的写作、改写、手卡配牌与物料诊断。当用户要写/改越南直播间话术、调整段落顺序或优先级、把手卡(POSM / INFO BOARD / 主图价格卡)配到话术旁边、判断物料是红系抗老还是白系美白、诊断缺哪些手卡、或生成带手卡图的话术 xlsx 和可打印手卡 PDF 时使用。用户说「VN KANS话术」「越南直播间话术」「一轮话术」「手卡对应话术」「配手卡」「话术改写」「越南运营话术提取」时都要用。也用于核对越南市场价格/赠品/成分口径是否用错(尤其 1,427K 白系 vs 1,347K 红系这类混淆)。
-
njh20030605-code Bundle Kans Vn Weekly FlowKANS 越南 SKINCARE 直播间【周报 / 月报复盘全流程】半自动编排器。当用户用一句话启动复盘(如"开始跑 7月W1 周报 / 这周的复盘 / 把周报写进飞书")时使用。按固定 13 步走:大盘→直播间GMV→相关性→GMV-ROI→退款率→短视频占比→竞品→流量结构→品广→商品卡→单链接→主播三件套→写入飞书。每步缺数据时暂停提示用户去哪个后台导什么,产出 xlsx/png,收尾出 FINAL 粘贴版 md 并用飞书自建应用 API 把标题/高亮块/图片直接写进周会文档。
-
njh20030605-code Bundle Kans Vn Category Competition越南美妆个护类目【竞争格局周报】——从 FastMoss/Kalodata 店铺级导出(Store Name / GMV / Affiliate Video / Self-Account Video / Self-Account Live / Affiliate Live / Shop Tab GMV)做两周对比,输出 6 张标准图 + 人民币口径 xlsx + 可直接进周报的分析结论。当用户粘贴两周(或一周)的店铺 GMV 明细文本/文件,并要求「整理数据 / 做竞品对比 / 渠道结构分析 / 异动品牌 / 市场竞争环境这一节怎么写 / 做图 / 生成周报」时使用。用户只说「这是本周和上周的数据」「跑一下竞争分析」「按老规矩来」也要用。注意与 kans-livestream-charts 的分工:那个处理 KANS 自己直播间的日度数据,这个处理类目级店铺榜单的竞争数据。
-
njh20030605-code Skill Kans Vn High Cost Low Roi Hourly每小时扫描KANS越南GMV Max(商品+直播)当天高成本低ROI素材;每天10点/14点额外扫近7天,输出一个xlsx按当天/近7天分sheet。当用户要求跑"KANS 高成本低ROI素材预警 / GMV Max 低效高耗素材扫描"或将其设为定时任务时使用。
-
njh20030605-code Skill Tiktok Creative Id To Creator在 TikTok Shop 卖家后台「创意作品」(ads-creation/manage-analyze) 页面,用 Claude in Chrome 批量把一批已知的素材/作品ID(作品ID / creative_id)反查成对应的达人用户名,并去重、导出本地 CSV。当用户给出一批作品ID/素材ID 并要求"查出这些素材是哪些达人发的 / 爬达人ID / 素材ID换用户名 / 批量反查达人用户名"时使用。核心是走搜索框的「作品ID 包含任一项」批量过滤器(一次最多400个),而不是逐页翻 38000+ 条表格。
-
archmax-ai Bundle Microsoft Office DocumentsFill in and edit Word, Excel and PowerPoint files — letters, spreadsheets and slide decks — starting from an existing template. Read this before creating or changing any DOCX, XLSX or PPTX file.
-
latticecast Bundle Developing DB SQLSQL writing — INSERT, UPSERT, indexing, JSONB. Use when writing or reviewing SQL statements, migrations, or schema changes.
-
abdulyasir100 Skill Hugging Face DatasetsCreate and manage datasets on Hugging Face Hub. Supports initializing repos, defining configs/system prompts, streaming row updates, and SQL-based dataset querying/transformation. Designed to work alongside HF MCP server for comprehensive dataset workflows.
-
nervous0403 Bundle Dingtalk Aitable钉钉 AI 表格(多维表)。Use when 用户说 AI表格/多维表/数据表/base/table/建表/查记录/写数据/字段/记录增删改查/筛选/排序/公式/模板搜索/批量导入CSV或JSON/导出/仪表盘/图表/上传附件到表格/按字段类型建表/数据源/创建数据源/更新数据源配置/触发数据源同步/按任务 ID 查询同步状态/获取数据源配置/列出数据源可用来源/获取数据源可同步字段/审批数据同步。不做电子表格单元格读写(走 dingtalk-misc)、文档编辑(走 dingtalk-doc);听记待办入表先用 dingtalk-minutes 提取,再由本 skill 写入。命令前缀:dws aitable。
-
jin-bo Skill Duckdb AnalystUse for any analytical question over ./data/*.parquet. Prefer DuckDB, always show the SQL.
Frequently asked questions
What are Data & Analytics agent skills?
Data agent skills make AI agents useful for data work: writing SQL, cleaning datasets, building pipelines, working with spreadsheets, and producing analyses. Each skill is a reviewed SKILL.md file that teaches the agent one workflow well, ready to install in seconds.
Which Data & Analytics skills are most installed?
Popular Data & Analytics skills on SkillMD right now include bi-cohort-analysis, sanity-check, whats-changed. Rankings shift as installs change; sort this page by "Most installs" for the live list.
Do Data & Analytics skills work with Claude Code and Cursor?
Yes. Every skill here ships as a SKILL.md file, an open format that works in Claude Code, Claude.ai, Cursor, Codex, Windsurf, and 60+ other agents. Install one with npx skillmds@latest add <owner>/<name>, or copy the file into your agent's skills directory.