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.
-
masx200 Bundle Tencent Docs腾讯文档,提供完整的腾讯文档操作能力。当用户需要操作腾讯文档时使用此skill,包括:(1) 创建各类在线文档(智能文档、Word、Excel、幻灯片、思维导图、流程图)(2) 查询、搜索文档空间与文件 (3) 管理空间节点、文件夹结构 (4) 读取文档内容 (5) 编辑操作智能表 (6)编辑操作智能文档。
-
simplified-reasoning Skill Local File GroundingUse when the task must read or write local task materials such as txt, md, csv, json, svg, or output files, and the response should be grounded in those files rather than generic knowledge.
-
ait426 Bundle CSV To ChartCSV to Chart — Skill Instructions
-
ait426 Bundle Data CleanerCSV Data Cleaner — Skill Instructions
-
comol Bundle Img Grid AnalysisOverlay a numbered grid on an image to determine column proportions for layout generation. Use when creating MXL spreadsheet layouts from screenshots or scanned print forms.
-
comol Bundle 1c Metadata Manage1C metadata management — create, edit, validate, and remove configuration objects (catalogs, documents, registers, enums), managed forms, data composition schemas (SKD), spreadsheet layouts (MXL), roles, external processors (EPF/ERF), extensions (CFE), configurations (CF), databases, subsystems, command interfaces, templates. Use when working with 1C metadata structure.
-
mifunedev Bundle Post BridgeInteract with the Post Bridge social media post management API. Use when the user wants to publish posts, upload media, manage social accounts, schedule content, or retrieve analytics via the Post Bridge platform. Triggers on: post to instagram, upload media to post bridge, schedule a social post, list social accounts, create a post, publish video, post bridge api.
-
team-commonly Bundle 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.
-
team-commonly Skill Officecli XLSXUse this skill any time a .xlsx file is involved -- as input, output, or both. This includes: creating spreadsheets, financial models, dashboards, or trackers; reading, parsing, or extracting data from any .xlsx file; editing, modifying, or updating existing workbooks; working with formulas, charts, pivot tables, or templates; importing CSV/TSV data into Excel format. Trigger whenever the user mentions 'spreadsheet', 'workbook', 'Excel', 'financial model', 'tracker', 'dashboard', or references a .xlsx/.csv filename.
-
team-commonly Skill Officecli Data DashboardUse this skill to build a multi-element Excel dashboard — Dashboard sheet on open, multiple formula-driven KPI cards, multiple charts, sparklines, and conditional formatting — from CSV or tabular input. Trigger on: 'dashboard', 'KPI dashboard', 'analytics dashboard', 'executive dashboard', 'metrics dashboard', 'CSV to dashboard', 'data visualization'. Output is a single .xlsx. Scene-layer on officecli-xlsx: inherits every xlsx hard rule. DO NOT invoke for: a single budget tracker / one-sheet CSV-with-formatting (use xlsx), a 3-statement / DCF / LBO financial model (use financial-model), a weekly report with ≤ 1 chart and < 10 rows (use xlsx).
-
team-commonly Skill Officecli Financial ModelUse this skill when the user wants to build a financial model — 3-statement model, DCF valuation, LBO, SaaS unit economics, sensitivity / scenario analysis, debt schedule, or fundraising projections — in Excel. Trigger on: 'financial model', '3-statement model', 'P&L + BS + CF', 'DCF', 'WACC', 'NPV', 'terminal value', 'LBO', 'debt schedule', 'cash sweep', 'MOIC', 'IRR / XIRR', 'sensitivity table', 'scenario analysis', 'ARR model', 'unit economics', 'CAC / LTV', 'cap table forecast'. Output is a single formula-driven .xlsx. This skill is a scene layer on top of officecli-xlsx — it inherits every xlsx v2 rule (4-color code, visual floor, number formats, cache-drift, Known Issues, Delivery Gate minimum cycle). DO NOT invoke for a simple budget tracker, CSV dump, or operational KPI sheet — route those to officecli-xlsx base.
-
team-commonly Skill Officecli Commonly TemplatesUse this skill when producing a polished, Commonly-branded deliverable (.docx brief / memo, .xlsx data matrix, .pptx deck) and you do not have specific brand guidance from the user. Trigger on: 'write me a brief', 'one-pager', 'memo', 'data sheet', 'status matrix', 'short deck', 'summary deck', 'closing slide', 'final deliverable'. Routes to `officecli merge` with one of three pre-built starter templates that already carry the Commonly palette, fonts, and structure — so you populate content with one merge call instead of 30 individual `officecli set` commands. DO NOT use for fundraising decks (use `officecli-pitch-deck`), academic papers (use `officecli-academic-paper`), or financial models (use `officecli-financial-model`).
-
taplioofficial Skill Linkedin Viral Post AnalyzerDecode why a specific LinkedIn post performed unusually well. Breaks the post down into hook, structure, format, emotional triggers, timing, and audience match, then produces a reusable template the user can apply to their own content. Requires the Taplio MCP to pull live viral posts to study and fetch the user's own posts and analytics. Use when the user pastes a viral post they want to learn from.
-
afu-it Skill Input ValidationValidate and sanitize all user input to prevent XSS, path traversal, command injection, and malformed data. Covers Zod, Joi, class-validator, Laravel validation, and Python Pydantic. Use when building forms, API endpoints, file uploads, or fixing injection vulnerabilities beyond SQL.
-
afu-it Skill SQL Injection PreventionDetect and fix SQL injection vulnerabilities in any framework. Covers Laravel (DB::raw, whereRaw), Node.js (template literals in queries), Python (f-strings in SQL), and Cloudflare D1. Enforces parameterized bindings everywhere. Use when writing database queries, reviewing code for injection, or fixing SQL injection findings.
-
dotnet Skill TestingImplementation details for EF Core test infrastructure. Use when changing test fixtures, SQL baseline assertions, test helpers, the test class hierarchy, or when adding new tests.
4k -
rodri-oliveira-dev Skill Optimizing Ef Core QueriesUse esta skill para diagnosticar e otimizar queries EF Core neste repositorio .NET com PostgreSQL/Npgsql, incluindo N+1, tracking, projecoes, materializacao prematura, filtros, indices, SQL gerado, alto consumo de banco e armadilhas de performance. Nao use para criar nova camada de acesso a dados ou para trocar EF Core por outra tecnologia sem decisao explicita.
Audited -
santoshkanthety Skill Databricks Spark SQL MasterySpark SQL & DataFrame API Mastery
-
skforecast Skill Baseline ForecastingBuilds and evaluates simple baseline forecasts with ForecasterEquivalentDate (equivalent-date / seasonal-naive / moving-average) to benchmark machine learning models. Covers offset (int vs pandas DateOffset), n_offsets with agg_func, backtesting a baseline, comparing against ML with MASE, conformal intervals, and grid_search_equivalent_date. Use when the user wants a baseline, a naive or seasonal reference, or to check whether a model beats a simple rule. Not for choosing among ML forecasters (see choosing-a-forecaster) or tuning ML hyperparameters (see hyperparameter-optimization).
-
sunchenzheng Bundle Excel Wind利用 Excel 作为中间层,通过 Wind Excel 插件(WSD/WSS/WSI 等函数)获取万德金融数据。当用户需要获取 Wind 行情数据、财务指标、板块数据,且 Wind Python API 不可用时(权限问题/网络限制),使用本技能通过 Excel+Wind 插件的路径实现数据获取。触发场景:(1)用户要求从 Wind 获取股票/期货/指数的历史行情 K 线;(2)用户要求获取 Wind 财务指标(PE、PB、EPS、ROE 等);(3)用户要求获取宏观/行业数据;(4)Wind Python API 连不上但 Excel 插件可用。
-
sunchenzheng Skill Wind Excel VbaWind Excel插件 & VBA插件 技能手册
-
superdesigndev Skill Google AnalyticsTraps to avoid when querying Google Analytics 4 through treg — cases where the GA4 Data API returns a confident wrong answer instead of an error. Use whenever answering questions about site traffic, visitors, pageviews, channels, conversions, or revenue from GA4.
-
tjxj Bundle Z Md ExcelExtract all Markdown tables from a .md file and export to Excel (.xlsx). Use this skill when the user wants to: convert Markdown tables to Excel, extract tables from .md files, export MD table data to spreadsheet, batch convert multiple tables from one Markdown file. Supports multiple tables, GFM alignment markers, inline Markdown stripping. Each table becomes a separate sheet in the output Excel file.
-
riteshkew Bundle Menza Data AnalystPoint this skill at a CSV and ask natural-language questions — total, average, min, max, top-N, filtered count, and group-by — and get a Markdown answer with supporting tables. Trigger when a user wants to explore or summarise tabular data without writing code.
-
riteshkew Bundle Mousecat Fraud InvestigatorPoint this skill at a transactions CSV and it runs automated fraud hypothesis checks — velocity bursts, structuring, shared-card rings, impossible travel, and round-number automation — then reports flagged transaction IDs with rationale and recommended next steps.
-
riteshkew Bundle Bidflow Electrical EstimatorFrom a plain-English project scope and a price list CSV, produce a structured line-item electrical estimate with material costs, labor hours, markup, and a grand total in valid JSON.
-
riz007 Bundle Aos AuditSecurity audit that checks code against ArchitectOS security rules — auth, input validation, secrets, SQL injection, IDOR, CSRF, XSS, session management, dependency vulnerabilities, and more. Reports HIGH/MEDIUM/LOW findings with risk descriptions and concrete fixes. Use when user asks for a security review, security audit, or to check for vulnerabilities. Always trigger before PRs that touch auth, payments, uploads, or admin functionality.
-
rowankid Skill SQL OptimizeSQL 优化分析技能。分析慢查询、N+1 问题、缺失索引等数据库性能问题,输出优化建议和改写后的 SQL。适用于后端工程师处理数据库性能问题、架构师进行数据库评审。
-
seasonedcc Skill Integration TelemetryThe standard every Discord API operation follows — request and outcome events in the domain's own append-only tables, status derived in SQL behind a named silence window, exhaustive mapped copy with a concrete next action, and no raw vendor text at the owner-facing boundary. Use when adding or changing any Discord call — a message send, a REST backfill, a gateway connection or reconnect, or a health reading — or when adding a skip or failure reason.
-
10cg Bundle Aether ConventionsAether 集群集成规范速查 —— 四域 investigation-first hub。消费方项目在 **Aether 集群**上 手写 dev env / 测试配置 / 连接串时的规范速查点 (#185→#186→#241 同根因三次复发的知识层加固)。 **适用前提: 问题落在 Aether 集群 / Nomad / Consul / 内网 192.168.69.x 语境内。** 回答: "集群内服务连接该用 consul 名还是 IP"、"集群里的 postgres / redis / 内网服务怎么连"、 "集群内服务的 DATABASE_URL / REDIS_URL 该怎么写"、"连集群里的库该用 IP 还是 consul 名"、 "host volume 该注册几个节点 / volume 规范"、"Nomad 上 stateful 服务该怎么配 / 有状态服务 模板规范"、"集群里应用的 DB 密码 / 连接串密码该存哪"、"应用 secret 该存哪"、 "连接串密码能不能硬编码进 HCL"。 **不适用 (缺少集群语境就让位, 不要触发本 skill)**: 与 Aether 集群无关的通用数据库 / 连接串问题 —— 本地或第三方托管 DB 的驱动与客户端用法、连接参数排错、SQL 调优、ORM 配置。 这类问句里出现 "数据库怎么连" / "连接串" / "DATABASE_URL" 等字样**不构成触发条件**: 本 skill 的触发靠的是集群语境, 不是这些裸词。
-
liyown Bundle Progressive Rollout ChecklistUse before merging a change that ships behind a feature flag, kill switch, canary, dark launch, or progressive rollout. Triggers on: feature flag, kill switch, canary, dark launch, progressive delivery, rollout plan, 'how do I ship this safely', 'what's the rollback plan', 'is the flag wired up', 'who is in the canary cohort', sunset, deprecation, rollback. Do NOT use for: finishing a branch (use obra/superpowers finishing-a-development-branch), or for post-incident analysis (use incident-call-trace). Complementary to goal-driven-development, which orchestrates the spec-to-code flow; progressive-rollout-checklist is the pre-ship counterpart that verifies the flag, the cohort, the SLO gate, and the rollback path before the change goes live.
-
marin-community Skill Rl Agentic Job CleanupPreserve and, when authorized, publish a terminal agentic Iris RL run: stop pending retries, select and validate a checkpoint, export model weights, preserve metrics and traces, verify destinations, and only then reclaim storage. Use for runs with an agent harness or per-trial artifacts; use rl-standard-job-cleanup for parquet-only RL.
Audited -
caomeiyouren Skill Database Expert专注于数据库建模、TypeORM 实体定义、迁移管理与 SQL 优化。
Audited -
vanara-agents Bundle SQL Index TuningDiagnose slow SQL queries and add the right indexes without over-indexing — B-tree mechanics, composite ordering (equality-before-range), the leftmost-prefix rule, covering/index-only scans, reading EXPLAIN ANALYZE, selectivity, and write-amplification costs. Worked SQL examples and a runnable index-suggester.
-
warpirate Skill Train VoiceUse BEFORE any writing skill when user wants LinkedIn posts that sound like them rather than generic AI voice. Trigger phrases include "learn my voice," "train on my writing," "match my style," "make it sound like me," "here are my past posts," or when user uploads Shares.csv from LinkedIn data export. Also trigger proactively before first writing-skill use when voice-profile.md does not exist.
Audited -
warpirate Skill Analyze PerformanceUse when user has been posting on LinkedIn at least 4 weeks and wants to know what is landing, run a quarterly content review, or diagnose dropping engagement. Trigger phrases include "analyze my LinkedIn performance," "which of my posts are working," "what should I post more of," "why is my engagement dropping," or when user uploads a LinkedIn analytics CSV.
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 csv_to_chart, data_cleaner, linkedin-viral-post-analyzer. 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.