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.
-
flaminis Skill Dalaran ParquetIngest tabular Parquet files into Dalaran chunk streams with dalaran.experimental.ParquetReader. Read when converting trajectory or sensor tables (LeRobot-style parquet, exported logs) into entities and components — column grouping, timeline/index columns, static columns, and lenses (DeriveLens) that assemble the typed components (Transform3D, Scalars) from the reader's grouped struct/scalar output. Builds on dalaran-chunk-processing and dalaran-data-model.
-
flaminis Skill Dalaran Chunk ProcessingCore mechanics of the Dalaran Chunk Processing API (dalaran.experimental) — LazyChunkStream pipelines, Chunk, lenses (MutateLens/DeriveLens/Selector), RrdReader, writing optimized RRDs. Read BEFORE writing any ingestion/conversion/preprocessing code (convert an MCAP, build a recording from a dataset, preprocess an .dlr, port an old converter): it mandates reader+lens pipelines and steers away from hand-built chunks — no Chunk.from_columns for data a reader/lens can produce, no per-message rr.log, no manual pa.array assembly. Source-specific knowledge lives in the importer skills (dalaran-mcap, dalaran-urdf, dalaran-parquet, dalaran-lerobot); read dalaran-data-model first to decide what the data should become.
-
francyjglisboa Skill Bdistill ExportExport a bdistill knowledge base into any format — system prompt for Claude Projects/Cursor/Copilot/ChatGPT, Python harness module with build_prompt(), JSON for agent consumption, Excel with quality color-coding, audit checklist CSV, or fine-tuning JSONL. Triggers on "export", "system prompt", "harness", "training data", "Excel export", "export for Claude Project". Outputs file on disk.
Audited -
frankglendon Bundle Research Data BindingMap explicit numeric spreadsheet cells to a single-series PowerPoint chart with confirmed mappings. Use for the portfolio data-binding workflow.
-
dajo-code Bundle PrismaType-safe database access with Prisma ORM for Node.js and TypeScript. Use when designing schemas, writing queries, running migrations, or optimizing database operations. Triggers on Prisma, database, ORM, migration, or SQL questions.
-
muhammedzohaib Skill Query ReviewReview an authorized codebase for ORM misuse, N+1 query patterns, authorization-after-fetch bugs, raw SQL risks, cache key collisions, and missing tenant scopes. Use for data-access layers and security-adjacent performance pitfalls.
-
zenml-io Bundle Kitaru DevKitaru just recipes, CLI structure and structured-output contract, analytics events, and PR-description conventions. Use when running project commands, adding CLI commands or analytics events, or writing a PR description.
-
wso2 Bundle Designing DB SchemasDesign, change, or review a database schema in the WSO2 API Platform. Use when adding or altering a table, column, index, or constraint in any *.sql schema file, reviewing schema changes before a PR, evaluating a migration plan, or asking whether a table is well designed and what indexes it needs.
-
qrcommunication Bundle Document Format ConformanceExpert des spécifications de formats documentaires — PDF (ISO 32000), PDF/A (ISO 19005), OOXML/Office (ECMA-376 / ISO 29500 : .docx .xlsx .pptx), ODF/ OpenOffice (ISO 26300 : .odt .ods .odp) et Factur-X/PDF-A3 (conteneur). Permet d'INSPECTER la structure réelle d'un fichier, de VALIDER sa conformité structurelle ET sémantique (qpdf, veraPDF, lxml/xmllint, factur-x), de MODIFIER un fichier « à la volée » en garantissant qu'il reste conforme (incremental update PDF signature-safe, patch de part OPC/ODF avec repackage valide), et d'AUDITER une codebase/un moteur qui produit ces formats contre la spec. À utiliser dès qu'apparaissent : conformité PDF, PDF/A, PDF/UA, ISO 32000, veraPDF, xref/trailer, incremental update, OOXML, ECMA-376, ISO 29500, OPC, [Content_Types].xml, docx/xlsx/pptx, ODF, ISO 26300, manifest.xml, mimetype, Factur-X, ZUGFeRD, PDF/A-3, AFRelationship, valider/réparer/modifier un PDF ou un document Office/OpenOffice, auditer un générateur de PDF/Office.
-
harumiweb Bundle XlflowUse when an AI agent needs to edit, test, debug, or validate an Excel VBA workbook with xlflow. Provides the safe source-to-workbook proof loop and routes specialized work to focused references.
-
harumiweb Bundle Xlflow Tmp Workspace E2eCreate disposable `xlflow` projects under this repository's `tmp_workspaces` directory and verify the Windows Excel COM flow end-to-end. Use when Codex needs to validate `xlflow` behavior with real workbooks, run the standard `new/init/doctor/pull/push/run/lint` workflow, confirm workbook state after macro execution, or reproduce/fix CLI integration bugs without touching the main project tree.
-
helixnow Skill Statistics ToolsSPSS 论文分析的统计执行工具组。为 `.sav`、`csv/xlsx` 等数据分析场景声明 MCP 统计后端接口,包括数据集检查、统计分析执行、结果解释与论文表格导出。适用于需要把统计执行能力按需注入到 DeepStudent 会话中的场景。
-
helixnow Skill Spss面向论文与课题写作的 SPSS 统计分析工作流。适用于 `.sav`、`csv/xlsx`、SPSS 导出结果表或截图解读场景,帮助用户先确认研究问题、变量角色、分组方式与前提条件,再组织统计执行、结果解释和论文写作输出。重点覆盖描述统计、信度、相关、t 检验、单因素方差分析、卡方和线性回归,并在信息不全时优先追问,避免模型凭列名猜测变量含义。
-
qingqishi Skill Posthog InboxCheck the PostHog inbox and query PostHog data with posthog-cli. Use when the user asks to check PostHog, the inbox, signal reports, what PostHog found, or anything about PostHog analytics, error tracking, session replay, or feature flag data.
-
skillmedev Skill SQL Query OptimizerDiagnoses slow SQL from the execution plan, names the cost driver, and delivers the rewritten query plus index DDL with the expected plan change and write-side cost stated. The general entry point for slow-query work that routes deep cases to specialist skills. Use when someone asks "why is this query slow", "can you optimize this SQL", "what index do I need", "this endpoint got slow and it's the database", or pastes an EXPLAIN output. Do NOT use for deep index strategy across a whole schema - use index-advisor instead; for pure query-shape rewrites when indexes are already right - use query-rewriter instead; for ORM-driven repeated-query patterns - use n-plus-one-hunter instead; for line-by-line EXPLAIN interpretation training - use explain-plan-reader instead; for table partitioning decisions - use partition-planner instead.
-
skillmedev Skill Clickhouse AnalyticsDesigns ClickHouse schemas and queries for fast analytics - MergeTree engine selection, ORDER BY key design, partitioning, materialized views, and projections. Use when someone asks "why is my ClickHouse query slow", "how should I order my sorting key", "should I use a materialized view or projection", "how do I deduplicate events", or is modeling an event or metrics table for OLAP. Do NOT use for tuning row-store OLTP databases like Postgres or MySQL - use sql-query-optimizer instead; for general relational schema design use database-schema; for reading query plans on traditional databases use explain-plan-reader; for the streaming ingestion side use kafka-pipelines.
-
aliyun Bundle QueryUse when answering MaxCompute data questions, writing SQL, inspecting schema for a query, using cold-start live metadata, reviewing SQL, cost-gating, executing SQL, or recording verified/failed query memory.
-
aliyun Bundle MemoryUse when recording, recalling, listing, showing, removing, clearing, or running reindex for verified/failed SQL and domain notes.
-
bhargavch19 Skill Migration SafetyAnalyze proposed schema migrations, dependency upgrades, and breaking changes for production safety. Use when adding or changing DB migrations, bumping major versions of dependencies, modifying APIs that have external consumers, or touching lockfiles. Triggers on "migration", "schema change", "upgrade dep", "breaking change", "lockfile bump", and on any diff that touches `migrations/`, `package.json`, `requirements.txt`, `Cargo.lock`, `Gemfile.lock`, `go.sum`, or `**/*.migration.sql`.
Audited -
clidey Skill Query BuilderConvert natural language questions into SQL queries. Activates when users ask data questions in plain English like "show me users who signed up last week" or "find orders over $100".
Audited -
dceoy Bundle Update Cfd InstrumentsCreate or update data/cfd_instruments.csv from GMO Click Securities and Rakuten Securities CFD lineup pages, including ticker symbols.
-
getnao Skill Setup ContextBootstrap a nao agent for a project — gather warehouse + scope + extra-context info in one round, look up the warehouse-specific config from nao docs, write nao_config.yaml, run nao init + nao sync, set up the LLM key, and generate the first RULES.md. Use when the user has just decided to use nao on a new project. Only for first-time setup; for editing rules, generating tests, or reviewing an existing context, use write-context-rules / create-context-tests / audit-context.
-
getnao Bundle Create Context TestsGenerate a test suite of natural-language → SQL pairs that becomes the quality benchmark for a nao agent, then run it via `nao test`. Use when the user wants to start measuring agent reliability, extend an existing test suite, or add tests for new metrics. Tests are the only honest answer to "is the context working?". Do not use for writing rules (write-context-rules) or diagnosing failures (audit-context).
-
glebis Skill Genome QueryQuery Obsidian vault frontmatter with SQL-like syntax. Filter, sort, group, and aggregate notes by any frontmatter field. Replaces Dataview for CLI use. Triggers on: /genome-query, "query vault", "find notes", "list genes", "show protocols", "vault stats", "vault schema", "filter by".
-
glebis Bundle Genome AnalyticsRun analysis scripts: PRS, enrichment, vault audit, PubMed monitoring, consistency checks. Triggers on: /genome-analytics, "run PRS", "audit vault", "check PubMed", "run enrichment", "check consistency", "analyze pathway".
-
gracebotly Bundle MakeMapping guidance for Make.com (Integromat) scenario events. Covers execution metrics, scenario performance, operation counts, and module analytics.
-
gracebotly Bundle RetellMapping guidance for Retell AI voice agent events. Covers call metrics, agent performance, disconnect reasons, and conversation analytics.
-
haidang1810 Skill Skill StatsShow analytics and usage statistics for Claude Code skills. Displays top skills by usage, satisfaction rates, token consumption, cost estimates, and trend alerts.
-
haidang1810 Skill Skill ExportExport skill usage data to CSV or JSON format. Includes run metrics, reactions, and version hashes for external analysis.
-
himanisharrma Bundle Collect ProductGenerate FinVerge Collect (No-Code Payments Platform) collateral — Payment Links, Pages, Buttons, Forms. Demo decks, one-pagers, FAQ documents, and feature matrices. Use whenever the user mentions creating, drafting, preparing, generating, or needing ANY kind of Collect, no-code payments, Payment Links, Payment Pages, Payment Buttons, Payment Forms, bulk links, payment landing pages, or "no developer needed" payment collateral. Triggers on phrases like "Collect demo deck", "no-code payment pitch", "Payment Links one-pager", "Payment Pages FAQ", "make a deck on our no-code platform", "bulk payment link generation pitch", "payment buttons sales sheet", and similar. Pulls from the shared Collect knowledge base. Outputs PPTX, DOCX, or XLSX.
-
himanisharrma Bundle Orchestrate ProductGenerate FinVerge Orchestrate (Payment Orchestration Platform) collateral — demo decks, one-pagers, FAQ documents, and feature matrices. Use whenever the user mentions creating, drafting, preparing, generating, or needing ANY kind of Orchestrate, payment orchestration, multi-gateway routing, gateway failover, smart routing, or "best of multiple gateways" collateral. Triggers on phrases like "Orchestrate demo deck", "payment orchestration pitch", "smart routing one-pager", "multi-gateway FAQ", "make a deck on Orchestrate for an enterprise merchant", "Razorpay vs Orchestrate comparison", "Juspay alternative pitch", and similar. Pulls from the shared Orchestrate knowledge base (which includes real extracted pricing tier tables). Outputs PPTX, DOCX, or XLSX.
-
significant-gravitas Bundle DrizzleDrizzle ORM and Drizzle Kit guidance for TypeScript database work. Use when Codex needs to create or modify Drizzle schemas, relations, queries, inserts, updates, deletes, transactions, migrations, drizzle.config files, database connection setup, relational query builder usage, SQL helpers, indexes, constraints, or validation schemas for PostgreSQL, MySQL, SQLite, SingleStore, SQL Server, Gel, CockroachDB, Neon, Turso, D1, Supabase, Vercel Postgres, PlanetScale, PGLite, or other Drizzle-supported drivers.
-
skillmedev Skill Financial Statement BuilderBuilds and interprets the income statement, balance sheet, and cash flow statement as one linked system - construction order, the three mechanical ties between statements, and the review checks that catch errors. Use when someone asks "build me a three-statement model", "why doesn't my balance sheet balance", "how does net income flow into the cash flow statement", "check this financial package for errors", or is explaining statements to stakeholders. Do NOT use for spreadsheet layout and formula hygiene - use spreadsheet-model-builder instead - for forward-looking 13-week or 12-month cash projections - use cash-flow-forecast instead - or for the monthly process that produces the trial balance - use month-end-close instead.
-
xileades Skill Pennylane AnalysisQuery Pennylane read-only and produce work lists: uncategorised transactions, invoices without a justification, supplier and customer outstandings, consistency checks, comparisons across the group's entities, analytical categories. Use when the user wants to know "what is missing", "what does not add up", a status report, a work list, an accounting situation, or a spreadsheet extract. Load the pennylane-access skill first.
-
agw-sales-ops Skill Agilecdn Billing QueryQuery and analyze AgileCDN detail billing data from StarRocks via DuckDB. Always exports to CSV before analysis. Supports basic, aggregation, time-series, customer, product, sales, account, and currency analysis.
-
agw-sales-ops Skill Oci Order Detail QueryQuery and analyze OCI order detail data from StarRocks via DuckDB. Always exports to CSV before analysis. Supports basic, aggregation, customer, sales, time-series, contract, subscription, credits, discount, and cooperation mode analysis.
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 setup-context, query, memory. 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.