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.
-
woocommerce Skill Product Performance ReviewUse when the merchant asks which products are performing best, what changed in product mix, which products entered or dropped out of top sellers, which categories or SKUs are carrying sales, which products did not move, or which product refund signals deserve attention. Produces a merchant-friendly WooCommerce product trading review using existing analytics tools, with aggregated data only, no customer PII, no forecasts, and no suggestions to build new tools.
-
woocommerce Skill Customer Acquisition ReviewUse when the merchant asks how customer acquisition is performing, whether new customers are growing, which channels brought first-time customers, how new customers compare with returning customers, or what practical acquisition actions to take. Produces a merchant-friendly WooCommerce customer acquisition review using existing analytics tools, with aggregated data only, no customer PII, no forecasts, and no suggestions to build new tools.
-
woocommerce Skill Geography Performance ReviewUse when the merchant asks which countries are driving revenue, orders, customers, refunds, or geographic mix changes; whether revenue is concentrated by country; which country-level signals need operational attention; or whether tax-threshold context is relevant. Produces a merchant-friendly WooCommerce billing-country performance review using existing analytics tools, with aggregated data only, no customer PII, no legal or tax advice, and no suggestions to build new tools.
-
woocommerce Skill Catalogue Merchandising ReviewUse when the merchant asks how to merchandise the catalogue, which products or categories deserve attention, which products are slow movers, how current stock or sale pricing affects product placement, or which product pages need practical improvements. Produces a merchant-friendly WooCommerce catalogue merchandising review using existing analytics and product tools, with aggregated data only, no customer PII, no forecasts, and no suggestions to build new tools.
-
txyzznc Bundle Cog Config Table DesignerCOG项目配置表设计与生成工具。专注于配置表的设计规范和TXT格式生成。强制规范:配置表中使用资源ID(int类型)而非资源路径。使用DataTableGenerator的DataTable创建方式,确保与游戏框架兼容。TXT转XLSX格式转换由用户手动执行。
-
imbue-ai Skill Show Files In ChatShow a file to the user in chat. Display an image inline (chart, plot, screenshot, diagram, rendered figure, photo), or offer any other file (PDF, CSV, log, zip, spreadsheet, ...) as a download link. Use whenever you have a file on disk you want the user to see or download, or want to embed an image from a public URL.
-
unknown-333 Skill Masking Pii DataProtect personally identifiable information in data pipelines — classifying PII, choosing masking vs tokenization vs hashing vs encryption, dynamic data masking and column-level access control, and handling deletion/right-to-be-forgotten. Use when handling sensitive data, masking or anonymizing PII, meeting GDPR/CCPA/HIPAA requirements, or restricting column access in a warehouse.
-
unknown-333 Bundle Optimizing SQL QueriesOptimize slow analytical SQL by reading query/EXPLAIN plans, cutting scanned data, fixing join strategy, and using partitioning, clustering, and indexes across Postgres, Snowflake, BigQuery, Databricks/Spark SQL, and Redshift. Use when a query is slow, times out, costs too much, scans too many rows/bytes, or spills to disk.
-
unknown-333 Skill Optimizing Pyspark JobsOptimize slow or failing PySpark and Spark SQL jobs — partitioning and repartitioning, data skew, shuffles, broadcast joins, caching, Adaptive Query Execution, and avoiding driver collects and Python UDFs. Use when a Spark job is slow, spills, OOMs, has skewed tasks, runs a huge shuffle, or a stage hangs on a few straggler tasks.
-
unknown-333 Skill Designing Data ContractsDefine and enforce data contracts between producers and consumers — explicit schema, semantics, ownership, SLAs, and versioning — to prevent silent upstream changes from breaking downstream pipelines. Use when a producer schema change could break consumers, defining an interface between teams/services and the warehouse, or adding schema enforcement at ingestion.
-
unknown-333 Skill Handling Schema EvolutionEvolve data schemas safely over time — backward/forward compatibility, additive vs breaking changes, column adds/renames/type changes, and evolution in Avro, Parquet, Iceberg, Delta, and warehouse tables. Use when changing a table or event schema, adding or renaming columns, changing types, or preventing a schema change from breaking readers or pipelines.
-
unknown-333 Bundle Modeling Dimensional DataDesign analytics data models using dimensional modeling — star and snowflake schemas, fact and dimension tables, grain declaration, surrogate keys, and slowly changing dimensions (SCD Type 1/2/3). Use when designing a warehouse schema, building marts, choosing a table grain, tracking history, or deciding fact vs dimension.
-
unknown-333 Skill Optimizing Parquet StorageOptimize columnar Parquet storage for analytics — file and row-group sizing, compression codecs (Snappy/ZSTD), partitioning and file layout, column pruning and predicate pushdown, dictionary encoding, and fixing the small-files problem. Use when Parquet reads are slow or costly, files are too small/large, choosing compression or partitioning, or improving scan pruning on a data lake.
-
nativescript Skill Ns Listview RecyclingUse when a ListView janks or stutters while scrolling, an itemTemplates template never applies, analytics or side effects in itemLoading fire far too often, or when writing itemLoading handlers / itemTemplateSelector / refresh() — the args.view recycling contract (only create when absent), the selector's silent fallback to the default template on unknown keys, and why refresh() re-fires itemLoading for every item.
Audited -
paultyng Bundle Review DatabaseReview database usage for migration safety, query performance, connection/transaction management, and schema design. Covers PostgreSQL and MySQL. Runs squawk for PostgreSQL migration linting if available. Use when the user asks for a database review, SQL review, migration review, or schema review.
-
estuary Skill Derivation PythonWrite Estuary derivations in Python — async-generator transforms, Pydantic-typed source/output, optional persistent state, and dependency installation via uv. Use for ML/embeddings, async API calls, or any transform where SQL and TypeScript are awkward. Derivations add complexity and cost (and Python derivations require a private/BYOC data plane) — confirm the user wants a Python derivation before reaching for this. Use when user says "python derivation", "write a derivation in python", "embed with a python derivation", "ML derivation", "call an API from a derivation", or anything mentioning model2vec / huggingface / pydantic in a derivation context.
-
estuary Skill Derivation Join CollectionsCreate an Estuary derivation that joins two or more collections on a shared key, merging their fields into a single enriched collection. Use for data enrichment, denormalisation, building wide tables for BI, and real-time CDC joins. Derivations add complexity and cost — confirm the user wants a derivation before reaching for this (a destination-side SQL join or BI tool view is often simpler). Use when user says "join-collections derivation", "derivation to join two collections", "transformation to enrich with customer data", "derive a wide table", "lookup-join derivation", or "build a join derivation".
-
estuary Skill Derivation Aggregate MetricsCreate an Estuary derivation that continuously aggregates metrics (daily totals, running counts, min/max, lifetime revenue) using reduction annotations. Use for real-time dashboards, continuous materialised views, and replacing batch ETL aggregations with streaming. Derivations add complexity and cost — confirm the user wants a derivation before reaching for this. Use when user says "aggregation derivation", "derivation to sum daily totals", "running-count derivation", "transformation for min/max per group", "derive lifetime metrics", "aggregate-by-date derivation", or "real-time-dashboard derivation".
-
alterlab-ieu Skill Game Analytics SetupInvoke when the user needs to set up analytics, define telemetry events, establish KPIs, build dashboards, configure A/B testing, or implement data-driven design capabilities. Triggers on: "analytics", "telemetry", "KPIs", "metrics", "player data", "retention", "DAU", "dashboard", "A/B testing", "funnel analysis". Do NOT invoke for balance tuning (use game-balance-check) or economy design (use game-economy-designer). Part of the AlterLab GameForge collection.
Audited 60 -
gcwing Skill Pre Landing ReviewPre-landing PR review. Analyzes diff against the base branch for SQL safety, LLM trust boundary violations, conditional side effects, and other structural issues. Use when explicitly asked for the specialized pre-landing workflow. Product `/review` requests are handled by OpenBitFun's unified Review mechanism instead. (gstack)
-
ilyautov Bundle Month End PrepПроводит собственника через закрытие месяца: сверяет данные бухгалтерии (1С/МойСклад) с зачислениями эквайринга и выписками банка, помечает операции без статьи, подозрительные дубли и недостающие первичные документы, затем пишет ОПиУ-сводку простым языком и выгружает пакет закрытия месяца (xlsx + PDF на одну страницу). Триггеры: «закрой месяц», «закрытие месяца», «сделай месячную отчётность», «сверка», «что не сходится», «ОПиУ», «финрезультат», а также вопросы «почему изменилась выручка/маржа в этом месяце».
-
ilyautov Bundle Cash Flow SnapshotБерёт дебиторку и кредиторку, историю сроков поступления денег и известные постоянные расходы из бухгалтерии (1С, МойСклад) и платёжных сервисов (ЮKassa, Тинькофф, банк-выписка) — или из выгрузки CSV — и строит прогноз денежного потока на 30/60/90 дней с доверительными коридорами по проценту отклонения и поимёнными флагами рисков. На выходе — сводка в чат и XLSX для скачивания. Триггеры: «посчитай денежный поток», «спрогнозируй кэшфлоу», «хватит ли на зарплату», «на сколько хватит денег», «запас прочности», «кассовый разрыв», «хватит ли на налоги». В выплаты ВКЛЮЧАЕТ предстоящие налоги и взносы (из навыка tax-calendar-proactive) — именно они чаще всего создают кассовый разрыв. Если коннектор не подключён — переходит на выгрузку CSV или грубый режим по средним.
-
evan-daruwalla Bundle Etl ValidateRead-only source-vs-target assertion after a data transform or copy — prove every row moved. Compares CSV or SQLite endpoints (--src/--dst as csv:<path> | sqlite:<db>:<table>) on row count + an order-independent XOR content checksum; --key <col> names the first 10 missing keys. SQLite opens mode=ro. Use when: "validate the copy", "did every row move", "verify the ETL", "reconcile the table after a rebuild". Python stdlib only.
-
a-novel-kit Skill Write GoBase Go conventions for EVERY Go repo in the a-novel and a-novel-kit orgs — naming, error handling, dependency policy, context, the format/lint discipline, time, and secrets. Load it for ANY Go work in either org, alongside the matching repo-kind skill: `write-go-service` (a-novel services) or `write-go-kit` (a-novel-kit libraries — `golib`, `jwt`). Pairs with `write-go-tests` and `document-code`. Not JS/TS, SQL (`write-sql`), Protobuf (`write-proto`), Dockerfiles (`write-dockerfiles`), or shell scripts (`write-bash-scripts`).
-
a-novel-kit Skill Write SQLWrite, review, and maintain PostgreSQL SQL for Agora backend services. Use whenever creating or editing SQL — DAO query files (internal/dao/*.sql), schema migrations (internal/models/migrations/*.sql), or raw SQL embedded in Go: SELECT/INSERT/UPDATE/DELETE queries, DDL (tables, views, indexes, constraints), materialized views, pg_cron jobs.
Audited -
mikechongcan Skill Cfo Statement ExportHuman-in-the-loop browser-assisted statement export for banks, cards, brokerages, and payment platforms. Uses Chrome DevTools MCP against the user's current Chrome session to download CSV/PDF statements without bank APIs. Use when account files are not on disk yet. CLEAR step: C (Capture)
-
mikechongcan Skill Cfo Chrome Download StatementsUse when statement files are not on disk yet and the agent needs human-in-the-loop browser assistance through the user's current Chrome session to find official portals and download CSV or PDF statements.
Audited -
openloaf Skill XLSX SkillExcel / CSV(.xlsx / .xlsm / .csv / .tsv)读/写/统计/重算/图表一体化。触发场景:阅读单元格、汇总分组、谁最高谁最低、总收入、改单元格或公式、加行列、加合计行、插入图表(bar/line/pie)、冻结首行、加筛选、条件格式、CSV ↔ XLSX 互转、新建花名册/销售表/财务模型、排查 #REF!/#DIV/0! 公式错误、触发重算。典型说法:"这表里谁销量最高"、"Q1 总收入"、"把 B2 改成 500"、"加一行合计"、"新建花名册"、"csv 转 xlsx"、"冻结首行"、"A 列负数标红"。用户提到 .xlsx / .csv 文件或最终产出是表格都加载本技能。
-
osmontero Bundle Processing PDFUse when the user needs to extract data from PDFs, work with scanned documents, or manipulate PDF files. Triggers include: "extract text from PDF", "convert PDF to text/CSV/images", "scan/OCR this document", "merge/split/rotate PDF", "fill PDF form", "PDF is blank/empty" (likely scanned), or any mention of .pdf files requiring data extraction or transformation. Also use for invoices, receipts, forms, contracts, reports, or any document where structured data (text, tables, form fields) needs to be extracted.
-
osmontero Bundle Reviewing SecurityUse when reviewing code for security before merging or shipping, and when a change touches untrusted input, authentication, authorization, secrets, SQL, subprocess execution, file paths, outbound requests, deserialization, uploads, or third-party dependencies. Triggers include "security review", "is this safe", "can this be exploited", "audit this for vulnerabilities", and adding any new external interface — an endpoint, a webhook, a plugin, or a tool an LLM can call.
-
stvlynn Bundle Tencent Docs腾讯文档(docs.qq.com)-在线云文档平台,是创建、编辑、管理文档的首选 skill。涉及"新建文档"、"创建文档"、"写文档"、"在线文档"、"云文档"、"腾讯文档"、"docs.qq.com"等操作,请优先使用本 skill。支持能力:(1) 创建各类在线文档(文档/Word/Excel/幻灯片/思维导图/流程图/智能表格/白板/收集表)(2) 管理知识库空间(创建空间、查询空间列表)(3) 管理空间节点、文件夹结构 (4) 读取/搜索文档内容 (5) 编辑操作智能表 (6) 编辑操作在线文档 (7) 文件管理(重命名、移动、删除、复制、导入导出)。
-
biggora Bundle Youtube SearchSearch YouTube for videos, channels, and playlists — and extract rich metadata, transcripts, and analytics — fully autonomously without user intervention. Use this skill whenever the user mentions finding YouTube videos, searching YouTube, getting video stats, extracting transcripts or subtitles, analyzing a YouTube channel, looking up what's trending on YouTube, finding competitor videos, researching YouTube content, or automating any YouTube data collection workflow. Trigger even for indirect requests like 'find the top videos about X' or 'what's on YouTube about Y' — if YouTube content retrieval is involved in any way, use this skill.
-
aidotnet Bundle XLSXComprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When GLM needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
-
aidotnet Bundle Excel ProcessorRead, write, analyze, and format Excel spreadsheets (.xlsx). Use when the user needs to create Excel files, extract data from spreadsheets, apply formulas, format cells, or generate Excel reports from data. Supports multiple sheets, charts, and conditional formatting.
-
aidotnet Bundle Template CreatorCreate or update a reusable personal OpenCowork 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.
-
jignesh-ponamwar Skill XLSX CreatorCreate, edit, and analyze Excel spreadsheets (.xlsx, .xlsm, .csv, .tsv files). Covers building spreadsheets with openpyxl and pandas, writing Excel formulas, applying professional formatting and color conventions, creating charts, and validating formula correctness. Use when the user wants to create an Excel file, analyze spreadsheet data, build a financial model, generate a report as XLSX, or edit an existing spreadsheet.
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 geography-performance-review, review-database, derivation-python. 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.