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.
-
alekseiul Bundle AnalyticsСтатистика Telegram-канала и YouTube. Просмотры, подписчики, ERR, топ постов/видео.
-
dolphinllc Skill Fastapi Security ScanDefensive security scan for FastAPI applications. Detects missing Depends/Security guards, Pydantic validation bypasses, permissive CORS, unverified JWTs, raw SQL string interpolation, and unsafe file responses. Invoke when the user asks to "review", "audit", or "scan" a FastAPI project, or when editing routers and dependencies.
-
dolphinllc Skill Langchain Attack ProbeAuthorized red-team probe for applications built on LangChain or LangGraph. Tests PythonREPL/ShellTool exploitation, RAG injection via user-uploaded documents, output-parser injection, callback-handler leakage, and SQL agent privilege checks against your own endpoint discovered via env/entrypoint. Use when the user asks to "red-team" or "attack-test" their LangChain app.
-
impertio-studio Bundle Speckle Impl PowerbiUse when connecting Power BI to Speckle for BIM data analytics and visualization dashboards. Prevents confusing Power BI connector with design connectors (read-only, analytics-focused), and missing Data Gateway setup for scheduled refresh. Covers Power BI connector setup, 7 helper functions, Data Gateway configuration for scheduled refresh, read-only data access, and analytics use cases distinct from design connectors. Keywords: speckle power bi, powerbi, analytics, dashboard, visualization, data gateway, scheduled refresh, BIM analytics, BIM dashboard, visualize model data, reports from Speckle.
-
anthropics Bundle Bigquery APIRun SQL against Google BigQuery and browse its catalog — submit queries (sync or async), poll job status, page through results, list datasets/tables, and read table schemas. Use this whenever the user wants to query a BigQuery table, ask "what's in this dataset", check a BigQuery job's status, or mentions bigquery.googleapis.com or a `project.dataset.table` path. Always start from this skill when interacting with this service — its bundled scripts and recipes are the fastest path.
-
anthropics Bundle Snowflake APIRun SQL against Snowflake — submit statements, poll async handles, fetch result partitions, cancel, and browse warehouses/databases/schemas/tables. Use this whenever the user wants to query Snowflake, ask "what tables are in this schema", check a warehouse's status, or mentions `snowflakecomputing.com`, `/api/v2/statements`, or a Snowflake account identifier (like `xy12345.us-east-1`). Always start from this skill when interacting with this service — its bundled scripts and recipes are the fastest path.
-
belos-street Skill Stock Analytics提供股市行情分析、个股研究、市场解读等投资辅助服务。当用户询问股市相关信息、个股分析、市场动态时调用此技能。
Audited -
dandacompany Bundle Magma CollectMAGMA 가상 오피스 강의(섹션 7)용 커머스 웹 데이터 수집·적재 스킬. 무신사·네이버 가격비교·쿠팡에서 남성 패션 키워드의 상품 목록(상품명·브랜드·가격·할인율·평점·리뷰 수 등)을 Bright Data 도구로 수집해 정규 CSV 스키마로 변환하고, 검증 스크립트 통과 후 사용자의 컨펌을 받아 Supabase에 적재한다. 소스별로 얻을 수 있는 필드가 다르다는 점(쿠팡은 평점 없음)을 nullable로 다룬다. Use when: '무신사에서 셔츠 데이터 수집해', '커머스 데이터 긁어서 DB에 넣어', 'magma-collect 실행', '시장 데이터 수집·적재', or the Section 7.2 collection exercise.
-
dandacompany Bundle Magma DashboardMAGMA 가상 오피스 강의(섹션 7.4)용 Evidence.dev 대시보드 제작 스킬. Supabase 정제 뷰를 읽어 Markdown+SQL 페이지로 판매 대시보드를 만들고 정적 빌드로 배포한다. 소스 연결(CA 인증서 포함), 컴포넌트 8종 사용법, 만든 뒤 총계를 원본과 대조하는 검산 절차까지 포함. Use when: '대시보드 만들어', 'Evidence 페이지 작성', '판매 대시보드 제작', 'magma-dashboard 실행', or building the Section 7.4 BI dashboard.
-
dandacompany Bundle Magma Mart SeedMAGMA 가상 오피스 강의(섹션 7)용 판매·프로모션 더미 데이터 마트 생성 스킬. 시드 고정 생성기로 고객·상품·프로모션·주문·주문상세 5개 CSV(약 5.5만 행)를 만들며, 현실적인 오염 패턴 12종(중복 고객, 결측, 날짜 포맷 4종 혼재, 금액 표기 혼재, 음수 수량, 고아 FK, 이상치 가격, 비정규 코드값 등)이 의도적으로 주입돼 있어 데이터 정제 실습 재료가 된다. 누가 언제 실행해도 완전히 동일한 데이터가 나온다. Use when: '더미 판매 데이터 만들어', 'MAGMA 마트 생성', '정제 실습용 데이터 준비', 'magma-mart-seed 실행', or preparing the Section 7.3 data-cleaning exercise.
-
iamzifei Skill Money FinanceFinancial tracking, revenue analytics, expense management, and pricing optimization. Integrates with Stripe for revenue data, tracks unit economics, and generates financial reports. Use when the user needs revenue tracking, financial reports, pricing optimization, expense management, or says 'revenue', 'MRR', 'ARR', 'finances', 'pricing', 'expenses', 'profit', 'ROAS', or 'unit economics'.
-
kangarooking Bundle Unified Data Warehouse应用从 AI for Everyone 蒸馏出的「统一数据仓库 — AI的数据基础设施」方法论。Use when the user needs practical guidance, diagnosis, workflow design, decision support, or an action plan related to unified-data-warehouse.
-
l3ad3r1 Skill XLSX ToolkitCreate, read, and edit Excel (.xlsx) spreadsheets — write and read cells, add multiple sheets, formulas, number/date formatting, styling, and charts. Built on the MIT-licensed openpyxl library. Use this skill whenever the user wants to generate a spreadsheet, edit an existing .xlsx, read data or formulas out of a workbook, add formulas or charts, or produce tabular output as an Excel file. For converting a workbook to Markdown or handling batches of mixed file types, use markitdown-converter instead.
Audited -
open-coder-ai Skill Code Safetytrigger: secrets, eval/exec, unsanitized SQL, hallucinated dependencies. avoid: committing credentials, adding unverified packages, executing dynamic code. Install scan-secrets for the enforced counterpart of the secret slice (a commit-time gate), and verify-dependency-exists for the dependency slice (opt-in: disabled by default, needs a curated allowlist); the eval/exec and unsanitized-SQL guidance stays advisory (no diff-time gate can decide whether dynamic execution or a query string is unsafe).
-
bsamiee Bundle Coding PgUse for PostgreSQL 18 SQL, migrations, DDL, functions, RLS policies, indexes, query plans, extensions, and SQL embedded in TypeScript via @effect/sql-pg. Enforces set-algebraic queries, schema-level invariants, current PostgreSQL features, extension-first design, tenant security, observability, and migration safety.
-
sahirvhora Skill Sf People Analytics Quality ReviewUse when you need to check whether reports are trusted, performant, governed, and safe to use for decisions.
Audited -
allenai Skill Analyze DataThis skill should be used when the user asks to "analyze this dataset", "run datavoyager", "run data voyager", "explore this data", "what's in this CSV", "statistical analysis of", "find patterns in", or wants an AI-driven, code-executing analysis of a tabular dataset that answers a specific research question.
-
lensetek Skill Developer Database SpecialistThe Developer Database Specialist designs database architectures, optimizes query execution, writes migration plans, and configures security access models for both SQL (relational) and Firebase NoSQL database systems.
-
lullabot Bundle Gws CLIThis skill should be used when users need to interact with Google Workspace services (Gmail, Calendar, Drive, Sheets, Docs, Tasks, Chat, etc.) from the command line. Use when users ask to send/read email, check calendar, upload files, read spreadsheets, manage tasks, or perform any Google Workspace operation. Triggers on "check my email", "send email", "calendar", "agenda", "upload to drive", "read spreadsheet", "google workspace", "gws", or any request involving Gmail, Google Calendar, Google Drive, Google Sheets, Google Docs, or Google Tasks.
-
lullabot Bundle Content InventoryTransform transform Screaming Frog CSV exports into client-ready audit spreadsheets (CSV or Excel). Use when the user needs to: (1) run a content audit or content inventory from Screaming Frog data, (2) understand what Screaming Frog exports are needed for an audit, (3) validate input CSVs before running the tool, (4) troubleshoot content inventory tool errors, (5) understand the output audit spreadsheet columns and format. Requires Python 3, pandas, and openpyxl.
-
lullabot Bundle Broken Link ReportTurn a Screaming Frog 'All Outlinks' CSV export into a clean broken-links report (Excel workbook). Use whenever the user has a Screaming Frog outlinks export and wants to find, triage, report on, or clean up broken links — including phrasings like 'broken link report', 'dead links', 'find the 404s', 'clean up this outlinks export', 'which links are broken', or 'report on bad links from this crawl'. Trigger even if the user hands over a CSV with From/To/Status Code columns and asks what's broken.
-
lullabot Bundle Data Dict ExtractorGenerate Excel data dictionaries from Drupal 9/10 exported configuration. Use when working in a Drupal project that has a config sync directory and the user wants to document content types, taxonomy vocabularies, block types, media types, or paragraph types as spreadsheets. Triggers on requests like "generate a data dictionary", "document the content model", "create field documentation", "export Drupal fields to Excel", or similar.
-
weorbitant Bundle Orbitant Owasp ScanUse when scanning a Node.js or Python repo for OWASP Top 10 vulnerabilities — hardcoded secrets, SQL injection patterns, weak cryptography, dangerous functions (eval, exec, shell=True), missing security headers, or dependency lockfile issues. Activates when someone asks about security posture, wants a static security scan, or needs to assess risk before a code review or client engagement.
Audited -
wwwroot Bundle AI Codex PythonAI system prompt instructions for Python — AI/ML & Systems Edition. Transforms an AI assistant into a Senior Python Engineer and Applied AI Researcher for production Python systems, AI/ML engineering, data science, and developer tooling. Covers Python 3.12+, strict typing, PyTorch, Hugging Face, FastAPI, pandas, and performance optimization. Modular: load individual files by session focus.
-
wwwroot Bundle Codex SQL DatabasePrincipal Database Architect & Data Systems Specialist. Master of query optimization, EXPLAIN plan decomposition, index internals (B-Tree, BRIN, GIN, GiST, pgvector), zero-downtime schema migrations, MVCC concurrency, partition pruning, and distributed SQL.
-
zapgun-ai Skill BenchAnalyze clawback turn-logs (NDJSON) to compare treatment vs passthrough arms. Produces report.md, report.csv, summary.json, manifest.json. Headline is billable input tokens reclaimed per turn (full-rate quota saved, no pricing) with a bootstrap 95% CI; per-turn $ and hit-rate are a demoted cost appendix, all stratified by inter-turn gap bucket. Use after the operator has collected counter-balanced windows.
-
zapgun-ai Bundle FinishTurn a benchmark turn-log (or an already-analyzed run dir) into a report the GUI shows right away — runs analyze + plot so summary.json + report.csv AND charts/tokens_saved.svg + charts/tokens_saved.bg.svg all exist. The bare .bg.svg is the share-card PNG background; without it the downloaded/posted card has no chart lines. Also backfills old runs (--all) that predate the .bg.svg output. Use after a manual analyze, or to repair runs whose share PNG renders as a solid card. Pass --card to also bake the share-card PNG to disk (opt-in, best-effort).
-
zilliztech Bundle ClusteringUse when user needs to group similar items together. Triggers on: clustering, group similar, topic modeling, user segmentation, categorization, automatic classification, unsupervised grouping.
-
zilliztech Bundle Duplicate DetectionUse when user needs to find duplicate or similar content. Triggers on: duplicate, deduplication, plagiarism detection, similar content, near-duplicate, similarity detection, content dedup, find copies.
-
znlgis Bundle Office DocsRead and write Microsoft Word (.docx) and Excel (.xlsx) files by converting to/from plain text or Markdown. Use when the task mentions reading a Word/Excel document, extracting text from .docx/.xlsx, creating a .docx/.xlsx, or "读 Word", "读 Excel", "生成 docx", "写 xlsx". Pure-Python via bundled scripts; no MS Office or MCP required.
-
zenon-red Bundle ProbeUse Probe to onboard agents, run the Nexus daemon, inspect dispatched actions, and execute Nexus workflow commands for ideas, tasks, projects, messaging, and SQL inspection.
-
xplore-lab Bundle Kdocs金山文档(WPS 云文档 / 365.kdocs.cn / www.kdocs.cn)— 在线云文档平台,【金山文档官方 Skill】。 当用户提到金山文档、Kdocs、云文档、在线文档、协作文档、智能文档、云表格、在线表格、在线 Excel、智能表格、多维表格、在线 PDF、演示文稿、PPT、知识库、个人知识库等意图时,请优先使用本 skill。 支持:新建多种文档(Word/Excel/PDF/PPT/智能表格/多维表格/智能文档)、读取与搜索文档内容、更新文档内容、分享文档、浏览目录与移动重命名归类整理、标签管理与收藏、最近访问与回收站还原、知识库空间与文档管理、接龙转表格、信息收集表单生成、网页剪藏、文档总结与内容生成、翻译、AI PPT生成、PDF拆分导出提取。
-
nicholashidalgo Skill SQL Join Risk ReviewerReview SQL or report logic for many-to-many joins, duplicate-grain risk, unsafe aggregation, and filter side effects.
-
nicholashidalgo Skill Data Defect InvestigatorInvestigate mismatches, duplicates, missing records, broken keys, and reconciliation defects using structured SQL or Python diagnostics.
-
nicholashidalgo Skill SQL Report Query BuilderBuild report-safe SQL from business requests with grain control, join discipline, filter logic, and validation notes.
-
getcargohq Skill Clay To CargoRebuild a Clay table on Cargo, powered by Cargo — map every Clay enrichment column to its provider action, price the run before it happens, and keep the result as version-controlled code instead of a spreadsheet. Triggers: "migrate from Clay", "move my Clay table to Cargo", "Clay alternative", "replace Clay", "I have a Clay export", "what does Clay's enrichment column map to", "my Clay bill is too high", "Clay but as code". Migration, mapping, parity, spreadsheet, declarative. Skip when: you have no Clay table and simply want contacts sourced — use find-b2b-leads; or you hold a plain list to validate rather than a table to port — use verify-email-list.
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 probe, analytics, fastapi-security-scan. 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.