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.
-
zmgid Skill XLSXRead, summarize, calculate from, and analyze Excel/CSV/TSV spreadsheet attachments saved by Kivio Chat.
-
alfredang Bundle Fill Tsc Jd Lithan CcpFill the JD / "Job responsibilities" column (Column F, labelled "aligned with JD") in a Lithan CCP TSC Scoping Matrix workbook. For each technical skill & competency (TSC) row, write a one-line job responsibility aligned with that skill's Objective and the job role, matching the style of an already-filled reference sheet. Use when the user asks to fill, update, write, or summarise the JD / job responsibilities column on the TSC (Technical Skills & Competencies) Scoping Matrix for a Lithan CCP — files named like "CCP TSC Scoping Matrix LOO6*.xlsx" under the Tertiary Infotech/CCP person folders. Each workbook sheet is one job role (e.g. "2.4 AI ML Engineer", "3.3 Software Eng Manager").
-
deedlefake Skill NeonUse Neon Postgres (the database) in this TanStack Start app. Use when the app needs to store or query data, persist state, or keep per-user data. Triggers on "database", "Postgres", "Neon", "save data", "store data", "persist", "tables", "SQL", "query", "migrations".
-
dithiothreitol Skill ContractsCykliczne kontrakty JDG — automatyczne wystawianie faktur miesięcznych, oznaczanie płatności, import CSV z banku. Użyj gdy user pyta "faktury automatyczne", "kontrakt cykliczny", "auto-fakturowanie", "subskrypcja klienta", "powtarzające się faktury", "oznacz jako zapłacone", "import wyciągu", "CSV bank", "które faktury nie zostały zapłacone".
-
eprouveze Bundle Gmail AttachmentSend (or draft) a Gmail message with one or more file attachments via the google-workspace MCP. Use whenever the user asks to email a file, attach a document, send a PDF / markdown / spreadsheet by mail. Trigger phrases — "email this file to X", "send by mail with the doc attached", "envoie ce fichier par mail", "joindre en pièce jointe". The MCP's documented `path` field is sandboxed and silently fails on host paths; this skill enforces the only working route (base64 `content` + `filename`) and documents the size envelope.
-
eprouveze Bundle Salesforce ReportsCreate, clone, read, run, and delete Salesforce Reports from the command line via the Analytics REST API, driven by the Salesforce CLI (`sf`). Org-agnostic — works against any org you've authed with `sf`. Includes a `--setup` flow (installs the sf CLI if missing, saves a default org/API version, and an optional Global Company filter for GAM roles). Use when the user says "create a Salesforce report", "clone a report", "generate a report via sf CLI", "list/run/delete reports", "report API", or "Analytics REST reports".
-
exasol-labs Skill ExasolTop-level router for Exasol work. Use for any Exasol database, exapump, SQL, BucketFS, extension, integration, UDF, Script Language Container, or Exasol Personal setup task, then route to the narrowest specialized Exasol skill.
-
exasol-labs Bundle Exasol DatabaseExasol database interaction via the exapump CLI and Exasol SQL. Covers SQL queries and DML/DDL such as `SELECT`, `INSERT`, `UPDATE`, `DELETE`, `MERGE`, `CREATE TABLE`, `ALTER TABLE`, and `DROP TABLE`, `CREATE CONNECTION` connection objects without import or export intent, schema inspection, table design, `exapump sql` and `exapump profile`, query profiling, analytics, and Exasol-specific SQL behavior outside exasol-import and exasol-export.
-
exasol-labs Bundle Exasol Jdbc Virtual SchemasUse Exasol JDBC-based virtual schemas for federated read-only access to external databases such as PostgreSQL, Oracle, MySQL, SQL Server, and DB2. Covers database-source adapter selection, `CREATE VIRTUAL SCHEMA`, `ALTER VIRTUAL SCHEMA`, `EXPLAIN VIRTUAL`, metadata refresh, and query-side troubleshooting.
-
haoyuesheng1688 Bundle Wps Excel CaseOpen WPS Spreadsheets (ET) or Microsoft Excel, create a new workbook, and insert a formatted sample table or matrix. Use when the user asks to open WPS Excel, WPS表格, or ET and enter a sales case, inventory sheet, attendance table, expense sheet, demo workbook, permission matrix, or image-to-Excel table with polished formatting.
-
haoyuesheng1688 Bundle Eplan Io Closed LoopConnect to an already open EPLAN Electric P8 project on Windows, discover the active project, export a read-only PLC IO point list, and summarize the closed-loop input/output map as CSV and text. Use when the user asks to connect to EPLAN, Electric P8, a live EPLAN project, or wants PLC IO points, IO closure, module/address listings, or a reusable export workflow.
-
haoyuesheng1688 Bundle Excel Psychrometric ToolBuild or refresh an Excel moist-air calculator workbook that derives the remaining psychrometric properties from any two independent inputs among air temperature, relative humidity, humidity ratio, and dew point temperature. Use when the user asks for an Excel tool, workbook, macro, or template for humid-air calculations, especially on Windows with desktop Excel already open and with requirements like red input cells, green output cells, calculation buttons, or reusable workbook automation.
-
haoyuesheng1688 Bundle Office Desktop AssistantAutomate Microsoft Word and Excel desktop work on Windows. Use when Codex needs to type into an already open Word document, create a formatted docx on disk, create or style an Excel workbook, transcribe structured image content into Excel, or prepare Office-ready weather notes and translated follow-up lines for Word.
-
hollandkevint Skill Dashboards To DecisionsConvert dashboard requests into decision specifications. The missing layer between "build me a dashboard" and "help me decide." Use when receiving dashboard requests, reviewing analytics backlogs, prioritizing data team work, or when someone asks "what dashboard do you need?" Apply this BEFORE building anything.
-
iansteitz1-eng Bundle Sprint ScaffoldScaffold a new sprint folder with the Filing Cabinet spec_charter.md + Flowstate .claude/agents/pr-review.md + reference/sql/ subdirs. Use when starting a new sprint (e.g. "open sprint 021", "start a sprint for X", "new sprint folder"). Drops a working skeleton in ./sprints/NNN_slug/ with the load-bearing files pre-filled so every shipped item gets an audit-trail home. Validated over a two-terminal sprint that shipped 20+ items under this pattern.
-
jmagar Bundle TautulliMonitor and analyze Plex Media Server usage via Tautulli analytics API. Use when the user asks to "check Tautulli", "Plex analytics", "watch statistics", "current streams", "who's watching", "Plex history", "most watched", "user activity", "library stats", or mentions Tautulli/Plex monitoring.
-
joomcode Skill My Product Vs CatalogCompares the seller's own Mercado Livre listing against the available competing listings of the same catalog product — the buy-box competition — and says where they win, lose, and what to fix first. Use it when a seller asks why they don't win the buy-box, why they don't sell despite the same product, or how they rank inside a catalog, given a Mercado Livre or JoomPulse link or a listing or catalog product identifier. It scores each parameter — price, free shipping, Full, listing type, seller reputation, official store — as Melhor, Na média, Pior, or Criticamente pior, presents reviews and rating as context, and returns a verdict, a comparison table, prioritized actions, and a spreadsheet. Triggers include "why don't I win the buy-box" and the pt-BR "por que não ganho o buy-box". Mercado Livre (Brasil) only; sales and revenue are JoomPulse estimates, not real transactions. For a product and its competitors, use the single-product analysis skill; for one over time, the change-monitor skill.
-
kapstanhq Bundle ComecarA primeira skill do pack, e a que todas as outras nove pressupõem: monta a carteira do corretor do zero, em oito passos, no computador ou no Google Drive. Cria as pastas, copia os sete modelos, escreve quem ele é, grava o modo — copiloto ou automático — e conecta Google Agenda, Gmail e Drive explicando cada botão e TESTANDO antes de escrever “sim”. Ensina a trazer conversa do WhatsApp, que entra colada. Termina com a carteira cheia: um imóvel de verdade, vindo de um link — ou a planilha de imóveis inteira, em CSV —, e um cliente, vindo de uma conversa colada. Todo passo é pulável, e se ele fechar no meio ela volta de onde parou. Use na primeira vez, e quando ele disser “instalei, e agora”, “como eu começo”, “configura isso pra mim”, “não tenho carteira nenhuma”, “importa minha planilha”, “tenho tudo numa planilha”, “quero ligar minha agenda”, “parei no meio da configuração”, “pulei o Gmail e quero ligar agora”, “mudei de computador” — e sempre que outra skill disser que não achou o INDICE.md da carteira.
-
14790897 Bundle DOCX Work Report生成实习生结构化工作记录文档(格式对齐官方「AI Agent 小团队实习生工作记录模板包」)。当用户说"日报"、"新增"、"周报"、"任务看板"、"台账"、"生成docx"、"写日报"、"填新增"、"打包提交"时触发。支持日报、新增记录、周报、任务看板(五表联动)四类 docx 自动生成;台账不生成 Word,而是用 openpyxl 追加到汇总 Excel。输入为口语化的工作内容描述,输出为格式化的 .docx / .xlsx 文件。
-
aws-samples Bundle Data AnalysisAnalyze CSV and JSON data files to produce summary statistics, detect anomalies, and generate formatted reports. Use when the user asks to summarize data, compute statistics (mean, median, percentiles), find outliers, or produce tabular reports from structured data files. NOT for: image analysis, unstructured text processing, database queries, or real-time streaming data.
-
aws-samples Bundle Eval SkillA test skill for CSV data processing and analysis. Use when testing functional and trigger evaluation.
-
brojonat Bundle SqliteExtend SQLite with application-defined functions and loadable extensions in Python. Use when you need custom SQL logic (transforms, scoring, aggregations) in-process, or need to load/build C extensions for reusable SQLite plugins. Assumes Python stdlib sqlite3. Go equivalents exist (zombiezen/go-sqlite, mattn/go-sqlite3) — look up their APIs at runtime.
-
traigent Bundle Traigent Recipe Text2sqlEnd-to-end recipe to optimize a text2SQL agent with Traigent and reach high accuracy at low cost. Use when wiring a SPIDER-style NL->SQL agent with @traigent.optimize: execution-match scoring, model + structural knobs, weighted ACL objectives, mock dry-run, then a real portal-tracked run. Captures the working configuration that took a plain agent from 66.7% -> 90% on the cheap model.
-
algolia Bundle Algolia MCPSearch Algolia indices via the Algolia MCP server, retrieve analytics (top searches, no-result rates, click positions, user counts), and get product recommendations (bought-together, related, trending). Triggers on search, indexing, analytics, Algolia, recommendations, MCP.
-
algolia Bundle Algolia Release QAAlgolia launch, regression, and implementation QA. Use when auditing an Algolia build before release, validating relevance changes, checking search UI behavior, verifying event instrumentation, diagnosing analytics gaps, reviewing secured keys, or creating a smoke test plan for search, browse, autocomplete, indexing, and configuration changes. Do NOT use to make live account changes or inspect live account data; use algolia-mcp or algolia-cli first. Do NOT use as the primary implementation skill when the task is clearly data modeling, events setup, InstantSearch, Autocomplete, NeuralSearch, or Agent Studio; use the focused skill first and this skill for final QA.
-
algolia Bundle Algolia NeuralsearchProduct-specific Algolia NeuralSearch implementation, validation, and optimization guidance. Use when planning, enabling, configuring, testing, or tuning NeuralSearch, AI relevance, semantic retrieval, adaptive intent, model training, A/B testing, limitations review, query analysis, relevance diagnostics, event readiness, and data preparation for neural or hybrid search experiences. Do NOT use for generic vector database, embeddings, or non-Algolia semantic search architecture. Do NOT use for live settings changes, replica creation, or analytics retrieval; use algolia-cli or algolia-mcp first, then this skill for readiness and rollout guidance.
-
altafino Skill Kit SQLSQL guardrails pack — NULL logic and JOIN traps, destructive-operation discipline, injection, query cost. Use when writing SQL, query-builder calls, ORM queries, or database migrations.
-
monarchjuno Bundle Financial ReportPackage investing analysis into a publishable financial-report style with institutional section flow, thesis framing, valuation context, catalysts, risks, tables, and financial charts. Use when an agent needs to turn existing research into a broker-style or professional finance report for equities, crypto, credit, commodities, portfolios, or macro topics, including chart-heavy outputs such as indicator charts, OHLCV charts, line charts, bar charts, pie charts, and comparison visuals, while keeping the result structured enough for an external docx, pdf, markdown, or spreadsheet skill to render final files.
-
muend Bundle Postgis Spatial SQLInvoke whenever spatial SQL or its execution backend is the decision: PostGIS, DuckDB Spatial, SpatiaLite, ST_* functions, recurring spatial joins, concurrent/growing workloads, or large GeoParquet queries. Covers backend selection, schemas, GiST/BRIN indexes, KNN, geometry versus geography, correctness benchmarks, and EXPLAIN optimization. Use PostGIS for managed concurrent services and embedded engines for bounded local analytics when evidence supports that choice. Use geo-data-engineering for acquisition, conversion, and file-based ETL without spatial SQL.
-
gnurio Skill Execute CalendarCreate and manage a content posting calendar for viral meme spread. Takes approved content variants and produces a schedule with timing, platform, volume, and secondary account strategy. Implements the 3-5 posts/day consistent posting strategy. [NEEDS SOURCE MATERIAL] Source recommends 3-5 posts/day but doesn't detail calendar mechanics, optimal timing per platform, or analytics tracking methodology.
-
grandcamel Bundle Confluence AnalyticsView analytics, statistics, and popularity metrics for Confluence content. ALWAYS use when user wants to see views, popularity, or contributor stats.
-
instavm Skill Mitm Find SqliFind SQL Injection vulnerabilities in captured traffic. Use when user asks about database security, injection attacks, or data extraction.
-
iwritec0de Bundle Mysql ExpertThis skill should be used when the user asks to "write a MySQL query", "configure my.cnf", "choose a storage engine", "tune MySQL performance", "set up MySQL replication", or mentions "mysql", "mariadb", "innodb", "my.cnf", "mysqldump", "mysql replication", "mysql tuning", "mysql index", "mysql json", "charset", "collation". Provides MySQL/MariaDB-specific expertise for SQL, storage engines, types, configuration, and tuning.
-
iwritec0de Bundle Postgresql ExpertThis skill should be used when the user asks to 'write a PostgreSQL query', 'configure postgresql.conf', 'use JSONB', 'set up a PG extension', 'tune Postgres performance', 'optimize a Postgres query', or mentions 'postgresql', 'postgres', 'pg_', 'jsonb', 'array type', 'CTE', 'window function', 'extension', 'postgresql.conf', 'pg_stat', 'vacuum', 'WAL'. Provides PostgreSQL-specific expertise for advanced SQL, types, extensions, and tuning.
-
painhardcore 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.
-
bobibobuyu Bundle Mx Finance Data连接东方财富数据服务,通过自然语言获取 A 股、港股、美股、基金和债券等金融数据,支持行情、企业资料、估值与财务指标查询,并生成 xlsx 数据文件及结果说明。Natural-language financial data access for stocks, funds, bonds, company profiles, market quotes, valuation data, and financial metrics, with spreadsheet output.
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 data-analysis, algolia-neuralsearch, financial-report. 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.