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.
-
dss-time Skill Excel Data Quality Check BasicPerform a read-only spreadsheet data-quality audit that reports missing values, duplicates, types, formats, anomalies, and source-traceability issues without cleaning, standardizing, filling, deduplicating, overwriting, or generating a modified copy. Use for requests to check, audit, or list data-quality problems; use spreadsheet-data-cleaning when the user requests transformations, fixes, or a cleaned output. 对表格执行只读数据质量审计,报告缺失、重复、类型、格式、异常和来源可追溯性问题,不清洗、标准化、填补、去重、覆盖或生成修改后的副本。用于检查、审计或列出数据质量问题;用户要求转换、修复或输出清洗结果时使用 spreadsheet-data-cleaning。
-
promovaweb Bundle Specsfy Specialist PostgresModelar, consultar, migrar e operar PostgreSQL com integridade, índices, concorrência, segurança, performance e recuperação. Use para schemas, SQL, EXPLAIN, locks, isolation levels, migrations, roles, backup ou tuning em Postgres; não use para outro banco relacional sem confirmar a semântica específica, e não use para RLS/Auth/Realtime de Supabase — combine com `specsfy-specialist-supabase` nesse caso.
-
synapseradio Bundle Apache AgeApache AGE graph database extension for PostgreSQL — Cypher query syntax, agtype data types, hybrid SQL+Cypher patterns (CTEs, JOINs, parameter passing), graph schema modeling (vertices, edges, labels, properties), and performance optimization (indexing, EXPLAIN, batch loading). Use when writing Cypher queries, designing graph schemas, combining graph traversal with relational SQL, or optimizing AGE query performance — all within PostgreSQL via the AGE extension.
-
shuwanito Bundle Nexus Ped StylesLearning analytics and style detection agent specializing in learning style analysis, multiple intelligences, and individual pacing. Use when you need to detect learner preferences, adapt content delivery to different styles, or analyze learning pace patterns.
-
shuwanito Bundle Nexus Data ScienceData science agent specializing in AI models, analytics, explainable AI (XAI), federated learning, and knowledge graphs. Use when you need to build or review ML/AI models, improve transparency and interpretability, implement federated learning, or enhance RAG and embedding systems.
-
shuwanito Bundle Nexus Data EngineerData engineering agent specializing in ETL/ELT pipelines, data quality, warehousing, and streaming. Use when you need to design or review data pipelines, ensure data integrity, detect schema drift, or evaluate tools like dbt, Airflow, and streaming platforms for EdTech and enterprise workloads.
-
zeenie-ai Skill Cloudflare SkillWork with Cloudflare via the official cf CLI — check auth identity, list zones, list/create/delete DNS records, query the GraphQL Analytics API (zone traffic, Web Analytics/RUM), and run any other cf command. Output is parsed JSON.
-
jordangaston Bundle Iterative HypothesisGuides founders through Jason Cohen's Iterative-Hypothesis customer development method — a structured system for generating and testing hypotheses about customers through interviews, used to vet what became WP Engine. Use this skill when the user mentions customer development hypotheses, iterative hypothesis testing, hypothesis spreadsheets, Jason Cohen's method, A Smart Bear customer development, vetting startup ideas through interviews, writing customer hypotheses, or building a goals → hypotheses → questions → iterate loop. Also trigger when users want open-ended interview questions from assumptions, a hypothesis tracking spreadsheet, analysis of interview notes against hypotheses, or guidance on when to stop interviewing. Complements the customer-interview skill with a hypothesis-driven iterative method.
-
x-cmd Bundle X DfEnhanced `df` combining disk usage and mount info. Supports CSV, TSV, and TUI with filesystem type detection. **Dependency**: This is an x-cmd module. Install x-cmd first (see x-cmd skill for installation options).
-
x-cmd Bundle X PsEnhanced `ps` process viewer with interactive UI, fzf support, AI filtering, and CSV/JSON/TSV output formats. **Dependency**: This is an x-cmd module. Install x-cmd first (see x-cmd skill for installation options). see x-cmd skill for installation.
-
x-cmd Bundle X ArpDisplay ARP cache table with MAC vendor lookup and suspicious entry detection. Supports CSV, TSV, and TUI output. **Dependency**: This is an x-cmd module. Install x-cmd first (see x-cmd skill for installation options). see x-cmd skill for installation.
-
x-cmd Bundle X LastEnhanced `last` command with CSV, JSON, tree view, and interactive UI for viewing login history. **Dependency**: This is an x-cmd module. Install x-cmd first (see x-cmd skill for installation options). see x-cmd skill for installation.
-
x-cmd Bundle X NetsEnhanced netstat module with cached data and structured output. View network connections, routing tables, and interface statistics in interactive or TSV/CSV formats. **Dependency**: This is an x-cmd module. Install x-cmd first (see x-cmd skill for installation options). see x-cmd skill for installation.
-
x-cmd Bundle X RouteRoute table viewer with multiple output formats. Display network routing table in CSV, TSV, or raw format. **Dependency**: This is an x-cmd module. Install x-cmd first (see x-cmd skill for installation options). see x-cmd skill for installation.
-
x-cmd Skill CSVCSV data processing — view, filter, convert, merge tabular data. Zero barrier — use with x-cmd, Python, or awk. Use for "csv", "data", "table", "spreadsheet", "conversion".
-
blacklanternsecurity Skill SQL Injection BlindGuide blind SQL injection exploitation (boolean-based, time-based, and out-of-band) during authorized penetration testing.
-
blacklanternsecurity Skill SQL Injection ErrorGuide error-based SQL injection exploitation during authorized penetration testing.
-
blacklanternsecurity Skill SQL Injection UnionGuide UNION-based SQL injection exploitation during authorized penetration testing.
-
blacklanternsecurity Skill SQL Injection StackedGuide stacked query SQL injection and second-order injection exploitation during authorized penetration testing.
-
blyatiful1 Bundle Analyticsanalytics — count the goals you promised
-
devexpress Bundle Devexpress Wpf Data GridBuild WPF applications with the DevExpress Data Grid (GridControl) — a data-aware control that displays and edits data in table, card, and treelist layouts. Use when adding GridControl to a WPF project, binding to data sources (Entity Framework Core, XPO, local collections, ICollectionView, virtual sources, server mode), configuring columns and editors, sorting, filtering, grouping, summaries, master-detail, conditional formatting, printing, and exporting (XLSX/CSV/PDF). Also use when someone mentions "DevExpress WPF grid", "GridControl", "TableView", "CardView", "TreeListView", "dxg:GridControl", "DevExpress.Xpf.Grid", "DevExpress.Wpf.Grid", "Items Source Wizard", "WPF data grid", or asks about working with tabular data, server-mode large datasets, instant feedback mode, or grid CRUD operations in WPF. Covers both .NET 8+ and .NET Framework 4.6.2+.
-
devexpress Bundle Devexpress Blazor GridBuild and configure the DevExpress Blazor Grid (DxGrid) — a full-featured data grid for Blazor Server, WebAssembly, and Hybrid apps. Use when binding tabular data (IEnumerable/IQueryable/EF Core/server-mode/custom sources), enabling sorting/filtering/grouping/search, implementing CRUD editing (row/edit form/popup/cell), handling selection and focused rows, exporting to CSV/XLSX/PDF, customizing templates and summaries, and supporting large datasets with virtualization. Also use for DxGrid, DevExpress grid, Blazor data grid, virtual scrolling, server mode, and grid feature comparisons or migration scenarios.
-
devexpress Bundle Devexpress Xaf PerformanceXAF performance optimization across database, ORM, and application layers. Covers server-mode data sources and data access modes, EF Core eager loading, query splitting, and change-tracking proxies, XPO delayed and explicit loading, PersistentAlias for calculated properties, N+1 Select Problem, database indexing and connection pooling, startup optimization, SQL and .NET profiling, Blazor tab management, and database views.
-
devexpress Bundle Devexpress Blazor TreelistBuild and configure the DevExpress Blazor TreeList (DxTreeList) — a hierarchical data grid / tree grid for Blazor Server, WebAssembly, and Hybrid apps. Use when displaying tree-structured or parent-child data; binding flat data with KeyFieldName, ParentKeyFieldName, and RootValue; expanding/collapsing nodes; sorting, filtering, search box, and filter panel; implementing CRUD editing for tree nodes; exporting to CSV/XLSX/PDF; loading child nodes on demand; and reordering/re-parenting nodes with drag-and-drop. Also use for DxTreeList, DevExpress TreeList, tree grid, hierarchical grid, parent-child table, and tree grid feature comparisons or migration scenarios.
-
devexpress Bundle Devexpress Winforms Data GridDevExpress WinForms Data Grid — GridControl with GridView, BandedGridView, AdvBandedGridView, CardView, LayoutView, TileView, and WinExplorerView, plus the TreeList for hierarchical data. Covers data binding (regular, ServerMode, InstantFeedback, VirtualServerModeSource), column generation (PopulateColumns, AddVisible, unbound columns via UnboundExpression, bands, ColumnEdit), cell display and editing (RepositoryItem, CustomRowCellEdit, DisplayFormat, edit forms, OptionsColumn), conditional formatting (FormatRules), validation (ValidateRow, SetColumnError), filtering (Excel-style, Auto Filter Row, Find Panel, ActiveFilterString), sorting and grouping (SortInfo, GroupInterval), master-detail (LevelTree, pattern views), print and export (ExportToXlsx/Pdf), focus and selection (FocusedRow, MultiSelect), drag-and-drop, and layout persistence (SaveLayoutToXml). Use for any WinForms grid, tree-list, or card-view scenario.
-
devexpress Bundle Devexpress Office File API SpreadsheetBuild .NET applications with the DevExpress Spreadsheet Document API for creating, reading, modifying, and exporting Excel workbooks programmatically without Microsoft Office. Use when working with .xlsx, .xls, .xlsm, .csv spreadsheet files, cell formatting, formulas, charts, pivot tables, data import/export, or workbook printing. Also use when someone mentions "DevExpress Spreadsheet", "Spreadsheet Document API", "IWorkbook", "Worksheet", "DevExpress.Spreadsheet", "create Excel file in C#", "read xlsx in .NET", "spreadsheet export to PDF", "cell formatting", or asks about any Excel/spreadsheet automation with DevExpress. Covers both .NET and .NET Framework.
-
devexpress Bundle Devexpress Office File API Excel ExportBuild .NET applications with the DevExpress Excel Export Library for streaming generation of Excel files with low memory footprint. Use when generating large Excel reports, writing rows sequentially, building Excel files from data grids or report engines, or when the full Spreadsheet Document API would use too much memory. Also use when someone mentions "DevExpress Excel Export", "XlExport", "IXlExporter", "IXlSheet", "DevExpress.Export.Xl", "streaming Excel generation", "low-memory Excel", or asks about generating large Excel files efficiently with DevExpress. Covers both .NET and .NET Framework.
-
bm629 Bundle AlembicUse when running Alembic database migrations on top of a SQLAlchemy 2.x data layer that targets more than one dialect — SQLite, PostgreSQL, and MySQL — from a single migration history. Covers wiring env.py / alembic.ini to your models' Base.metadata (sourcing the DB URL from the environment, sync-first with a short async run_async_migrations note), the full revision -> autogenerate -> review -> upgrade/downgrade workflow, branching (history / current / heads / merge for multiple heads), and the load-bearing multi-dialect gotcha: SQLite cannot ALTER most schema, so write migrations in BATCH (move-and-copy) style — the same batch_alter_table code emits plain ALTER on PG/MySQL. Also owns the create_all-vs-Alembic decision and the baseline-stamp path off a create_all'd DB. Multi-dialect, portable, sync-first. Not SQLAlchemy model/engine authoring (see sqlalchemy), not job-queue/lease patterns (see sql-job-queue).
-
bm629 Bundle SqlalchemyUse when standing up a relational data layer with SQLAlchemy 2.x (2.0/2.1) ORM that must run on more than one dialect — SQLite, PostgreSQL, and MySQL — from a single codebase. Covers the typed 2.x ORM (DeclarativeBase / Mapped[...] / mapped_column), engine + connection-string + pooling, short-lived sessions and transaction scope, the sync-first / async (AsyncSession / await) split with a per-dialect driver matrix, and the cross-dialect gotchas that bite when one schema runs on all three engines: row locking (with_for_update / SKIP LOCKED), JSON columns, upsert (ON CONFLICT vs ON DUPLICATE KEY UPDATE), autoincrement / identity, and transaction isolation. Multi-dialect, portable, ORM-first. Not migrations (see alembic), not job-queue/lease patterns (see sql-job-queue), not a full API reference.
-
bm629 Bundle SQL Job QueueUse when building a DB-backed job queue / task scheduler on SQLAlchemy 2.x whose readiness is dependency-driven, whose jobs are long-running and stateful, and whose only durable substrate is the relational DB — single box, embeddable, no broker, multi-dialect (SQLite / PostgreSQL / MySQL). Covers the generic jobs/job_deps model, the ready-set query, the per-dialect atomic lease (FOR UPDATE SKIP LOCKED on PostgreSQL + MySQL 8 vs BEGIN IMMEDIATE on SQLite, with dialect detection), crash-resume via heartbeat + lease expiry + stale-lease reclaim, the hung-but-alive per-dispatch timeout, weighted fair-share over group_key, the scan→rank→lease→dispatch→persist→reclaim tick loop, polling vs LISTEN/NOTIFY wake, and the at-least-once idempotency contract. Keywords: job queue, task scheduler, ready-set, SKIP LOCKED, lease, crash-resume, multi-dialect, SQLAlchemy, background jobs. Sync-first. Not the SQLAlchemy data layer or locking primitive (sqlalchemy), not migrations (alembic).
-
equinor Bundle Neqsim Field Layout ImportEducational subsea field-layout import and normalization from supplied GeoJSON or tabular rows. USE WHEN: a task needs to turn an already-parsed subsea map (GeoJSON point features or CSV-like rows) into a clean, validated node list of wells, manifolds, and a host before geometry and routing screening.
-
zju-real Skill Officecli XLSX**用 OfficeCLI 操作 .xlsx**:建表、套公式、加图表、改单元格这类常规操作,以及数据透视表、迷你图(sparkline)、条件格式、数据验证、切片器、原生排序这类精细能力,全部走本技能——.xlsx 只有这一个入口。整片数据看板走 `officecli-data-dashboard`,公式驱动的财务模型走 `officecli-financial-model`。 Use 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.
-
zju-real Bundle Excel XLSXCreate, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation. Use when (1) the task is about Excel, `.xlsx`, `.xlsm`, `.xls`, `.csv`, or `.tsv`; (2) formulas, formatting, workbook structure, or compatibility matter; (3) the file must stay reliable after edits.
-
zju-real Skill Officecli Data Dashboard**把 CSV / 表格数据做成 Excel 数据看板**:打开即见 Dashboard 页,含多个公式驱动的 KPI 卡片、多张图表、迷你图与条件格式。单表预算 / 一次性 CSV 美化不要用它。 Use 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).
-
zju-real Skill Officecli Financial Model**用 Excel 建财务模型**:三表模型、DCF 估值、LBO、SaaS 单位经济、敏感性与情景分析、债务计划表、融资预测、IRR / MOIC / WACC,全部用活公式驱动而非写死数值。普通预算台账不要用它。 Use 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.
-
nledford Skill API DesignAPI design and contract guidance. Use when defining, changing, reviewing, or testing service or public interface contracts: HTTP/REST resources, RPC/GraphQL operations, webhooks, event/message schemas, request/response/error envelopes, pagination/filtering/sorting, idempotency, versioning/deprecation/backward compatibility, OpenAPI/AsyncAPI/JSON Schema/protobuf artifacts, SDK or CLI public surfaces, or consumer/provider compatibility. Do not use for ordinary language/framework implementation, Rust handler mechanics, SQL schema/query design, architecture boundary selection, security controls, BDD/TDD mechanics, observability instrumentation, or documentation-only API references after the contract is set; load those existing skills instead or alongside it when their trigger is primary. Use semantic-versioning when the primary question is choosing or applying a patch, minor, or major release bump after contract impact is understood.
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 excel-data-quality-check-basic, specsfy-specialist-postgres, apache-age. 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.