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.
-
xiaoshuai1024 Bundle Video Analytics多平台运营数据分析——四平台(B站API/抖音·快手XHR拦截/视频号)只读采集自己创作者后台的作品表现数据成增量快照,标准化后做单视频漏斗诊断、抖音流量池落位、横向因子对比、跨平台矩阵,产出「证据→诊断→动作」优化建议与选题关键词反哺 diff。发布视频后看表现、复盘、决定优化方向时调用。
-
xiaoshuai1024 Bundle Wechat Analytics公众号数据分析——mp 后台只读采集(单篇列表/发表记录/详情 cgiData/账号级趋势)成增量快照,标准化后做转化五级漏斗诊断(送达→打开→读完→互动→关注与原文导流)、打开/完读/转化三层分开归因、因子分桶对比与选题反哺建议。发布文章满 48h 回看、复盘公众号表现、决定文章优化方向或选题时调用。
-
ashfulcra Skill Fulcra CSVImport any CSV stream into a Fulcra account as annotations — body weight, mood scores, expenses, sleep, media plays, anything timestamped. Use when the user wants to ingest a CSV they got from somewhere (a wearable, a Pipedream/IFTTT workflow, a hand-rolled spreadsheet) into Fulcra.
-
creanlab Bundle Owasp Input ValidationEnsuring user input is safe from XSS and SQL injection.
-
okwinds Bundle XLSX OfflineExcel 表格离线读写与公式校验:创建/修改 xlsx,保持公式可复算,输出必须零公式错误;附带 LibreOffice 重算与错误扫描脚本(依赖安装可能需要网络)。
-
lftpadilla Bundle Excel XLSXCreate Microsoft Excel .xlsx spreadsheets from tables, CSV/TSV, Markdown tables, or JSON data. Use when the user asks for Excel, spreadsheet, .xlsx, tabla editable, budget, inventory, report table, calculations, or data they need to open/edit in Microsoft Excel.
-
cyijun Skill Audit Xls对财务模型Excel文件做只读结构、公式、勾稽、错误值、硬编码和来源审计。用于交付前复核DCF、可比分析或三表模型;不把文件可打开等同于公式已重算或经济假设正确。
Audited -
cyijun Skill XLSX Author在无已打开Excel会话的无头环境中生成可审计的.xlsx文件。用于三表、DCF、可比公司等需要交付工作簿文件的任务;若有可控的实时Excel会话则优先使用实时工具。
Audited -
cyijun Skill China Model Builder用于为中国A股公司构建或更新DCF、可比分析及三表预测模型,并从带时点和来源元数据的数据生成可审计Excel工作簿时;不用于给出投资建议。
Audited -
peterblazejewicz Skill Integration Testing DotnetTests .NET/C# systems at their integration boundaries — HTTP APIs with `WebApplicationFactory<T>`, EF Core against real databases via Testcontainers (PostgreSQL, SQL Server, Redis), Blazor/Razor Pages in real browsers via `Microsoft.Playwright`, Avalonia UI via `Avalonia.Headless.XUnit`. Works with xUnit v2/v3 on VSTest or Microsoft.Testing.Platform. Use when building or debugging anything that crosses a boundary — HTTP, database, file system, message bus, or UI rendering.
Audited -
impertio-studio Bundle Nextcloud Syntax DatabaseUse when creating database tables, writing migrations, implementing entities and mappers, or building queries. Prevents Oracle column name violations, missing migration version numbering, and raw SQL instead of query builder. Covers migrations with ISchemaWrapper, Entity definitions with auto-generated getters/setters, QBMapper CRUD operations, query builder with joins and expressions, TTransactional trait, column types, and Oracle/Galera constraints. Keywords: ISchemaWrapper, Entity, QBMapper, IQueryBuilder, migration, TTransactional, Oracle, Galera, create table, database migration, entity, mapper, query builder, CRUD, SQL query..
-
masashifukuzawa Skill Structured Text Parsingログ、CSV、JSON、コードなど予測可能な構造化テキストを決定的に解析する。抽出・変換・集計を求められた時に使う。「JSONから抽出」「ログを集計」「CSVを変換して」を正のトリガーとし、入力形式が定義できず意味解釈そのものが必要な曖昧な依頼には使わない。
-
askairo Bundle Excel2sql从 Excel 读取数据并结合 Java Entity 类生成新增 SQL。适用于需要按实体字段落库、批量导入主从数据、并统一审计字段(create_id/create_name/create_by/update_id/update_name/update_by)为 1/admin/超级管理员 的场景。
-
cabbage2000-lab Bundle Paper ImportPaper 题录导入命令(题录整理器 + 题录-草稿一致性核对器)。当用户有从知网/Zotero/EndNote 导出的题录要批量整理、整理参考文献、题录入库、做题录与草稿引用的一致性核对、查哪些草稿引用有对应题录、查题录与草稿字段差异,或说"帮我整理题录""知网题录导入""Zotero 题录处理""参考文献整理""题录核对""题录-草稿一致性""引用管理"时使用——即使用户只说"整理下题录""导入这些文献""核对下引用"也应使用。行为铁律:只整理用户实际导入的真实题录(知网 .ris/.txt、Zotero .ris/.csv/.json 等)、字段缺失标占位、绝不凭记忆补全作者/年份/DOI/标题、不凭空生成题录;一致性核对只客观陈列对应关系(草稿引用→题录 / 题录→草稿引用 / 字段差异)、不判"引用对错"、"无对应题录"不直接判编造(交 /paper-verify 核验);题录入 literature/笔记表.md(五字段标占位请用户或 search 补);确认前零落盘。不编题录、不凭记忆补字段、不替用户判存在性。"帮我编题录凑数""帮我凭记忆补 DOI"走三段式转化。
-
cnife Bundle Audit Hermes Agent SkillsAudit installed Hermes Agent skills for usage frequency and generates an interactive XLSX with Chinese descriptions, dropdown decision columns, and color-coded recommendations. Supports apply mode: reads decisions from XLSX and executes cleanup (delete/disable/enable) after user confirmation, with automatic backup. Smart filtering: already-disabled skills are not re-suggested for cleanup. Uses hermes internal API for authoritative skill classification (builtin/hub/local/external). Use when the user asks about Hermes skill usage statistics, wants to clean up unused Hermes skills, needs to disable low-usage skills, or mentions "技能审计", "清理技能", "不用的技能", "哪些技能可以删", "技能热度", "技能使用频率", "audit hermes skills". This skill is specific to Hermes Agent — do not use for other agents. Make sure to load this skill whenever Hermes skill management, cleanup, or usage analysis is mentioned.
-
daehounan Skill Support RoutingBusiness support specialist routing for customer support operations, analytics reporting, finance tracking, infrastructure maintenance, legal compliance review, and executive summary generation. Use when the user asks about multi-channel support operations, building dashboards and KPI reports, business financial planning and cash flow, system reliability and infrastructure operations, regulatory compliance and legal review, or generating C-suite executive summaries. Triggers on support operations, ticket queue, NPS, CSAT, dashboard, KPI report, analytics report, business financial planning, cash flow, budget, infrastructure maintenance, system reliability, regulatory compliance, legal review, executive summary, board memo.
Audited -
agent-kit-startup Skill SQL PostgresWrite and review Postgres SQL (DDL, DML, indexes, constraints). Use for .sql, schemas, or Postgres mentions.
Audited -
krishagel Bundle XLSXComprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
-
matrixfounder Bundle XLSXUse when the user asks to create, transform, validate, chart, preview, or password-protect Microsoft Excel .xlsx workbooks. Triggers include "csv to xlsx", "recalculate this workbook", "scan formula errors", "add a chart to xlsx", "bar / line / pie chart over a range", "financial model in xlsx", "fix
-
digi4care Bundle Database ArchitectDatabase technology selection and architecture - choose between SQL vs NoSQL, PostgreSQL vs MySQL vs MongoDB, scaling strategies, migration planning. Use for database DECISIONS. For PostgreSQL implementation use postgresql skill.
-
fixmyberlin Skill Add DB Data TableAdd or update a Postgres data.* table via data-schema (spec, verify, load, publish). Import on each environment is data-schema/README.md. Use when processing SQL needs data inside Postgres; not for map tiles/GeoJSON StaticDatasets.
-
hellowind777 Skill Hello Data操作数据库、编写迁移、设计 schema、管理事务、创建索引、使用 Prisma/Sequelize/TypeORM/Mongoose 等 ORM,或执行 SQL/NoSQL 操作时使用。
-
internscience Bundle Reaction Data Extraction从 PDF 文献中提取化学反应数据,特别是反应条件优化信息。支持提取反应物、产物、催化剂、溶剂、温度、时间、产率等,并输出结构化 CSV 文件。使用 MinerU + NLP + 规则匹配进行精确提取。
-
baixuanzhu Bundle Mybatis Plus DevMyBatis-Plus 开发助手。在 Java / Spring Boot 项目中开发任何数据库 增删改查(CRUD)、分页查询、条件查询、Mapper / DAO / Service 层、实体类与表映射、 联表 / 复杂查询写 XML、事务相关功能时使用本技能——无论用户是否提到 MyBatis-Plus (MyBatis-Plus / MyBatis Plus / MP / baomidou / CRUD / pagination / ORM / DAO / entity mapping)。 次级触发信号——代码或 pom 中出现:mybatis-plus-boot-starter、 extends BaseMapper / IService / ServiceImpl、 QueryWrapper / LambdaQueryWrapper / LambdaUpdateWrapper、 @TableName / @TableId / @TableField / @TableLogic、 MybatisPlusInterceptor / MetaObjectHandler、 selectPage / saveBatch / IPage、logic-delete-field / mapper-locations / @DS; 用户任务词或报错出现:分页失效 / total 为 0 / 返回全量、更新后字段没变 / 字段置 null 不生效、 逻辑删除 / 软删除、批量插入 / 批量导入 / saveBatch 慢、乐观锁、创建时间自动填充、 多租户 / 数据权限 / 分表 / 动态表名、雪花 ID / 主键策略、枚举存数据库、联表查询、 事务不回滚、Invalid bound statement (not found)。 依赖含 mybatis-plus-* 或代码出现上述令牌时必须使用;纯 MyBatis、无 ORM 或 ORM 未知, 先询问用户是否引入 MyBatis-Plus 再开发。 不适用于:已使用 JPA / Hibernate 的项目(不建议迁移)、表结构设计 / DDL、纯 SQL 性能调优 (连接池 / 索引 / 慢查询属 DBA 层)。
-
baixuanzhu Bundle Java Coding QualityJava 代码质量与安全的工具化门禁助手。在完成任何 Java / Spring Boot 代码的编写、修改、 重构后,或用户要求提交前检查、代码写完验证、代码审查 / code review、修复扫描告警、 质量门禁、静态扫描、安全扫描(SQL 注入 / 弱加密 / 路径穿越 / XXE / SSRF / 硬编码密钥)时使用本技能—— 无论用户是否提到具体工具(PMD / SpotBugs / FindSecBugs / Java 规约 / lint / static analysis)。 本技能用 JVM 插件链(PMD 7 + 自带规则集、SpotBugs + FindSecBugs)实跑扫描并按严重级修复, 直到 Blocker/Critical 清零才算交付。 完成任意 Java 代码任务后建议激活本技能做交付前门禁。 不适用:非 JVM 语言、纯前端、无 Maven/Gradle 的项目、DDL / 架构设计。
-
alter123-zz Bundle Analytics Dashboard数据看板。业务数据看板生成器。自动搭建KPI监控看板、实时指标追踪、定期自动报告推送 Keywords: 数据看板, dashboard, KPI监控, 业务分析.
-
tokenrhythm Bundle XLSXRead, inspect, edit, or create Microsoft Excel `.xlsx` workbooks, including structured data extraction, formula-aware cell edits, and workbook generation from rows.
-
tokenrhythm Skill Meta Spreadsheet InsightTurn an Excel workbook into business insight: structured read → trend/anomaly summary → write back to a new 'Insights' sheet → persist KPIs to memory.
-
alexxiang2008 Bundle Hlzd Office DocB2B 工业品出口文档生成 v0.1 — 纯 stdlib DOCX 写入 + HLZD 抬头纸 (PI / CI / PL / COA / 合同 / 发票 / 装箱单 / 报价单 / 质检证书 / 抬头模板)。Use when 用户需要生成 B2B 出口单证 (.docx)、填充 HLZD 抬头信息 (公司名 / 地址 / 电话 / 邮箱 / 网址)、把 B2B 调研内容转成客户级 PDF/DOCX 模板。v0.1 仅 stdlib (zipfile + xml),无 libreoffice / pandoc 依赖;PDF/Excel/PPTX 互转 v0.2 加。
-
backspace-shmackspace Skill Input Validation InjectionApply when reviewing or writing code that processes untrusted input, constructs queries or commands, or handles user-supplied data. Covers SQL, LDAP, OS command injection, prototype pollution, and general validation strategy.
Audited -
databrickslabs Bundle Databricks GenieCreate and query Databricks Genie Spaces for natural language SQL exploration. Use when building Genie Spaces, exporting and importing Genie Spaces, migrating Genie Spaces between workspaces or environments, or asking questions via the Genie Conversation API.
-
databrickslabs Bundle Databricks Agent BricksCreate and manage Databricks Agent Bricks: Knowledge Assistants (KA) for document Q&A, Genie Spaces for SQL exploration, and Supervisor Agents (MAS) for multi-agent orchestration. Use when building conversational AI applications on Databricks.
-
databrickslabs Bundle Databricks AI FunctionsUse Databricks built-in AI Functions (ai_classify, ai_extract, ai_summarize, ai_mask, ai_translate, ai_fix_grammar, ai_gen, ai_analyze_sentiment, ai_similarity, ai_parse_document, ai_prep_search, ai_query, ai_forecast) to add AI capabilities directly to SQL and PySpark pipelines without managing model endpoints. Also covers document parsing and building custom RAG pipelines (parse → prep_search → index → query).
-
databrickslabs Bundle Databricks Metric ViewsUnity Catalog metric views: define, create, query, and manage governed business metrics in YAML. Use when building standardized KPIs, revenue metrics, order analytics, or any reusable business metrics that need consistent definitions across teams and tools.
-
databrickslabs Bundle Spark Python Data SourceBuild custom Python data sources for Apache Spark using the PySpark DataSource API — batch and streaming readers/writers for external systems. Use this skill whenever someone wants to connect Spark to an external system (database, API, message queue, custom protocol), build a Spark connector or plugin in Python, implement a DataSourceReader or DataSourceWriter, pull data from or push data to a system via Spark, or work with the PySpark DataSource API in any way. Even if they just say "read from X in Spark" or "write DataFrame to Y" and there's no native connector, this skill applies.
-
databrickslabs Bundle Databricks Aibi DashboardsCreate Databricks AI/BI dashboards. Use when creating, updating, or deploying Lakeview dashboards. CRITICAL: You MUST test ALL SQL queries via execute_sql BEFORE deploying. Follow guidelines strictly.
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 reaction-data-extraction, xlsx, video-analytics. 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.