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.
-
practice019 Bundle Create Data ContextCreate, update, inspect, or repair Data Analytics semantic layers. Use when the user asks to save data context or create a semantic layer that future Data Analytics work can inspect and cite.
-
zaoqu-liu Skill Data AnalysisLoad, analyze, and visualize datasets using pandas with AG Grid display
-
arnie016 Bundle Excel Range RelayBuild or operate a macOS menu-bar relay that turns the current Excel selection into clean markdown, CSV, JSON, or prompt context, with workbook, sheet, and range labels when local Excel metadata is available.
-
jaygptpro Skill Amz Fba PrepPrepare an FBA shipment correctly so it is not rejected, delayed, or charged prep fees at the warehouse. Covers labeling, polybagging, suffocation warnings, bundle and set prep, expiration dating, box weight and dimension limits, and the shipment plan itself. Use when a user asks about FBA prep, shipping inventory to Amazon, labeling units, polybag requirements, prep requirements, a shipment that was rejected, or unplanned prep fees. Trigger phrases: "FBA prep", "ship to Amazon", "FBA labeling", "polybag", "shipment plan", "prep requirements", "shipment rejected". Works with zero tools.
-
jaygptpro Skill Amz Brand RegistryGuide a seller through Amazon Brand Registry enrollment and turn the benefits into action. Covers trademark requirements, the enrollment steps, and how to use Brand Registry tools once approved (A+ Content, Stores, Sponsored Brands, Brand Analytics, Project Zero, Transparency, brand protection). Use when a user asks about Brand Registry, enrolling a brand, trademark requirements for Amazon, protecting a brand, or unlocking brand-only features. Trigger phrases: "brand registry", "enroll my brand", "trademark for amazon", "brand protection", "gated brand features". Works with zero tools.
-
jaygptpro Skill Amz Brand AnalyticsTurn Amazon Brand Analytics reports into decisions. Reads Search Query Performance, Search Catalog Performance, Market Basket, Repeat Purchase, and Top Search Terms exports, and converts them into ranked actions. Use when a user pastes or describes Brand Analytics data, asks about Search Query Performance, SQP, market basket analysis, search frequency rank, click share, conversion share, repeat purchase behavior, or wants to know what their Brand Analytics is telling them. Trigger phrases: "brand analytics", "SQP", "search query performance", "market basket", "click share", "conversion share", "repeat purchase". Works with zero tools. the user pastes the report data.
-
halseyyang Bundle Zotero Review MatrixOrganize Zotero collections and all nested subcollection items, metadata, notes, PDF or EPUB highlights, and annotations into a thematic literature review matrix, CSV, and literature review DOCX with GB/T 7714-2015 references. Use when the user asks to整理 Zotero collection 文献、笔记、高亮、批注, create a literature review matrix, annotated review table, Markdown matrix, CSV export, Word literature review, docx 文献综述, or research synthesis table from Zotero.
-
halseyyang Bundle Invoice Reimbursement发票报销助手。用于处理出差报销相关的 PDF 发票,自动提取金额并分类为车票、住宿费、 打车费,并内置差旅补助标准自动计算城市补贴。生成 Excel 报销汇总表。 触发词:发票报销、报销发票、出差报销、整理发票、reimbursement、报销汇总、 帮我报销、发票识别。
-
halseyyang Bundle CSV Documentation GeneratorUse when generating computer system validation (CSV) documentation for pharmaceutical and medical device industries, including validation plans, URS, FS, IQ/OQ/PQ documents, and traceability matrices.
-
j-star-films-studios Bundle Office DocsUse when creating or editing office documents (PDF, Word DOCX, PowerPoint PPTX, Excel XLSX), or applying Diátaxis/STE technical writing standards ('technical-writing').
-
kai-cli Bundle XLSXExcel file processing. USE WHEN xlsx, Excel, spreadsheet. SkillSearch('xlsx') for docs.
-
pproenca Bundle WhyUse for 'why does X work this way', 'why we picked Y', design rationale, regressions, postmortems, or data-backed thresholds. Discovers available MCPs and queries each evidence category (source control, issue tracker, long-form docs, real-time chat, infrastructure observability, error tracking, product analytics warehouse) in parallel, then returns a cited read on decisions and tradeoffs. Use how for runtime behavior.
-
pproenca Skill Build Golden SetAssemble or improve a golden query set (for search) or golden intent set (for recsys) for offline evaluation of a two-sided marketplace. Use when asking "build me a golden set for search", "add regression cases from last quarter's incidents", "grow our golden set from query logs", "what queries should I test my ranking change against?", "I need an eval set for the similar-listings module", "curate offline eval cases for our homefeed recsys", or "we need a golden set before we can review relevance changes". Pulls candidate queries from the data warehouse query logs, clusters by intent class, adds hand-curated regression cases from the gotchas log, captures must-appear and must-not-appear assertions, records provenance, and writes to golden-set.md in the company's marketplace-context skill. Prerequisite for /marketplace:review-change on any search-branch change.
-
rongxinzy Bundle Minimax XLSXOpen, create, read, analyze, edit, or validate Excel/spreadsheet files (.xlsx, .xlsm, .csv, .tsv). Use when the user asks to create, build, modify, analyze, read, validate, or format any Excel spreadsheet, financial model, pivot table, or tabular data file. Covers: creating new xlsx from scratch, reading and analyzing existing files, editing existing xlsx with zero format loss, formula recalculation and validation, and applying professional financial formatting standards. Triggers on 'spreadsheet', 'Excel', '.xlsx', '.csv', 'pivot table', 'financial model', 'formula', or any request to produce tabular data in Excel format.
-
rongxinzy Bundle SQL Tutor帮助用户编写和优化 SQL 查询,包括将自然语言转换为 SQL、提供查询优化建议以及解读 EXPLAIN 执行计划。当用户需要 SQL 相关帮助时触发,例如直接请求“自然语言转SQL”、“帮我优化这条SQL”、“解释一下这个执行计划”,或提及关键词如 NL2SQL、SQL优化、慢查询、索引建议、全表扫描、SQL调优,以及支持 SQLite 和 PostgreSQL 数据库时。
-
rongxinzy Bundle Code Safety Audit扫描代码安全漏洞,检测依赖漏洞、密钥泄露和OWASP安全模式。当用户提到安全扫描、漏洞检测、依赖审计、密钥泄露、API key、OWASP、npm audit、pip-audit或SQL注入/XSS等关键词时触发。
-
rongxinzy Bundle Database Inspector探索 SQLite 或 PostgreSQL 数据库,执行安全只读查询,提供表列表、详细表结构(列/类型/约束/索引)、数据预览,并生成 Mermaid ER 图。当用户需要查看数据库架构、探索表关系、预览数据、执行只读查询,或提及 schema、ER 图、SQL 查询、数据预览、describe table、数据库探索等关键词时触发。
-
rongxinzy Bundle Regression Insight对 CSV/Excel 数据执行线性回归(OLS)或逻辑回归(Logistic),一键输出完整统计结果(包含回归系数、R²、p值、VIF等)和中文通俗解读。当用户提及回归分析、拟合模型、查看系数显著性、R方、p值、共线性(VIF),或使用关键词如 回归、regression、OLS、logit、拟合、显著性 时触发。
-
rongxinzy Bundle Web Security Audit基于 OWASP Top 10 (2021) 标准提供代码安全审查,逐项检查 SQL 注入、XSS、SSRF、访问控制、加密失败等常见漏洞,并给出具体的漏洞代码示例与修复方案。当用户需要代码安全审查、安全加固、渗透测试辅助,或提及 OWASP、安全检查、SQL 注入、XSS、代码审计、安全清单等关键词时触发此技能。
-
rongxinzy Skill Analytics Report撰写决策导向的分析报告。答案先行、证据支撑、保留事项贴近结论,提供执行摘要、KPI 汇报与深度分析三种结构模板。触发场景:写分析报告、准备汇报材料、输出洞察、构建仪表盘叙事。
-
rongxinzy Bundle Initiating CoverageCreate institutional-quality equity research initiation reports through a 5-task workflow. Tasks must be executed individually with verified prerequisites - (1) company research, (2) financial modeling, (3) valuation analysis, (4) chart generation, (5) final report assembly. Each task produces specific deliverables (markdown docs, Excel models, charts, or DOCX reports). Tasks 3-5 have dependencies on earlier tasks.
-
fudesign2008 Bundle Unbox AnythingUniversal file/container unpacker for AI agents. Use whenever the user has a specific named file that is secretly a container of other files (an installer, document, app bundle, disk image, or any archive) and wants to extract or inspect its inner contents — even when they don't say 'unbox' explicitly. Cracks ~30 'box-like' formats into clean directories with a manifest: standard archives (zip/tar/7z/rar), ZIP containers (docx/xlsx/pptx/jar/apk/whl), system packages (deb/rpm/msi), installers & disk images (exe/dmg/iso/pkg), and chained nested containers. Cross-platform (mac/linux/windows) via 7z as primary tool with graceful fallbacks. Triggers: 「拆箱」「开箱」「解压文件」「拆包」「解压任意文件」「提取容器内容」「拆开[文件]」「看[文件]里面」 / unbox, unpack any file, extract container, what's inside this file. Do NOT use for: writing extraction code/scripts, creating or editing Office documents, installing software, comparing archive formats, or merging files.
-
jaygptpro Skill Amz Reimbursement AuditBuild Amazon FBA reimbursement claims under the 2025 manufacturing-cost policy. Identifies eligible cases (lost units, warehouse-damaged units, customer-return losses, fee errors), assembles the cost-basis evidence Amazon now requires, and produces a claim packet per case within the 60-day window. Use when a user asks about FBA reimbursements, lost inventory claims, warehouse damage, the new reimbursement policy, manufacturing cost evidence, or unrecovered refunds. Trigger phrases: "reimbursement", "FBA claim", "lost inventory", "warehouse damage", "manufacturing cost", "60 day window", "SAFE-T". Works with zero tools. the user pastes the relevant Amazon report rows and supplier invoices.
-
orkas-ai Bundle Office ExcelOffice Excel
-
fdiblen Bundle Rseng Data ManagementCovers research data management around software: organizing and documenting datasets (layout, data dictionaries), keeping data out of git while versioning it properly (DVC, git-annex, DataLad), FAIR data and metadata standards, depositing data with DOIs in repositories such as Zenodo, licensing data, and handling sensitive or personal data. Use PROACTIVELY when a project reads or produces datasets, when the user asks where to put data, how to version or share large files, how to document a dataset, which data license or repository to use, or when data files are about to be committed to a code repository. (Format engineering - HDF5, NetCDF, Parquet, chunking - is rseng-scientific-file-formats; funder data management plans are rseng-data-management-plans.)
-
fdiblen Bundle Rseng Open Source MigrationCovers migrating research code from commercial, license-bound platforms to open source alternatives: MATLAB to Octave or Python/NumPy, IDL to Python, SAS/SPSS/Stata to R or pandas, Mathematica to SymPy/Julia, and the platform-specific pitfalls (indexing, copy semantics, toolbox equivalents, numerical parity). Use when the user wants to leave MATLAB, IDL, SAS, SPSS, Stata, Mathematica, LabVIEW or another proprietary platform, asks for an open or free alternative to commercial scientific software, can no longer afford or access a license, or needs collaborators without licenses to run the code. (The characterization-test safety net and general inherited-code discipline are rseng-legacy-code.)
-
fdiblen Bundle Rseng Scientific File FormatsCovers choosing and handling scientific data formats in code: HDF5 and NetCDF for array data, CF conventions and standard metadata, Parquet for tabular data, domain standards (NeXus and similar), self-describing files, chunking and compression choices, and migrating away from fragile formats like pickles and ad-hoc binaries. Use when the user chooses a file format for research data, reads or writes HDF5/NetCDF/Parquet/zarr-style stores, asks about chunking, compression or metadata embedding, or ships data in CSV, pickle, MAT or homegrown binary formats that deserve scrutiny. (The surrounding data practice - versioning, deposit, licensing, documentation - is rseng-data-management.)
-
mizchi Bundle SQL LintStatic lint for sqlc-style SQL catalogs. Catches duplicate query names, missing semicolons, SELECT *, double-wildcard LIKE, and other cheap-but-easy-to-miss mistakes. Optional sqlfluff integration for full style coverage.
-
mizchi Bundle SQL SecuritySQL injection screening for host code (MoonBit / TS / Rust) plus secretlint setup notes. Flags single-line template-literal or string-concat SQL builders, regardless of value source — the scanner is line-based and does NOT trace data flow, so a clean scan is not proof of safety (multi-line template literals are missed) and every hit needs a manual review or an explicit `// sql-security: ok` opt-out.
-
mizchi Bundle SQL Plan AuditRun EXPLAIN QUERY PLAN against every query in a sqlc-style catalog and diff the plans against a baseline. Detects new full-table SCANs and TEMP B-TREE sort scans introduced by PRs. SQLite/D1-only today; engine extension noted below.
-
mizchi Bundle SQL Schema AuditIndex coverage and N+1 review aids for SQLite/D1 schemas with a sqlc catalog. Surfaces unused indexes (with FK CASCADE awareness so cascade-load-bearing indexes are not flagged), queries that scan tables without index help, and `for`-loops calling generated SQL fns.
-
mizchi Bundle Sqlc Gen Moonbit SafetyPost-generation safety checks for sqlc-gen-moonbit + Cloudflare D1. Use when a MoonBit Worker uses sqlc-gen-moonbit and you need to gate against BigInt-bind hangs (D1 1101) and SQL placeholder mix.
-
servosity Bundle CippFirst single-binary CLI for CIPP - offline SQLite store, fleet posture analytics, and cross-tenant fan-out no other CIPP tool has. Trigger phrases: `check MFA across all my tenants`, `find unused M365 licenses`, `offboard users from a CSV in CIPP`, `which tenants drifted off baseline`, `list CIPP tenants`, `use cipp`, `run cipp-cli`.
-
servosity Bundle ItglueEvery IT Glue resource, plus an offline SQLite mirror, fleet-wide cross-resource search, and documentation-hygiene analytics no other IT Glue tool offers. Trigger phrases: `find this device across all my IT Glue clients`, `which IT Glue organizations are under-documented`, `audit stale passwords in IT Glue`, `sync IT Glue to a local database`, `what changed in IT Glue since last week`, `use itglue`, `run itglue`.
-
ticruz38 Bundle Data ConnectorConnect to Google Sheets, Airtable, and CSV files for data management
-
ticruz38 Bundle File IngestionSecurely ingest structured files (CSV, JSON, XML, Excel) into a database with auto-generated schema via LLM. Use when an agent needs to (1) fetch data from a source (local path, URL, Google Drive, S3), (2) infer table schema from file samples using LLM, (3) create database/table dynamically, and (4) load data with type coercion. Supports secure connections (SSL/TLS) to databases over public domains, Redis caching, and full env-based configuration.
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 create-data-context, data-analysis, excel-range-relay. 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.