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.
-
otodock Skill File Tools GuideReference for the file-tools MCP — what each document, spreadsheet, PDF and image tool supports, the read/write caps, Excel date and number formats, scanned-PDF and OCR handling, the visual review and mathematics workflows. Load before a document, spreadsheet, PDF or image job.
-
professor-gpt Bundle SQL ExpertAdvanced SQL assistant for writing complex queries, optimizing slow queries, designing schemas, and explaining execution plans.
-
rmazrim Skill Iot Hub Dashboard BuilderSelf-contained IoT hub in the Python stdlib: a TCP JSON pub/sub broker (MQTT-style topic tree with retain flags), a device simulator streaming telemetry, a subscription client, and a threshold rule engine writing alerts + a CSV dashboard feed. Runs entirely on 127.0.0.1 with zero broker installs and zero MCP.
-
rmazrim Skill Pandas Data CleanerGenerate Python Pandas scripts to handle missing values, drop duplicates, and normalize column data types.
-
rmazrim Skill SQL Query OptimizerAnalyze slow SQL queries, recommend indexes, and restructure join clauses.
-
rmazrim Skill Portfolio BacktesterPure-stdlib time-series portfolio backtester: load price history, compute returns, volatility, Sharpe / Sortino ratios, max drawdown, run equal-weight and momentum rebalancing strategies, and emit an equity-curve CSV plus a JSON risk report - zero pandas, zero numpy, zero MCP.
-
rmazrim Skill Schema Drift DetectorCompare SQL migrations, ORM models, and TypeScript types against one another to find which layer is silently out of sync before your queries start breaking.
-
rmazrim Skill Database Zero Downtime MigratorGenerates Expand-and-Contract (Parallel Change) migration SQL as four ordered stage files plus a JSON manifest from a MigrationPlan, emitting Postgres or MySQL dialect output through a Python stdlib argparse module.
-
xu-watermelon Bundle Vocab Reading Coach单词短文陪练助手 (vocabulary reading coach)。帮背单词书(四级/考研/雅思等)的用户: 导入词书文件(PDF/TXT/CSV 自动转 words.jsonl)、按用户进度(以单词定位)生成英文陪练短文、 管理练习记录和拓展词。本 skill 独立于任何平台,脚本路径均相对本 skill 目录。 Use when the user mentions 背单词、单词书、词书、导入词书、PDF 转词库、生成短文/阅读练习、 陪练、复习单词,or uploads a wordbook file (PDF/TXT/CSV/Excel) wanting it converted to a word database, or reports their vocabulary progress like "我背到 abandon 这个词了" / "从 X 词背到 Y 词了". Also use for English reading passages generated from a known word list, vocabulary practice tracking, and wordbook JSONL conversion.
-
steffencarlsen Bundle SpreadsheetsCreate, edit, analyze, and verify standalone spreadsheet files or Google Sheets-ready workbooks, including .xlsx, .xls, .csv, and .tsv. Do not use for live controlling Microsoft Excel app or a live Excel session.
-
steffencarlsen Bundle Spreadsheets 2Create, edit, analyze, and verify standalone spreadsheet files or Google Sheets-ready workbooks, including .xlsx, .xls, .csv, and .tsv. Do not use for live controlling Microsoft Excel app or a live Excel session.
-
steffencarlsen Bundle Spreadsheets 3Use skill when user requests to create, modify, analyze, visualize, or work with spreadsheet files (`.xlsx`, `.xls`, `.csv`, `.tsv`) or Google Sheets with formulas, formatting, charts, tables, and recalculation. Do not use for live controlling Microsoft Excel app or a live Excel session.
-
zxbdzh Bundle Wps Docs灵犀封装了金山云文档能力。若用户指定 *.kdocs.cn/l/xxxx 这类金山云文档链接,相关操作均通过本技能处理。包含以下四大模块: - 云文档基础能力:支持文件信息查询、文件上传与下载。 - 在线表格与智能表格:支持云端创建与编辑在线表格与智能表格,两者共用同一套底层 API。在线表格后缀为 .xlsx,智能表格后缀为 .ksheet。在线表格与智能表格又称ET(即 Electronic Table)。 - 多维表格:面向多维表,提供 Schema 查询、记录读写、字段与各种视图管理能力。多维表格后缀为 .dbt。多维表格又称DbSheet(即 Database Sheet)。 - 智能文档:提供智能文档的创建和修改能力。智能文档后缀为 .otl。智能文档又称AP(即 ActivePage),在使用中也称 otl 文档。
-
steffencarlsen Bundle Excel Live ControlControl an open or active Microsoft Excel workbook through the ChatGPT add-in or connected session. Use when the user tags the Microsoft Excel app in Codex or follows up on an established live Excel task. Do not use for standalone spreadsheet files or Google Sheets.
-
steffencarlsen Bundle Template CreatorCreate or update a reusable personal Codex artifact-template skill. Use when the user invokes $template-creator or asks in natural language to create a template using, from, or based on an attached Word document, PowerPoint presentation, or Excel workbook, or explicitly asks to edit or update a passed artifact-template skill. Do not use for one-off artifact creation from an existing template.
-
steffencarlsen Bundle Template Creator 2Create or update a reusable personal Codex artifact-template skill. Use when the user invokes $template-creator or asks in natural language to create a reusable template from a reference document, presentation, spreadsheet, Google Docs, Slides, or Sheets link, ImageGen or Product Design image, email, Slack message, or Site project, or explicitly asks to edit or update a passed artifact-template skill. Do not use for one-off creation from an existing template.
-
ilog3 Skill Education Paper Type RouterUse after an education research topic and research questions are drafted, or whenever the user is unsure what type of education paper to write. Routes the project to empirical quantitative, qualitative, mixed methods, action research, design-based research, literature review, systematic review, meta-analysis, psychometric scale development, learning analytics, policy/comparative analysis, or program evaluation without exposing internal skill names to the user.
-
ilog3 Skill Education Descriptive StatisticsUse after quantitative education data cleaning to summarize datasets before reliability, validity, inferential, experimental, regression, SEM, multilevel, or learning analytics analysis. Covers means, standard deviations, medians, frequencies, percentages, cross-tabulations, group comparisons, pre/post descriptive summaries, scale/item descriptives, visualization, and APA/education-paper result table wording.
-
ilog3 Skill Education Sampling Data ManagementUse before collecting education research data, or when planning samples, recruitment, participant tracking, school/class/teacher/student data structures, consent, anonymization, data dictionaries, file naming, secure storage, and dataset readiness. This second-layer execution skill supports quantitative, qualitative, mixed-methods, experimental, action research, DBR, program evaluation, psychometric, and learning analytics workflows.
-
ilog3 Skill Education Learning Analytics DesignUse for learning analytics, educational data mining, LMS log analysis, AI platform behavior data, learner modeling, prediction, clustering, sequence mining, early warning, dashboard design, and explainable analytics in education research.
-
ilog3 Skill Education Quantitative Data CleaningUse after quantitative education data are collected and before descriptive, inferential, reliability, validity, SEM, multilevel, or learning analytics analysis. Covers data import checks, data dictionary validation, missing values, invalid values, outliers, duplicate records, participant attrition, variable coding, reverse scoring, scale scoring, group/timepoint coding, dataset versioning, and reproducible cleaning logs.
-
samraddhashrivastavatech Skill MCP RoutingChooses which existing specialist MCP and which software-engineering tools to use. Use at the start of any engineering task and whenever work crosses documents, SQL, Windows, Android, or general code.
-
samraddhashrivastavatech Skill Spreadsheet Research 2spreadsheet-research
-
samraddhashrivastavatech Skill Document ResearchResearch documents including office types — find, fetch, chunk, and retrieve text from PDFs, DOCX, XLSX, and PPTX sources. Use when the evidence lives in a file, not a webpage.
-
samraddhashrivastavatech Skill Spreadsheet ResearchExtract from XLSX/CSV documents — locate spreadsheets and retrieve their tabular content. Use when the evidence is tabular data.
-
orcaqubits Skill Saleor Catalog 2Manage the Saleor catalog — products, variants, product types, categories, collections, media, and warehouse stock. Use when working with Saleor product data.
-
orcaqubits Skill Saleor Channels 2Configure Saleor channels — multi-currency, multi-region, per-channel pricing, warehouse allocation, and multi-brand setups. Use when managing multi-channel commerce.
-
orcaqubits Skill Saleor Shipping 2Configure Saleor shipping — shipping zones, methods (price/weight-based), custom shipping Apps, warehouse-based allocation, and click-and-collect. Use when setting up delivery options.
-
stas2-git Bundle Live Worksheet BuilderUse when a user wants to build or substantially lay out a worksheet in an already-open Excel workbook so they can watch the sheet appear live, including creating tabs, writing blocks of values or formulas, applying formatting, widths, panes, gridlines, and saving without closing Excel.
-
stas2-git Bundle Live Workbook InspectorUse when a workbook is already open in Excel and the workflow needs to inspect the live session state, such as active sheets, ranges, formulas, values, formatting, tables, or named ranges, without rewriting the file on disk.
-
ken3pei Skill Comprehensive Design Reviewこのスキルは、ユーザーが "/comprehensive-design-review" を呼び出したとき、または DB スキーマに対する包括的な設計レビューを依頼したときに使用する。SQL アンチパターンのような局所的・短期的な失敗パターンではなく、正しさ・整合性、長期負債化しやすい設計選択、非機能要件、変更容易性といった横断的・長期的な観点でレビューする。
-
ken3pei Skill Logical Design Antipattern Reviewこのスキルは、ユーザーが "/logical-design-antipattern-review" を呼び出したとき、またはDBの論理設計・テーブル設計のアンチパターンチェックを依頼したときに使用する。SQLアンチパターン本(Bill Karwin著)の第I部に基づき、論理設計の問題点を洗い出す。
-
ken3pei Skill Physical Design Antipattern Reviewこのスキルは、ユーザーが "/physical-design-antipattern-review" を呼び出したとき、またはDBの物理設計・データ型・インデックス設計のアンチパターンチェックを依頼したときに使用する。SQLアンチパターン本(Bill Karwin著)の第II部に基づき、物理設計の問題点を洗い出す。
-
cristianomafrajunior Skill Odoo Module SecuritySecurity review checklist for Odoo modules — access rules, record rules, sudo() usage, controller authentication, SQL injection — split into what standard OCA lint tooling already catches vs. what needs manual review. Use when asked to review, audit, or harden a module's security, or before finishing any module that adds models/controllers.
-
grzmol Bundle Sf Data ManagementMoving records in and out of a Salesforce org - choosing between sObject tree seeding, Bulk API 2.0 and synchronous composite calls by volume, the sf data command surface (import bulk, export bulk, upsert bulk, delete bulk, import tree, export tree, query, resume), external ids and upsert keys, load ordering for parent-child data, Bulk API 2.0 limits and allocations, hard delete and the Recycle Bin, CSV shaping and field caps, scratch org and sandbox seeding, and data-loss safety on destructive schema changes. Use when seeding a scratch org, migrating or backfilling records, writing a data load script, extracting production-shaped test data, or planning a schema change that moves or drops data.
-
stas2-git Bundle SQL RouterUse when any SQL task is requested in an actuarial or insurance context — including writing queries, joining tables, building loss triangles, computing loss ratios, connecting to a database, exploring schema, or executing queries against a live server.
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 file-tools-guide, sql-expert, IoT Hub Dashboard Builder. 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.