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.
-
nandanosql Skill Finance Metrics QuickrefQuick-reference guide for essential finance and business metrics every PM should know — margin, burn rate, runway, revenue recognition, and financial statement basics.
-
nandanosql Skill Metrics Dashboard DesignDesign an actionable product analytics dashboard — choosing the right metrics, layout hierarchy, alerts, and refresh cadence so the team uses it daily, not once.
-
nandanosql Skill Data Storytelling AdvisorTransform raw data and charts into compelling narratives — using the Situation-Complication-Resolution framework to make data actionable and persuasive for stakeholders.
-
nandanosql Skill Business Health DiagnosticRun a comprehensive business health check across revenue, unit economics, product metrics, and market position — identifying strengths, weaknesses, and the single most important metric to fix.
-
the-utopia-studio Skill Monitoring SetupConfigures error tracking (Sentry), product analytics (PostHog), health monitoring, and alerting. Provides verification commands and concrete output templates. Use when the user asks to "set up monitoring", "add error tracking", "configure Sentry", "add analytics", or "set up alerts". Don't use for deployment (use deployment-engineer), security (use security-auditor), or integration linking (use integration-linker).
-
gongyijie85 Skill Django SecurityDjango security best practices, authentication, authorization, CSRF protection, SQL injection prevention, XSS prevention, and secure deployment configurations. Use when reviewing Django authentication, authorization, input handling, or deployment settings.
-
kody-w Bundle Chart BuilderUse this skill whenever the user asks to visualize, chart, plot, or graph data (bar, line, scatter, histogram, pie) from a CSV, table, or DataFrame. It gives the agent prebuilt, parameterized matplotlib functions so charts are produced faster and more reliably — with consistent styling and sane defaults — instead of hand-writing matplotlib each time.
-
kody-w Bundle Acroform WriterUse this skill whenever the user wants values written INTO an existing PDF form that lives in the connected SharePoint knowledge source — filling out, completing, populating, or submitting a fillable PDF (application, intake sheet, contract, government form) from data they supply, a spreadsheet row, or the conversation. Triggers include "fill out the job application form", "complete the intake form for [person]", "populate our standard NDA template", and "make this ready to send / non-editable" (flatten). The source form should be found via knowledge search; only ask the user to upload it if knowledge search turns up nothing plausible. different task), and do NOT use it on scanned/image-only PDFs that have no real fillable fields — those need OCR or manual overlay instead, which this skill explicitly detects and reports rather than silently failing.
-
kody-w Bundle Phi DeidentifierUse this skill whenever the user asks to de-identify, redact, anonymise, scrub, or remove PHI/PII from clinical text, notes, transcripts, or documents before sharing, exporting, or using them for analytics, testing, or demos — e.g. "de-identify this note", "strip patient info", "make this HIPAA Safe Harbor compliant", "produce a limited data set". It removes the 18 HIPAA Safe Harbor identifiers and emits an audit manifest of what was removed. Run the bundled scripts/deidentify.py — do NOT hand-write redaction regexes yourself. This skill prepares de-identified text and an audit trail for human review; it does NOT certify legal compliance or make a formal expert determination.
-
kody-w Bundle What To Use WhenRun this FIRST, before ANY thinking, retrieval, task creation, or file generation, for any single-output task a free M365 Copilot can do; if action-bias pushes you to start, STOP and run this first. Fires on: "summarize my email/inbox/unread", "summarize my meetings", "summarize my Teams messages" (any window, e.g. "last 5 weeks"); "catch me up" / "what did I miss"; a single question or lookup: "how do I", "why", "when is", "what is", "who is", "are we", "do we", "is it", any billing/pricing/licensing question, calendar/contact lookups; "draft a doc" or memo; "create a presentation", deck, or spreadsheet; "research competitors"; "analyze this data". GUIDE the user to the matching free 1P agent (Copilot Chat; Word/Excel/PowerPoint; Researcher; Analyst), not Cowork; use it only if they insist. Do NOT fire for DIRECT ACTIONS (send email, schedule a meeting, post to Teams, create an event), long-running or multi-output jobs, or managing skills.
-
kody-w Bundle Iterative File EditingUse this skill whenever you create or edit ANY file for the user in the Copilot Studio container — a document, spreadsheet, slide deck, code file, data export, anything. It keeps your work-in-progress durable and shows the user an updated version after every change, so the two of you refine the same file together across turns — the user sees real progress each round, earlier work is never lost, and neither of you has to start over. Apply it from the very first file you make.
-
kody-w Bundle PDF Table Data ConversionUse this skill whenever the user wants tabular data from a PDF document AS A FILE — to extract, pull out, export, convert, or "put into a spreadsheet/Excel/CSV" (e.g. "pull out the rebates from the Contoso contract", "extract this pricing table", "get this into a spreadsheet"). This INCLUDES follow-up requests after you have already answered or summarized the data in chat — e.g. "now give me that as a file/spreadsheet", "export what you just showed me", "download that as Excel". In those follow-ups you MUST still invoke this skill and extract from the source document; never hand-build a spreadsheet from the chat summary. Do NOT use this skill for answer-in-line questions such as "what are the rebates in the Contoso contract?" — those are grounded Q&A.
-
broomva Bundle Investment ManagementInvestment management skill — portfolio construction, analysis, and execution. Compounds finance-substrate (accounting/tax) + wealth-management (projections/goals) into a full financial framework. Covers traditional investing (stocks, ETFs, bonds), alternatives (crypto, prediction markets, real estate, VC), quantitative analytics (factor models, Monte Carlo, optimization), and platform integration (Alpaca, Coinbase, Polymarket, agent-browser for Colombian platforms). Embodies philosophies from Buffett, Dalio, Bogle, Munger, and Marks. Use when: (1) building or analyzing a portfolio, (2) screening stocks/ETFs/crypto, (3) running backtests or factor analysis, (4) executing trades or rebalancing, (5) tracking investments across platforms, (6) researching market data or fundamentals, (7) making investment decisions with structured frameworks. Triggers on 'investment', 'portfolio', 'stocks', 'ETF', 'bonds', 'crypto', 'trading', 'backtest', 'factor model', 'rebalance', 'Polymarket', 'Alpaca', 'asset allocation'.
-
nandanosql Skill Cohort AnalysisBuild cohort-based analyses to understand how user behavior changes over time. Covers signup cohorts, behavioral cohorts, acquisition cohorts, and retention curves.
-
stuffbucket Bundle Tauri Plugins SQLUse when wiring a real database into a Tauri v2 app — SQLite / MySQL / Postgres via `sqlx`, `Database.load("sqlite:db.sqlite")`, `execute()` vs `select()`, the per-DB placeholder syntax (`$1` for SQLite/Postgres, `?` for MySQL), migrations registered in Rust with `Builder::default().add_migrations(...)`, the `sqlite-bundled` Cargo feature, and mobile considerations.
-
stuffbucket Bundle Tauri Plugins StoreUse when persisting key-value settings or small JSON state in a Tauri v2 app — `Store::load(app, "settings.json")` / `app.store(...)` in Rust, `load()`/`get()`/`set()`/`save()`/`has()`/`delete()`/`clear()` in JS, `autoSave` debounce, file location under `app_data_dir`, the JSON-only constraint, and when to reach for `tauri-plugin-sql` instead.
-
equinor Skill Neqsim Technical Document ReadingReads and extracts structured engineering data from technical documents (PDFs, Word, Excel, CSV) and engineering images/drawings (P&IDs, vendor datasheets, mechanical arrangements, performance maps). USE WHEN: a user provides engineering documents or images — equipment data sheets, technical requirements, design basis, well test reports, P&ID descriptions, inspection reports, standards, vendor drawings, compressor maps, phase envelopes, material certificates, trapped-liquid fire rupture evidence packs, or water-hammer route/event evidence — and needs structured data for process simulation. Covers document classification, extraction patterns by document type, image/figure analysis with view_image, unit normalization, data quality scoring, and output formats.
-
equinor Skill Neqsim Document Intelligence ExtractionClassify mixed engineering documents and images, route native text/table, OCR, and vision extraction, and produce source-traceable evidence packages with confidence and human-review gates. USE WHEN: a NeqSim task receives PDFs, scans, Word/Excel files, drawings, charts, photographs, or multiple conflicting engineering sources.
-
zjunlp Skill CSV AnalysisUse this skill for CSV data analysis tasks that require reading a local CSV file, checking row counts and columns, grouping records, computing rates or aggregates, creating a chart, and writing a short Markdown report.
-
muhammedadnank Skill Libreoffice CalcSpreadsheet creation, format conversion (ODS/XLSX/CSV), formulas, data automation with LibreOffice Calc.
-
howard-lynn-ye Skill Etf MechanicsWhy an ETF's price series does not behave like the index it tracks - daily-reset leverage, NAV vs price, distributions, holdings files and fees. TRIGGER - "why is my 3x ETF down when the index is flat", TQQQ decay, SQQQ, leveraged ETF long term, inverse ETF, volatility drag, daily reset; premium to NAV, discount to NAV, iNAV, creation/redemption, "bond ETF trading below NAV"; ETF distribution, capital gains distribution, return of capital, "ETF dropped on the ex-date", phantom drop; ETF holdings file, constituents CSV, index reconstitution, Russell rebalance, "I used today's holdings for the backtest"; expense ratio drag, tracking difference vs tracking error, "ETF returned less than the index". SKIP for downloading price series and vendor adjustment defaults (market-data-sourcing) - holdings files stay here, for UNG, USO or VIXY roll yield and contango (futures-continuous-contracts), for auditing a finished backtest (research-integrity-guards), and for weights, Sharpe or drawdown (portfolio-and-risk).
-
howard-lynn-ye Bundle Signal ConstructionCompute technical indicators and engineered features without leaking the future. TRIGGER - RSI, MACD, moving average, Bollinger, ATR, ADX, Ichimoku, PSAR, stochastic or any named technical indicator; TA-Lib, pandas-ta, pandas-ta-classic, ta, talipp, finta; choosing an indicator library or reconciling two that disagree; "does this indicator repaint"; warm-up, unstable period, or an indicator differing between backtest and live; zigzag, fractals, swing highs. SKIP for judging whether a finished signal predicts returns (factor-and-timeseries-research) and for the backtest that consumes it (backtesting-engines).
-
howard-lynn-ye Bundle Market Data EngineeringStore, join and parallelize market data you already hold, without corrupting it. TRIGGER - as-of join, merge_asof, join_asof, ASOF JOIN, "join quotes to trades", aligning signals to prices; reading or writing Parquet, Feather, HDF5 or CSV of market data; choosing between pandas, polars, DuckDB, pyarrow, dask or ray; a time-series store such as ArcticDB, QuestDB, ClickHouse, TimescaleDB or kdb; storing years of minute bars for thousands of tickers; a dataset too big for memory; partitioning; timestamps or timezones coming back wrong; float precision on prices or volume; "different numbers when I parallelise". SKIP for choosing a data VENDOR (market-data-sourcing) - this skill starts once the bytes are yours.
-
howard-lynn-ye Skill Ratings Transitions And MigrationEstimate and use a credit rating transition matrix without producing negative probabilities or a five-year default rate that is five times the wrong number. TRIGGER - rating transition matrix, migration matrix, credit migration, cohort estimator, duration estimator, Aalen-Johansen, Nelson-Aalen generator, matrix power P^5, matrix root, square root of a transition matrix, six-month transition matrix, scipy.linalg.logm, expm, embedding problem, generator of a Markov chain, "negative probability in my transition matrix", "logm gave me a negative off-diagonal", structural zero, AAA never defaults, withdrawn rating, NR, rating withdrawal, notching, cumulative default rate, "5 times the one-year PD", transitionMatrix, pyratings. SKIP for pricing a default probability or a hazard rate (credit-risk-models), for CDS quotes and upfronts (cds-mechanics-and-upfront), for bond spreads (credit-spread-measures), and for regulatory PD floors and Basel calibration (banking-regulatory).
-
dallascrilley Bundle Airtable ManagerAirtable REST API manager for CRUD operations, filtering, upsert, webhooks, and data synchronization. Supports JavaScript SDK, Python SDK (pyairtable), and raw HTTP requests. Handles 30+ field types, rate limiting (5 req/sec per base, 50 req/sec per user), pagination, filterByFormula queries, webhook lifecycle management, CSV sync (10k rows), and enterprise features. USE WHEN: User requests Airtable integration, needs to read/write/sync Airtable data, create automations with Airtable webhooks, build Airtable-backed applications, implement upsert operations, filter records with formulas, handle attachments, manage organization/bases, or debug Airtable API issues. Keywords: airtable api, airtable integration, airtable crud, airtable webhook, filterByFormula, airtable upsert, airtable sync, pyairtable, airtable.js, personal access token, airtable rate limit, airtable pagination, linked records, airtable attachments, airtable enterprise
-
braxtonrose4 Bundle Memento FlashcardsSpaced-repetition flashcard system. Create cards from facts or text, chat with flashcards using free-text answers graded by the agent, generate quizzes from YouTube transcripts, review due cards with adaptive scheduling, and export/import decks as CSV.
-
crawlora-org Bundle Local Business ProspectingBuild and qualify local-business prospect lists by category and geography using Crawlora's Google Maps dataset, live Google Maps, Apple Maps, Yelp, and public business websites. Use when the user wants a deduplicated lead shortlist or CSV with business contacts and qualification evidence.
-
akhilkannur Skill Activation Rate Cohort---
-
kevinaimonster Skill Excel FormulaExcel公式助手。帮用户写Excel和Google Sheets公式,VLOOKUP/SUMIF/数组公式/透视表。当用户说「帮我写公式」「Excel公式」「VLOOKUP怎么用」「SUMIF」「数组公式」「表格公式」「Google Sheets公式」「条件求和」「数据透视表」「excel formula」「spreadsheet」「lookup」时触发。关键词:Excel、公式、formula、VLOOKUP、HLOOKUP、XLOOKUP、SUMIF、SUMIFS、COUNTIF、INDEX、MATCH、IF、嵌套函数、数组公式、透视表、pivot table、条件格式、数据验证、Google Sheets、WPS表格、SUMPRODUCT、OFFSET、INDIRECT、power query、宏、VBA
-
kevinaimonster Skill Python HelperPython 脚本助手。帮用户写 Python 脚本,数据处理、自动化任务、爬虫、文件操作。当用户说「帮我写个 Python 脚本」「Python 怎么写」「写个爬虫」「数据处理脚本」「自动化脚本」「Python 报错」「pandas 怎么用」「正则匹配」「文件批量处理」「Excel 处理」「CSV 读取」「JSON 解析」「python script」「web scraping」「automation」时触发。关键词:Python、脚本、爬虫、数据处理、自动化、pandas、numpy、requests、BeautifulSoup、Selenium、正则、文件操作、CSV、Excel、JSON、API调用、定时任务、批量处理、数据清洗、ETL、subprocess、os、pathlib、asyncio、multiprocessing
-
kevinaimonster Skill SQL GeneratorSQL 生成器。从自然语言描述自动生成 SQL 查询语句,支持复杂查询和多数据库方言。当用户说「帮我写个SQL」「查询怎么写」「自然语言转SQL」「text to SQL」「SQL查询」「数据库查询」「generate SQL」「NL2SQL」「表怎么联」「子查询」「窗口函数」时触发。关键词:SQL生成、自然语言转SQL、NL2SQL、text to SQL、查询生成、SELECT、JOIN、子查询、窗口函数、聚合函数、GROUP BY、HAVING、CTE、WITH、MySQL、PostgreSQL、SQLite、Oracle、SQL Server、数据查询、表关联、索引建议
-
kevinaimonster Skill Redbook Analytics小红书数据分析与运营策略助手。帮用户分析小红书账号数据、爆文规律、标签策略、发布时间优化、涨粉策略。当用户说「小红书数据分析」「分析一下我的小红书」「小红书运营」「为什么我的笔记没流量」「小红书涨粉」「爆文分析」「小红书算法」「redbook analytics」「RED analytics」「小红书复盘」「笔记数据」时触发。关键词:小红书数据、小红书分析、小红书运营、爆文、流量、涨粉、标签策略、发布时间、互动率、完播率、收藏率、点赞率、笔记复盘、账号诊断、小红书算法、内容策略、对标账号、数据看板
-
bbrysonelite-max Bundle Allsup Leads VeteransRun the Allsup VETERANS benefits-gap lead batch — same proven process as the SSDI skill, tuned for veterans. Mines veterans who are owed VA benefits but not getting them — never filed / didn't know they qualified, denied or under-rated, or newly eligible under the PACT Act (burn pit / Agent Orange / toxic exposure) — from Reddit + X + TikTok (last 30 days), tiers by need, writes VETERANS-LEADS-<date>.csv/.md to the Desktop, builds a browsable book, publishes it to a permanent here.now link, and drafts the email to Allsup (via Pat Sullivan) for Brent to send. Use when Brent says "run the veterans leads", "veteran leads", "VA benefits leads", "PACT Act leads", or "veterans batch for Allsup". Reachability-graded — never resolve individuals or chase emails/phones. Sibling of allsup-leads-ssdi; keep the two separate.
-
farmage Bundle Code ReviewerAnalyzes code diffs and files to identify bugs, security vulnerabilities (SQL injection, XSS, insecure deserialization), code smells, N+1 queries, naming issues, and architectural concerns, then produces a structured review report with prioritized, actionable feedback. Use when reviewing pull requests, conducting code quality audits, identifying refactoring opportunities, or checking for security issues. Invoke for PR reviews, code quality checks, refactoring suggestions, review code, code quality. Complements specialized skills (security-reviewer, test-master) by providing broad-scope review across correctness, performance, maintainability, and test coverage in a single pass.
-
farmage Bundle Secure Code GuardianUse when implementing authentication/authorization, securing user input, or preventing OWASP Top 10 vulnerabilities — including custom security implementations such as hashing passwords with bcrypt/argon2, sanitizing SQL queries with parameterized statements, configuring CORS/CSP headers, validating input with Zod, and setting up JWT tokens. Invoke for authentication, authorization, input validation, encryption, OWASP Top 10 prevention, secure session management, and security hardening. For pre-built OAuth/SSO integrations or standalone security audits, consider a more specialized skill.
-
wsxwj123 Bundle Teacher Paper教师智能出题技能 - 覆盖小学一年级到高三全科目(语文、英语、政治/道德与法治、历史、地理、数学、物理、化学、生物),全题型,按用户提供的材料/真题样卷/题型分值分布参数化出卷;结合本地资料(Word/PDF/PPT/Excel/MD/TXT/图片)与在线真实素材(新闻/科普/公版古籍/英语分级读物等)生成学生试卷,产出可直接打印的 Word 试卷 + Word 参考答案及解析。默认九年级语文·长沙中考。理科含图题须用户提供图片,本技能不自动配图。触发时机:用户要求出题、组卷、制作试卷、生成练习题、制作考试卷,或提到'出题''组卷''试卷''考试卷''练习题'等关键词。
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 finance-metrics-quickref, metrics-dashboard-design, data-storytelling-advisor. 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.