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.
-
oceanbase Skill Observer Log Analysis标准 SOP:OceanBase 集群侧(observer/election/rootservice)日志采集、过滤与 analyze 解读。用户要收集日志、trace_id/关键词过滤、分析错误栈或慢 SQL 在 observer 日志中的线索时使用。OBProxy 日志请用 obproxy-log-analysis。
-
oceanbase Skill Observer SQL Analysis标准 SOP:单条 SQL 性能、执行计划、trace 计划包、锁等待。用户问「为什么慢」、提供 trace_id、或描述锁/超时时使用;与 obdiag-performance(整体 ASH/AWR)、observer-log-analysis(observer 日志链)分工。
-
oceanbase Skill Oms Kafka Performance标准 SOP:OceanBase 社区版经 OMS 同步至 Kafka 的延迟、吞吐与调优。涵盖全量/增量并发与限速、KafkaSink、OMS 平台 limitator 与 JVM、源端 OB 与表结构策略;与 observer 日志、OBProxy、单条 SQL 深查 skill 分工明确。
-
kakarot-oncloud Bundle SQL Query ExpertWrites, optimizes, debugs, and explains SQL queries across PostgreSQL, MySQL, SQLite, and SQL Server. Handles joins, window functions, CTEs, indexes, and query plans. Use this skill when the user asks to "write a SQL query", needs help with joins/aggregations/window functions, wants to optimize a slow query, or asks to explain what a SQL statement does.
-
kakarot-oncloud Bundle Migration PlannerPlans database schema migrations safely — produces up/down SQL, identifies risky operations (locks, downtime, data loss), and suggests zero-downtime patterns (expand/contract, backfills, dual-writes). Use this skill when the user asks to "add a column", "rename a table", "change a constraint", needs a migration script, or asks how to migrate without downtime.
-
kenmulford Bundle WbsGenerate a Project+ style Work Breakdown Structure (WBS) as a .xlsx, decomposing project deliverables into a hierarchy of work packages with codes, owners, effort estimates, and durations. Use whenever a user needs to break a project into plannable chunks — triggers include "WBS", "work breakdown structure", "work packages", "project decomposition", "break down the project", "deliverables hierarchy", "scope decomposition", or any context where a PM is turning a charter into plannable work. Enforces Project+ WBS conventions (100% rule, 8–80 hour work packages, hierarchical numbering) and prevents fabrication of work packages, owners, or estimates the user never stated.
-
kenmulford Bundle Raci MatrixGenerate a Project+ style RACI (Responsibility Assignment Matrix) as a .xlsx, mapping project activities to team members with R/A/C/I assignments. Use whenever a user needs to clarify *who does what* — triggers include "RACI", "responsibility matrix", "RAM", "who owns what", "role clarity", "accountability matrix". Enforces Project+ RACI rules (exactly one A per row, ≥1 R) and prevents fabrication of people or activities.
-
kenmulford Bundle Team RosterGenerate a Project+ style team roster as a .xlsx listing every known project team member with role, responsibilities, availability, manager, contact, and core/extended status. Use whenever a user needs to capture "who is on the project" in a structured artifact — triggers include "team roster", "project team", "staffing plan", "team structure", "who's on the project", "team list", "resource roster", or any context where a PM is standing up a team. Enforces Project+ conventions and prevents fabrication of people, titles, or details the user never stated.
-
kenmulford Bundle Decision LogGenerate a project decision log as .xlsx — one row per binding decision with ID, title, decision maker, date, context, options considered, decision, rationale, consequences, and review date. Use whenever a user needs a decision log, decision record, ADR, architectural decision record, choice history, or governance trail. Triggers include "decision log", "decision record", "ADR", "decision history", "document this decision", "what did we decide". Enforces never-invent discipline for decision makers, rationale, and options considered.
-
ok-helloworld Skill File Agent负责文件类漏洞检测:路径穿越/LFI/RFI/LFI→RCE、任意文件上传、文件包含、 任意文件下载、Zip Slip、SVG/CSV 注入、PHP Wrapper 利用、PEARCMD RCE、 编辑器路径利用、敏感文件泄露与文件解析链风险。
-
ok-helloworld Bundle Sqli SQL InjectionSQL injection playbook. Use when input reaches SQL queries, authentication logic, sorting, filtering, reporting, or DB-specific blind and out-of-band execution paths.
-
ok-helloworld Bundle Ghost Bits Cast AttackJava "Ghost Bits" / Cast Attack playbook (Black Hat Asia 2026). Use when attacking Java services where 16-bit char is silently narrowed to 8-bit byte to bypass WAF/IDS for SQL injection, deserialization RCE, file upload (Webshell), path traversal, CRLF injection, request smuggling, and SMTP injection. Affects Tomcat, Spring, Jetty, Undertow, Vert.x, Jackson, Fastjson, Apache Commons BCEL, Apache HttpClient, Angus Mail, JDK HttpServer, Lettuce, Jodd, XMLWriter and re-enables many "patched" CVEs through WAF bypass.
-
rene-kuhm Skill DB MigrationGenerar y validar migraciones de base de datos. Soporta Prisma, Drizzle, TypeORM y migraciones SQL raw.
-
vietanhdev Bundle XLSXCreate, read, and modify Excel (.xlsx) spreadsheets using Python libraries openpyxl and pandas.
-
vietanhdev Skill Data AnalysisPerform data analysis and generate visualizations using Python (Pandas, Matplotlib, Seaborn). Supports CSV, JSON, and Excel formats.
Audited -
orchardcms Bundle Orchardcore Data MigrationCreates and updates OrchardCore data migrations (DataMigration classes with CreateAsync/UpdateFromX). Use when the user needs to alter content type definitions, create or change SQL index tables, patch existing content items, run a recipe migration, or version a module's schema.
-
orchardcms Bundle Orchardcore Query IndexingWorks with OrchardCore queries and indexing — SQL/Lucene/Elasticsearch queries, full-text index profiles, content part/field index handlers, and search. Use when the user needs to define a query, index content for search, write an index handler, register an indexing source, or add query/index recipe steps.
-
patolojiai Bundle Pathology Report CheckerAnalyzes surgical pathology cancer reports for compliance with CAP (College of American Pathologists) and ICCR (International Collaboration on Cancer Reporting) guidelines. Validates pTNM staging (AJCC 8th edition), checks required element completeness with severity-based scoring, generates blank or pre-filled CAP synoptic templates, creates 3-5 line tumor board summaries, suggests SNOMED CT and ICD-O-3 codes, converts free-text narratives to structured synoptic format, and drafts amendments/addenda. Use when the user pastes or uploads a pathology report (txt, pdf, docx, image, xlsx) and asks to "check CAP compliance", "verify staging", "generate synoptic template", "tumor board summary", "convert to synoptic", "calculate TNM stage", or "code with SNOMED" for breast invasive carcinoma, colorectal resection, exocrine pancreas carcinoma, or gastric carcinoma. Supports English and Turkish. Do NOT use for non-cancer pathology (inflammatory, infectious), cytology, or unsupported tumor types.
-
sasanniroo Bundle XLSX“面向电子表格(.xlsx、.xlsm、.csv、.tsv 等)的创建、编辑与分析”,支持公式、格式、数据分析与可视化。当 Claude 需要(1)创建带公式与格式的新表格,(2)读取或分析数据,(3)在保留公式的前提下修改已有表格,(4)在表格内做数据分析与可视化,以及(5)重新计算公式时,请使用本技能。
-
skills-il Bundle Israeli Receipt ScannerOCR and parse Israeli receipts and invoices with Hebrew and English text extraction. Extracts merchant name, date, total amount in NIS, VAT amount, receipt or invoice number, payment method, and VAT registration number (osek murshe). Handles common Israeli retail formats including supermarkets, gas stations, restaurants, and online purchases. Auto-categorizes expenses into standard Israeli accounting categories and outputs structured JSON or CSV ready for import into accounting software. Use when you need to digitize, extract data from, or categorize Israeli receipts and tax invoices. Do NOT use for non-Israeli receipt formats, handwritten notes without printed text, or bank statement reconciliation.
-
skills-il Bundle Israeli Financial ReportsGenerate Israeli-standard financial reports including profit and loss (Doch Revach VeHefsed), balance sheet (Maazan), trial balance (Maazan Bochein), and cash flow statements. Supports bilingual Hebrew/English output with NIS formatting, VAT summary reports for bi-monthly and monthly filing, year-end annual report preparation, and comparison periods. Works with Osek Patur, Osek Murshe, and Chevra (company) business types. Reflects the Israeli accounting-standards regime where full IFRS is mandatory only for public companies while private companies may use Israeli GAAP or IFRS for SMEs. Use when you need to produce financial statements, tax-related summaries, or periodic reports for Israeli businesses. Exports to PDF, Excel, and CSV formats. Do NOT use for tax filing submissions, payroll processing, or bank reconciliation workflows.
-
skills-il Bundle Gws Israeli Business SheetsGoogle Sheets financial tracking and automation for Israeli freelancers and small businesses using the Google Workspace CLI (gws). Use when user asks to create income/expense sheets with Shekel formatting, track VAT (18%) calculations, generate tax-period summaries for accountants, backup spreadsheets as CSV, or auto-log payments. Do NOT use for direct bank API integrations, payroll processing, or filing taxes with the Israel Tax Authority.
-
splunk Bundle Splunk SearchRun bounded Splunk SPL searches through the splsearch CLI, save large result sets as local SQLite tables, and inspect those saved tables with focused summaries, text search, ordered events, or bounded SQL.
-
endika Bundle GdprUse when building, shipping, or auditing one of my B2C apps for GDPR/privacy — classify the data posture (offline / Supabase-backed / ships-to-AI-processor), run the decision gates (personal data? lawful basis? processor DPA? transfer? minimization? DSR/erasure?), add a privacy notice, and add privacy-first cookieless analytics without triggering consent. EU GDPR; references security-bar for the controls.
-
fusion-data-company Skill Deal PacketProduce the full institutional deal packet for a deal — Excel underwriting model + Word IC memo + PowerPoint deck + PDF one-pager — all firm-branded, fully cited, and cross-linked to one sources registry. Use when the user says "build the packet," "full workup," "put together the IC package," "model this deal," or wants the complete set of deliverables.
-
jeffbrines Skill Fpa Excel ModelUse when the user wants their model in Excel with real working formulas - "export this to Excel", "a workbook I can hand my board", "something that recalculates when I change an assumption". Produces a live-formula workbook generated from the model structure and verified against the engine before delivery.
-
itou-daiki Skill Database ReviewerPostgreSQL database specialist for query optimization, schema design, security, and performance. Use PROACTIVELY when writing SQL, creating migrations, designing schemas, or troubleshooting database performance. Incorporates Supabase best practices.
-
zhu1090093659 Skill OfficecliCreate, analyze, proofread, and modify Office documents (.docx, .xlsx, .pptx) using the officecli CLI tool. Use when the user wants to create, inspect, check formatting, find issues, add charts, or modify Office documents.
-
zhu1090093659 Skill Officecli XLSXUse 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.
-
zhu1090093659 Skill Officecli Data DashboardUse 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).
-
zhu1090093659 Skill Officecli Financial ModelUse 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.
-
0xranx Bundle Data AnalysisLoads CSV, Excel, and JSON data files, performs statistical analysis, and generates charts and reports. Use when the user asks to analyze a dataset, compute statistics, create visualizations, find trends, or produce a data report.
-
qfeius Bundle Make AI AssistantUse when integrating, generating, refactoring, reviewing, or debugging 助手 / AI助手 / MakeAI AI 助手 / Make AI 助手 / AI 对话框 with @qfei-design/make-ai-assistant, Artifact, SSE, Agent Gateway, make-ai-assistant 包, including floating launcher, AssistantPanel/ArtifactRenderer, MakeAiTheme/theme variables, responsive assistant sizing and resize, maxDrawerWidth, headerHeight, privacyNotice Tooltip, user identity/avatar, Artifact V1 templates, capabilities negotiation, Make App adapter, Make Console adapter, history restore, mock/demo transport, action intents, interface domain configuration, and tests. Does not own generic dialogs, business Agent prompts, model reasoning, Make data APIs, auth policy, runtime packaging, DSL modeling, Make CLI execution, or project-specific analytics.
-
qualcomm Bundle Etl GeneratorRun a target program under a CPU-sampling profiler and produce an ETL trace file for later performance analysis. Keywords - collect ETL, profile a program, generate etl, capture CPU trace, record ETL.
-
qualcomm Bundle Perf OptimizerPerformance bottleneck root-cause analysis tool. Parses SpeedScope JSON flame graphs, traces back the call chain to the true root-cause module (not just the most expensive leaf), then combines that with user-provided source paths to pinpoint hotspots, and lets the model produce targeted optimization suggestions based on context. Two input modes are supported: 1. **SpeedScope JSON** (proceeds straight to Phase 1) 2. **ETL file** (first follow the `perf-sampling-parser` skill instructions in the current agent context to analyze per-process CPU usage; the user picks the target process and exports a SpeedScope JSON, then proceeds to Phase 1) **The target process is NOT specified up front by the user**: when the input is an ETL, do NOT ask the user "which process do you want to analyze" before following the perf-sampling-parser workflow. The target process must be chosen by the user based on real data — the process tree and Top-N CPU breakdown produced by perf-sampling-parser. Triggers: - The user asks to analyze
-
qualcomm Bundle Perf Sampling ParserAnalyze per-process CPU usage from ETL log files and export SpeedScope flame graphs. Keywords - ETL, flame graph, CPU usage, speedscope.
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 migration-planner, database-reviewer, gdpr. 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.