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.
-
majiayu000 Bundle Dotnet Sqlserver Best PracticesSQL Server database design best practices, naming conventions, indexing strategies, and performance optimization for .NET applications using Microsoft.Data.SqlClient and EF Core.
567 - majiayu000 Bundle Duckdb SQL
DuckDB SQL reference for MotherDuck. Use when you need exact DuckDB syntax, function behavior, supported MotherDuck SQL features, or to resolve whether PostgreSQL-oriented SQL will fail on MotherDuck.
567 - majiayu000 Bundle Optimization
Optimize slow queries, analyze SQL performance, find expensive queries. Use when the user mentions slow queries, optimize, performance, cpu, memory, duration.
567 - majiayu000 Bundle Construction Document Ingestion
Process construction estimate documents (Excel/CSV/PDF) from Supabase and convert them to EstimationElement format. Use when users need to ingest construction estimates, DQE (Descriptive Quantitative Estimate), or devis files.
567 - majiayu000 Bundle File Conversion
Convert files between formats — PDF to Word, HEIC to JPG, MP4 to MP3, CSV to JSON, EPUB to MOBI, and 999 total routes across images, video, audio, documents, data, fonts, ebooks, and archives. Free via changethisfile.com, no API key or signup. Use when the user needs a file converted to a different format.
567 - majiayu000 Bundle Fabric Performance Monitoring
Monitor and optimize Microsoft Fabric capacity, Spark compute, and workload performance. Use when asked to check capacity utilization, diagnose throttling (HTTP 430), monitor Spark VCore consumption, analyze CU usage, review Monitoring Hub jobs, query Fabric REST APIs for capacity health, generate performance reports, tune Spark resource profiles, investigate concurrency limits, or optimize Fabric SKU sizing. Supports PowerShell, T-SQL, and REST API workflows.
567 - majiayu000 Bundle Fabric Lakehouse Views Perf Remediate
Troubleshoot Microsoft Fabric materialized lake views (MLV) performance issues including slow refresh, incremental refresh failures, full refresh fallback, Spark job failures, lineage execution errors, data quality constraint violations, and optimal refresh configuration. Use when diagnosing MLV refresh duration, monitoring MLV runs in Monitor Hub, analyzing Spark logs for MLV failures, enabling change data feed (CDF), resolving delta table not found errors, or optimizing MLV query definitions for incremental refresh eligibility. Covers Spark SQL syntax, TBLPROPERTIES, PARTITIONED BY, CONSTRAINT CHECK ON MISMATCH DROP/FAIL, and custom environment configuration.
567 - majiayu000 Bundle Fraud Investigation Data Consolidator
Investigates a suspicious transaction by gathering all related data from a BigQuery analytics dataset, consolidating it into a structured JSON format, and triggering alert workflows.
567 - majiayu000 Bundle Stats 2
This skill should be used when the user asks for "email stats", "inbox stats", "email analytics", "how many unread", or wants to see inbox metrics. Shows unread count, top senders, oldest unread, and volume trends.
567 - majiayu000 Bundle Jq 4
Use when processing JSON or YAML data from the command line. Covers jq for JSON and yq for YAML — filtering, transforming, and extracting data from structured outputs of APIs, config files, and CLI tools. USE FOR: jq, yq, JSON processing, YAML processing, CLI data transformation, filtering JSON, extracting fields, JSON to CSV, JSON arrays, jq expressions, yq expressions DO NOT USE FOR: general text processing (use grep/sed/awk via bash), XML processing, full programming (use Python or Node.js for complex transformations)
567 - majiayu000 Bundle Data Modeling 3
Designs the warehouse and semantic layer — source-to-mart structure, dimensional modeling, grain, slowly changing dimensions, and the metric layer analytics reads through. Use this to design or restructure a warehouse, model a new source, decide on grain or table structure, build a semantic or metric layer, or diagnose why queries are slow, wrong, or impossible to write.
567 - majiayu000 Bundle DB Migrate 2
Creates a database migration using Drizzle. Use this EVERY TIME you need to modify the database schema. Walks through the complete workflow including generating migration, writing SQL, running it locally, and committing ALL required files.
567 - majiayu000 Bundle XLSX 16
全面的电子表格创建、编辑和分析功能，支持公式、格式化、数据分析和可视化。当 Claude 需要处理电子表格（.xlsx、.xlsm、.csv、.tsv 等）时使用，包括：(1) 创建带有公式和格式的新电子表格，(2) 读取或分析数据，(3) 修改现有电子表格同时保留公式，(4) 电子表格中的数据分析和可视化，或 (5) 重新计算公式
567 - majiayu000 Bundle Cycle Plan 2
Plan Linear cycles using velocity analytics. Suggests scope based on historical capacity, identifies dependency risks, balances workload.
567 - majiayu000 Bundle Review 33
Pre-landing PR review. Analyzes diff against the base branch for SQL safety, LLM trust boundary violations, conditional side effects, and other structural issues. Use when asked to "review this PR", "code review", "pre-landing review", or "check my diff". Proactively suggest when the user is about to merge or land code changes.
567 - majiayu000 Bundle Background Jobs 4
Background job processing patterns including job queues, scheduled jobs, worker pools, and retry strategies. Use when implementing async processing, job queues, workers, task queues, async tasks, delayed jobs, recurring jobs, scheduled tasks, ETL pipelines, data processing, ML training jobs, Celery, Bull, Sidekiq, Resque, cron jobs, retry logic, dead letter queues, DLQ, at-least-once delivery, exactly-once delivery, job monitoring, or worker management.
567 - majiayu000 Bundle Insights 2
Show session analytics, learning patterns, correction trends, heatmaps, and productivity metrics. Computes stats from project memory and session history. Use when asking for stats, statistics, progress, how am I doing, coding history, or dashboard.
567 - majiayu000 Bundle Analytics 4
Flexible data science analytics for any dataset. Auto-discovers schema, recommends charts, exports to create-figure. Works with JSONL, JSON, CSV from any source.
567 - majiayu000 Bundle Data Analyst 4
Data analysis across SQL, visualization, statistics, and reporting. Use when writing SQL queries, building dashboards, performing cohort or funnel analysis, running hypothesis tests, or presenting data-driven recommendations.
567 - majiayu000 Bundle Data Modeling 4
Dimensional modeling, normalization, and schema design for analytics.
567 -
ecnu-icalk Skill Skill 344针对股票日度面板数据，按日期分组后，根据各指标列的30%和70%分位数筛选出底部和头部的股票代码，并横向合并为DataFrame。
559 - ecnu-icalk Skill Excel 2
用于从Excel读取文本列数据，使用K-means、DBSCAN或谱聚类等算法进行聚类，通过PCA降维进行可视化，并将结果保存回Excel的完整代码生成任务。
559 - ecnu-icalk Skill Python 22
针对包含特定字段（如车牌号、应付金额、进出时间等）的停车数据DataFrame，执行筛选、统计、比率计算及模糊匹配等操作。
559 - ecnu-icalk Skill Oracle SQL 2
根据指定的表拥有者和被授权用户，生成查询未被特定用户授权访问的数据表的SQL语句。
559 - ecnu-icalk Skill Ols 2
对数据按指定列（如年龄）进行分组OLS回归分析，提取所有自变量的系数、t值和p值，并将结果整理保存为CSV文件。
559 -
georgeqle Skill Youtube Video Audit 2Audit one YouTube video in depth using public metadata, transcript/content evidence, release timing, comments, and optional owner analytics
1 - georgeqle Skill Session Triage 2
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Session Triage 3
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Session Triage 4
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Session Triage 5
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Session Triage 6
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Session Triage 7
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Youtube Video Audit 3
Audit one YouTube video in depth using public metadata, transcript/content evidence, release timing, comments, and optional owner analytics
1 - georgeqle Skill Session Triage 8
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Session Triage 9
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1 - georgeqle Skill Session Triage 10
Investigate one immediate session, correction, repo incident, or skill failure and recommend a verified fix
1
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 dotnet-sqlserver-best-practices, duckdb-sql, optimization. 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.