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.
-
sswconsulting Skill Setup Admin APISet up and run the SSW.Rewards backend locally — the WebAPI + AdminUI (Blazor) with SQL Server + Azurite, orchestrated by .NET Aspire. Use when someone wants to get the API / Admin UI running, do a first-time backend setup, or troubleshoot `aspire run`. This is the prerequisite for running the mobile app (see setup-mobile).
-
pratiyush Bundle SQL MigrationTurn a Jira ticket into a draft GitLab MR containing a paired forward + rollback SQL migration that follows this repo's conventions. Trigger on phrases like "work <JIRA-KEY>", "create migration for ticket", "draft SQL for <KEY>".
-
pratiyush Skill Reverse EngineerOne-off, operator-run skill that reverse-engineers house coding standards, conventions, and anti-patterns from a repository's git history and GitLab MR discussions, then proposes concrete edits to the sql-migration skill's artifacts. Trigger phrases like "reverse engineer conventions", "mine review comments", "audit the sql-migration flow".
-
pratiyush Skill SQL Conventions MinerOne-time skill to mine the SQL migrations repo's git history and produce draft conventions.md, templates/, examples/, and anti-patterns.md for the sql-migration runtime skill. Trigger phrases like "mine SQL history", "refresh conventions", "bootstrap sql-migration artifacts".
-
quantskills Bundle Build B6 Limitup Pool Production当需要读取涨停池动态管理(B6)的生产结果时,使用此 skill。该 skill 读取已生成的 Parquet 涨停池历史,不重复执行重计算流程。
-
rafeblandford Skill Verifying AI CrawlersWork out which AI crawler traffic in a log or analytics dataset is genuine, and report it honestly. Use when asked how much GPTBot/ClaudeBot/Perplexity traffic a site gets, whether a request claiming to be an AI crawler is real, or when analysing server logs, CDN analytics or bot reports for AI agent activity — and before quoting any figure for AI crawler volume.
Audited -
railcode-hq Bundle Manage Railcode OrgAdminister a Railcode organization through the Railcode CLI. Use for app access and ownership, members and system roles, custom roles and granular grants, saved-query publishing, data connections, service connectors, analytics, and org observability logs. Do not use for building apps or authoring managed-agent manifests.
-
nv-legate Bundle Cupynumeric Parallel Data LoadLoad a sharded, on-disk dataset (sharded .npy, Parquet/Arrow, raw binary, sharded HDF5, custom layouts) into a distributed cuPyNumeric ndarray via a manual partition + leaf @task launch with CPU/OMP/GPU variants. Use when no single-call loader fits, including when per-shard row counts differ across files. Prefer cupynumeric.load or legate.io.hdf5.from_file when they apply.
-
packmindhub Skill Drizzle MigrationsHow to safely add, edit, and verify Drizzle migrations in the skills-observability backend (PostgreSQL + Drizzle ORM). Covers the schema-first generation flow, the strict monotonicity invariant of `_journal.json` `when` timestamps (whose violation has silently skipped migrations in production), idempotent SQL patterns, and how to verify on a fresh DB before merging. Use this skill whenever the user edits `backend/src/db/schema.ts`, runs `bun run migrate:generate` or `bun run migrate:run`, hand-edits anything under `backend/src/db/migrations/` (including `meta/_journal.json`), asks about adding or altering a database column / table / index / constraint, debugs a migration that "didn't apply" or "ran in dev but not prod", or resolves a merge conflict in the migration journal. Trigger this even if the user only mentions a small schema tweak — the journal pitfall is the kind of bug where everything looks fine until production silently diverges, and the right time to apply this guidance is before the schema edit,
-
qiusuo0226 Bundle Job Research Analyst求职信息调研与职业决策分析。凡对公司、岗位、JD、招聘信息的调研/查询/分析,或求职、跳槽、择业决策支持,必须使用本技能;不确定时默认使用、禁止跳过。检索公开来源,整理岗位薪资、公司规模、扩张/收缩信号、员工体验;默认产出公司深度介绍 Word、薪资福利对比 Excel、员工评价与风险 Excel。只产出可核实信息,不编造。典型句式仅提示、不构成边界:查一下这个公司、查下这家公司、看一下这个岗位jd、看下这个JD、看看这个JD、解读JD、分析JD、这个岗位怎么样、这家公司怎么样、值不值得去、值不值得进、帮我调研、调研这家公司、公司调研、跳槽选哪家、对比这几家、这几家怎么选、offer怎么选、薪资多少、工资待遇、年薪多少、福利待遇、员工评价、口碑怎么样、有没有坑、坑不坑、稳不稳定、会不会裁员、投不投、要不要面、面试前调研、入职风险、公司深度介绍、求职调研、职业决策。English triggers: check this company, look at this JD, job description, company research, job research, career decision, salary comparison, compensation and benefits, employee reviews, is this company worth joining, offer comparison, job hopping. Use when the user runs /job-research-analyst.
-
simonw Bundle CSV InsightsSummarize a CSV, compute basic stats, and produce a markdown report + a plot image.
-
xhubio Skill Create Equivalence Class TableCreates formatted Excel files with Nanook tables (decision, matrix, and specification tables) for arbitrary test objects (pages, APIs, forms). Includes color formatting, formulas, correct marker logic, the CASCADE pattern, multiplicity, tags/filters, and 100% coverage. Trigger: "create equivalence class table", "create decision table", "equivalence class table", "test data table", "nanook table", "matrix table", "specification table"
-
xiao24bei Bundle Xiaobei Skill Image To VbaUse when users want XiaoBei skill / xiaobei-skill / 小北在读研 style academic image-to-VBA reconstruction: convert academic figures, scientific diagrams, slides, screenshots, or other images into VBA, Office drawing code, PowerPoint/Excel/Word shapes, editable shape reconstruction, 1:1 recreation, pixel-like approximation, or hybrid editable Office shape reconstruction.
-
dawei12138 Skill Testcase Generator当用户提供需求分析报告或功能描述时触发,基于结构化的需求分析设计全场景手工功能测试用例,覆盖正向、反向、边界、异常四类场景,输出标准化 CSV 文件供测试人员直接使用。这是测试用例生成链的第二环。
-
gusbavia Bundle Fabric App Lakehouse LiveUse when a web app (especially a Fabric App SPA) must read EXISTING Lakehouse data live with no backend — 'query the Lakehouse from the browser', 'live data without a server', 'call Fabric GraphQL from my SPA', or when debugging that path: 403 InsufficientPrivileges on a Fabric GraphQL API, MSAL sign-in returning to a blank page, popup 'tela preta', token works but queries fail, rows silently missing. Read-only by design — the Lakehouse SQL endpoint has no mutations and syncs lazily. If the app writes data back, use fabric-app-sqldb-writeback instead. For creating/deploying the app shell, use fabric-app-bootstrap.
-
haoyuesheng1688 Bundle Wincc Rtpro Manual Vb LoopUse when working with Siemens WinCC RT Professional upper-computer VB scripts in TIA Portal where script import is not exposed or not reliable, especially to generate manual paste files, list only the modified VB sections for the user to fill in, then verify the pasted result, RT Pro script snapshots, SQL/archive/display bindings, and HMI compile until the human-assisted import/export loop is closed.
-
avdlee Bundle Ab Test SetupWhen the user wants to plan, design, or implement an A/B test or experiment. Also use when the user mentions "A/B test," "split test," "experiment," "test this change," "variant copy," "multivariate test," or "hypothesis." For tracking implementation, see analytics-tracking.
-
1821471638 Bundle Fastadmin用于 FastAdmin 后台二次开发、原生目录新增功能、CRUD 生成、数据库字段设计、字段命名规则、关联模型、关联字段显示、菜单权限、控制器、模型、验证器、JS、视图、语言包、SQL、已有源文件修改和插件源文件修改。用户提到 FastAdmin、后台模块、CRUD、php think crud、字段命名、关联表显示、菜单节点、权限节点、后台 JS、插件源文件修改或相关排错时应使用此 skill。
-
1821471638 Bundle Mysql Dev DB用于 Claude Code、Codex 或其他本地 agent 安全连接、检查和操作本地开发 MySQL 数据库。用户提到 MySQL、本地数据库、数据库连接、数据库配置、.env 数据库配置、SQL 文件、执行 SQL、查库、查表、查字段、看表结构、表数据检查、导入 SQL、避免临时 PDO 脚本、优先使用 mysql CLI 或 PyMySQL 兜底时应使用此 skill。
-
listenlove Skill Markitdown当用户提供或引用 PDF、DOCX、PPTX、XLSX 等二进制/办公文档文件时,使用 markitdown_convert_to_markdown 工具将文件转换为 Markdown 格式,以便完整阅读和分析文档内容。转换后基于 Markdown 内容响应用户问题,忽略原文件中的图片(可使用其他模型辅助理解)。
-
manbothq Skill Xlsxsql> Description: SQL-powered spreadsheet analysis skill that enables AI agents to query, transform, and extract structured data from .xlsx and tabular files using standard SQL, with support for multiple input and output formats.
-
opencagedata Bundle Opencage Geocoding APIUse when the user needs to forward geocode (address to coordinates), reverse geocode (coordinates to address), or work with geocoding API responses. Also use when they mention "OpenCage", geocoding rate limits, confidence scores, address components, geocoding a CSV file, or need a geocoding command-line utility or an SDK in Python, Node.js, Ruby, PHP, Java, or Perl.
-
stringnlplab Skill SQL WritingConstruct a SQL query that correctly answers a natural-language question grounded in the actual database.
-
stringnlplab Skill SQL RevisionVerify that a SQL query's actual output faithfully answers the natural-language question.
-
truehooha Bundle Shanxi Securities Tushare使用山西证券 Tushare (sxsc_tushare) 获取专业结构化金融市场历史数据。特点:数据为 T-1 日(无实时行情)、数据规范适合批量处理和导出。触发条件:用户要求获取/拉取/导出/批量取数 tushare、sxsc_tushare、山西证券tushare 数据,或提及历史行情批量拉取、财务报表批量导出、回测数据准备、数据导出 CSV/Parquet、宏观历史数据(CPI/PPI/PMI/社融/利率)、指数成分股、申万/中信行业分类、可转债数据、期货数据、债券数据、历史资金流向、历史K线、涨跌停统计、分红送股、限售解禁、基金净值历史、港股数据、国债收益率、Shibor利率、停复牌信息、沪深股通十大成交股时,或说"拉份数据""导出CSV""批量取数"等。本 skill 只负责取数与数据交付,不负责标的分析;若用户要求对标的进行分析/评估/对比/深度研究,应由 sxsc-tushare-analysis skill 处理。适用场景:历史数据批量获取、回测数据表准备、数据导出。
-
voltagent Bundle Workspace Data AnalystAnalyze CSV files in the workspace and summarize insights.
50.9k -
wenqieric Bundle Document Indexing多源文档(PDF/PPTX/DOC/XLSX/图片)向量化索引与检索。当用户需要把一批文档提取文本、建索引、向量化、建库、检索查询时使用。含扫描页 OCR、TF-IDF 索引、余弦相似度检索。
-
astrbotdevs Bundle SpreadsheetsCreate, read, edit, analyze, convert, chart, and validate spreadsheet files including XLSX, XLSM, XLS, CSV, and TSV. Use when a spreadsheet is a primary input or deliverable, or when tabular data must remain editable and auditable in workbook form.
-
baidu-baige Skill File ProcessingData file processing utilities for CSV, JSON, and text files. Provides helpers for reading, transforming, and validating structured data.
-
brian-a-au Skill Adobe Analytics ConceptsConceptual guidance for Adobe Analytics - explains core concepts (eVars, props, events), helps design tracking approaches, supports analysis workflows, and clarifies admin/governance topics. Does not connect to live data.
Audited -
brian-a-au Skill Customer Journey Analytics ConceptsConceptual guidance for Adobe Customer Journey Analytics (CJA) - explains core concepts (connections, data views, datasets, identity, stitching), helps design data modeling and configuration, supports cross-channel journey analysis, and clarifies governance topics. Does not connect to live data.
Audited -
heshengtao Skill OfficecliCreate, analyze, proofread, and modify Office documents (.docx, .xlsx, .pptx) using the officecli CLI tool. Use when the user wants to create, inspect, check formatting, find issues, add charts, or modify Office documents.
-
flyingtimes Bundle Kpi Analyst根据用户给出的excel文件内容,从中分析kpi指标的情况,并按照分工的列表,分别生成markdown格式的报告
-
ethpandaops Bundle Optimize ModelDeeply optimize a Xatu CBT transformation model query using live ClickHouse evidence. Use when performance analysis is requested for `models/transformations/*.sql`, including dependency rendering, schema introspection (`SHOW CREATE` with `_local` table checks), cache-aware benchmarking, and high-impact recommendations without editing model files.
-
chewcw Bundle Siemens Tia Portal IntegratorOrchestrate data-driven Siemens TIA Portal workflows: read structured data from CSV/Excel files, generate STL/AWL code via the siemens-awl-stl-programmer skill, and apply changes to a live TIA Portal project. Trigger when the user asks to import, generate, sync, or batch-apply PLC blocks, tags, devices, or data blocks from a spreadsheet or CSV source — or to export existing TIA Portal project data into a file.
-
chrisryugj Skill KordocUse this skill whenever the user wants to read, create, fill, edit, compare, validate, or preview Korean Hangul/official documents — .hwp (HWP 3.x/5.x), .hwpx, .hml (HWPML) — or convert Korean-office PDF/DOCX/XLS/XLSX to Markdown. Triggers include any mention of 'hwp', 'hwpx', 'hml', '한글 문서', '아래한글', '한컴', '공문서', '기안문', '보고서를 hwpx로', '서식 채우기', '양식 자동 작성', '신청서 채워줘', '신구대조표', '문서 비교', or uploading/attaching .hwp/.hwpx/.hml files. Also use when generating official Korean documents from Markdown (기안문·보고서·계획서·통지·회의록 presets) or when a HWPX layout preview/verification is needed. Do NOT use for authoring plain Word .docx files (kordoc reads DOCX but generates only HWPX) or for general Korean text with no document file involved.
Audited
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 Workspace Data Analyst, drizzle-migrations, kpi-analyst. 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.