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.
-
mj-deving Bundle SecurecodingProactive secure coding — vulnerability patterns, bypass techniques, defense-in-depth for TypeScript and Cloudflare Workers. USE WHEN secure code, code security, vulnerability prevention, secure coding review, defense in depth, XSS prevention, SQL injection prevention, SSRF prevention, JWT security, access control patterns, API security patterns, secure design, security review code, prototype pollution.
-
mj-deving Bundle XLSXCreate, read, analyze Excel workbooks — formulas, financial models, data analysis, recalculation, and CSV/TSV conversion. USE WHEN xlsx, Excel, spreadsheet, formulas, financial model, data analysis.
-
rweisssieker-xp Skill Ax Migration Persona Pack GeneratorUse when generating CEO, CIO, CISO, project manager, team, or all persona packs, readiness scores, PowerPoint decks, Excel workbooks, or role-specific migration deliverables from AX to D365FO analysis outputs.
-
rweisssieker-xp Skill Ax Migration Commerce Analytics LeadUse when commerce analytics, channel KPIs, conversion, store sales, returns, loyalty analytics, or customer insights migration needs.
-
gaoqiongxie Skill Postgres ProPostgreSQL进阶诊断与性能优化:慢查询分析、EXPLAIN解读、索引调优、连接池管理、VACUUM与膨胀诊断、锁与阻塞分析、分区表策略。当用户说'Postgres'、'PostgreSQL'、'慢查询'、'EXPLAIN'、'索引优化'、'数据库性能'、'连接池'、'VACUUM'、'锁分析'、'pg_stat'、'查询优化'、'SQL优化'时触发。核心特点:从现象到根因的完整诊断链路、可落地的优化方案、与数据库设计和系统化调试联动。
-
gaoqiongxie Skill Database Designer数据库设计器:根据业务需求生成完整的 MySQL ERD、DDL 建表语句、Java Entity 代码。 支持 Mermaid ERD 图生成、规范化分析、索引优化建议、零停机迁移方案。 触发词:设计数据库、画ERD、生成建表SQL、写Entity、DDL、数据库建模、 MySQL表结构、规范表命名、索引优化、数据库迁移
-
microsoft Skill Sqlclient MigrationMigrates .NET projects from System.Data.SqlClient to Microsoft.Data.SqlClient. Use when user wants to upgrade SqlClient, migrate to Microsoft.Data.SqlClient, or modernize SQL Server data access.
2.7k -
lza6 Bundle Security Auditor在检查代码是否存在安全漏洞、实施身份验证流程、审计 OWASP Top 10、配置 CORS/CSP 标头、处理机密信息、进行输入验证、SQL 注入防护、XSS 防护或进行任何与安全相关的代码审查时使用。
-
seikaikyo Bundle Golang DatabaseComprehensive guide for Go database access — parameterized queries, struct scanning, NULLable columns, transactions, isolation levels, SELECT FOR UPDATE, connection pool, batch processing, context propagation, and migration tooling. Use when writing, reviewing, or debugging Golang code that interacts with PostgreSQL, MariaDB, MySQL, or SQLite; for database testing; or for questions about database/sql, sqlx, or pgx. Does NOT generate database schemas or migration SQL.
-
seikaikyo Bundle Golang SecuritySecurity best practices and vulnerability prevention for Golang. Covers injection (SQL, command, XSS), cryptography, filesystem safety, network security, cookies, secrets management, memory safety, and logging. Apply when writing, reviewing, or auditing Go code for security, or when working on any risky code involving crypto, I/O, secrets management, user input handling, or authentication. Includes configuration of security tools.
-
peterbamuhigire Bundle Transport InfrastructureUse when a proposal concerns roads, mobility, logistics, urban transport, infrastructure planning, asset management, or PPP advisory; use manufacturing-industrial for factory and warehouse operations.
-
peterbamuhigire Skill AI On Saas Combined MethodologyUse when one proposal must integrate multi-tenant SaaS delivery with RAG, copilots, agents, or AI analytics across shared phases and gates; use SaaS implementation methodology when the scope contains no AI feature.
-
aradotso Skill Hermes Studio DashboardWeb dashboard for Hermes Agent with multi-platform AI chat, session management, scheduled jobs, and usage analytics
-
aradotso Skill Hermes Web UI DashboardWeb dashboard for managing Hermes Agent multi-platform AI chat sessions, analytics, scheduled jobs, and platform channels
-
ingridleiria Skill Stata Data ManagementTakes raw files to an analysis-ready .dta that can be defended line by line. Covers import from csv, Excel and fixed width, the encode and destring decision, variable and value labels, Stata's numeric date representation, merge with reported match rates and a rule for every _merge value, joinby, append, reshape in both directions, duplicates and isid, missing value codes including extended missing, collapse against egen by group, xtset and panel structure checks including gaps and unbalanced panels, compress and saving with notes, and the rule that a raw file is never overwritten. Use this skill when someone is importing data into Stata, merging files, reshaping a panel, fixing identifiers that will not match, converting strings to numbers, handling missing value codes, building a panel dataset, or says the numbers changed after a merge, the observation count is wrong, or the data will not xtset. Trigger also on vague requests such as "get this into Stata", "my merge is dropping observations", or "why is my s
-
ingridleiria Skill Financial Model BuilderBuilds and audits driver-based financial models in a spreadsheet, covering three-statement, operating, unit-economics, and runway models, with every assumption in a labelled input cell, one scenario switch that moves every output, a visible checks block, and a reconciliation cell that reads zero. Enforces the rule that no number exists anywhere except as a labelled input or a live formula, so any output traces back to its drivers in under two minutes. Use this skill whenever someone wants to build, extend, or check a financial model, budget, cash flow projection, runway model, unit economics, or business case in a spreadsheet, or says model this out, what does the profit and loss look like if, build me a scenario, check my model, how long is our runway, sanity check these numbers, or asks what happens to the plan when one assumption moves. Trigger for any spreadsheet whose purpose is projecting money over time.
-
ingridleiria Skill Image To SpreadsheetImage to Spreadsheet
-
ingridleiria Skill Spreadsheet Analysis WorkbookThe discipline for analysing someone else's spreadsheet without breaking it and without trusting it blindly. Read the structure before touching anything, audit columns and existing formulas, establish one ground truth figure, build every analysis cell as a live formula reading the raw sheet, compute complements by subtraction, close a visible reconciliation cell to zero, and spot-check before delivering. This is the foundation the other workbook skills assume rather than repeat. Use it whenever a workbook, CSV export, accounting extract, or data file arrives and the task is to analyse it, add tabs, check someone else's numbers, rebuild a sheet that broke, or answer a question from it, including vague requests like "can you just pull the total", "does this add up", or "have a look at this file".
-
imtiazrayhan Skill SQL OptimizerDiagnose a slow SQL query from its execution plan and propose a verified optimization — finding the real bottleneck (sequential scan, missing or unused index, bad join order, app-side N+1) and measuring the fix before and after. Use when a query is slow and you need a fix backed by EXPLAIN ANALYZE, not a guess.
-
mr-q526 Bundle Analytics Dashboard DesignUse when the task is to design a BI dashboard, 数据大屏, analytics workspace, reporting console, KPI board, or monitoring page. Focus on question-first information hierarchy, chart choice, filter clarity, metric context, and decision-ready layout.
-
drvoss Skill Input ValidationUse when writing or reviewing code that processes user input — validates and sanitizes to prevent SQL injection, XSS, CSRF, and other injection attacks. NOT when the code path doesn't touch user-supplied data.
-
drvoss Skill Team PlannerUse when a task is too large or multi-domain for a single agent — assemble a specialist team, assign work via SQL tracking, dispatch with /fleet or task tool, and synthesize results
-
drvoss Skill Plan Mode MasteryUse when starting a complex multi-step task to create an approved plan, track todos in SQL, and execute with checkpoints
-
pa4uslf Bundle Ab Test SetupWhen the user wants to plan, design, or implement an A/B test or experiment. Also use when the user mentions "A/B test," "split test," "experiment," "test this change," "variant copy," "multivariate test," or "hypothesis." For tracking implementation, see analytics-tracking.
-
pa4uslf Skill Clickhouse IoClickHouse database patterns, query optimization, analytics, and data engineering best practices for high-performance analytical workloads.
-
openai Bundle Google SheetsAnalyze and edit connected Google Sheets with range precision. Use when the user wants to create Google Sheets, find a spreadsheet, inspect tabs or ranges, search rows, plan formulas, create or repair charts, clean or restructure tables, write concise summaries, or make explicit cell-range updates.
23.3k -
openai Bundle Comps ValuationProduce Public Equity Investing comparable-company valuation in report or workbook mode. Use for peer selection, multiple analysis, valuation read-throughs, implied prices, comps dashboards, Excel or Sheets comps, refreshable peer tables, model updates, and comps workbook QA. Do not use for DCF-only, credit-security, or generic market commentary requests.
23.3k -
openai Bundle Equity Model UpdateSafely update public-company Excel model copies from source-to-model maps; emits XLSX as the hero artifact and CSV/log/manifest as support. Do not use for pure earnings notes or broad workbook audits.
23.3k -
peterbamuhigire Bundle Finance Data Contracts And Warehouse Models---
-
peterbamuhigire Bundle Opening Balances And Migration PlaybookCutover from legacy Excel / QuickBooks / Tally / Sage / POS / manual systems into Chwezi. Defines the conversion-date model, CoA mapping, opening trial balance, opening subledgers (AR / AP / Inventory / Fixed Assets / Payroll / Tax), bank / mobile-money / cash opening balances, migration suspense, reviewer sign-off, and acceptance evidence. Use whenever a software system, SRS, SDS, test plan, proposal, or business plan involves data migration, cutover, opening balances, or legacy-system replacement.
-
lza6 Skill SQL Queries跨所有主要数据仓库方言(Snowflake、BigQuery、Databricks、PostgreSQL 等)编写正确、高性能的 SQL。在编写查询、优化慢速 SQL、在方言之间进行转换或使用 CTE、窗口函数或聚合构建复杂的分析查询时使用。
-
jcorpac Skill Sec Owasp Code ReviewPerform targeted static application security testing (SAST) focused on the OWASP Top 10 (2025). Acts as a security reviewer scanning for anti-patterns like concatenated SQL queries, missing authorization checks, hardcoded secrets, and weak hashing algorithms.
-
vuralserhat86 Bundle XLSXComprehensive spreadsheet creation, editing, and analysis with support for formulas, formatting, data analysis, and visualization. When Claude needs to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv, etc) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing data, (3) Modify existing spreadsheets while preserving formulas, (4) Data analysis and visualization in spreadsheets, or (5) Recalculating formulas
-
nandanosql Skill Funnel AnalysisBuild and analyze conversion funnels — identify drop-off points, diagnose conversion blockers, and design interventions. Covers funnel types, analysis methods, and common misinterpretations.
-
nandanosql Skill Pm Interview PrepPrepare for PM interviews — product sense, estimation, analytics, behavioral, strategy, and execution questions — with structured frameworks and practice scenarios.
-
nandanosql Skill Tam Sam Som CalculatorGuide PMs through calculating Total Addressable Market (TAM), Serviceable Addressable Market (SAM), and Serviceable Obtainable Market (SOM) using top-down and bottom-up approaches.
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 SecureCoding, Xlsx, ax-migration-persona-pack-generator. 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.