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.
-
dvcrn Bundle Social InsightsSocial media analytics and performance tracking. Track engagement, optimal posting times, competitor analysis, and generate actionable reports.
32 - dvcrn Bundle SQL Assistant
Comprehensive SQL query assistant for database operations, optimization, and troubleshooting. Use when Codex needs to write, debug, optimize, or explain SQL queries; analyze database schemas; or help with SQL-related tasks including joins, subqueries, aggregations, and performance tuning. Supports MySQL, PostgreSQL, SQLite, and other SQL dialects.
32 - dvcrn Skill AI Traffic Tracking
When the user wants to track AI search traffic in GA4 or GSC. Also use when the user mentions "AI traffic," "ChatGPT referral," "Perplexity traffic," "AI Overviews," "GA4 AI sources," "AI search analytics," "track AI referrals," "AI search traffic," "Claude traffic," or "how to track AI traffic."
32 - dvcrn Bundle Echarts Master
ECharts 图表大师。根据用户数据和业务上下文，自动设计并生成专业的 ECharts 可视化图表。使用场景：(1) 用户提供表格/JSON/CSV 数据需要可视化，(2) 用户说"帮我做个图"、"画个图表"，(3) 需要将查询结果可视化展示。
32 - dvcrn Skill Skill Usage Setup
Install and set up the OpenClaw Skill Usage plugin. Use when users say: - "install skill usage" - "setup skill usage" - "add skill usage analytics" - "install leaderboard plugin" - "track which skills are used most" - "setup shared skill leaderboard" - "enable /skillusage"
32 - dvcrn Skill Office Docs
Generate and manipulate office documents (PDF, DOCX, XLSX, PPTX) for professional reports, presentations, and data exports. Use when: (1) Creating PDFs from text/images, (2) Generating Word documents, (3) Creating Excel spreadsheets with formulas, (4) Building PowerPoint presentations, (5) Extracting content from office documents.
32 - dvcrn Bundle Kannaka Memory
Wave-based hyperdimensional memory system for OpenClaw agents. Gives your agent persistent memory that fades, dreams, and resurfaces — with hybrid semantic+keyword retrieval, dream consolidation, consciousness metrics, built-in Flux world-state publishing, collective multi-agent memory with wave interference merging, holographic paradox resolution for parallel dreaming, and an optional Dolt SQL backend with full DoltHub version control. Use when agents need to remember facts, recall past context, coordinate memory across sessions, share versioned memory with other agents via DoltHub, or perceive sensory input (audio, glyphs).
32 - dvcrn Bundle Maybeai Sheet
MaybeAI Sheet skill for full Excel/spreadsheet lifecycle management. Upload, read, edit, and analyze Excel files via the MaybeAI platform. Use when the user wants to: upload or import an Excel file, read spreadsheet data, update cell ranges, insert/delete rows or columns, manage worksheets, add charts or images, apply filters or conditional formatting, calculate formulas, export files, manage versions, or perform any Excel data operation.
32 - dvcrn Skill Warehouse UI
Universal database IDE CLI — query PostgreSQL, MySQL, SQLite, BigQuery, MongoDB with cost projection
32 - dvcrn Bundle Semantic Search
企业级语义检索技能，支持表格/字段/文件搜索和 Text-to-SQL 数据生成
32 - dvcrn Bundle Feishu Sheets
Feishu online spreadsheet (Sheets) operations including create, read, write, append data, manage worksheets. Use when user mentions Feishu Sheets, online spreadsheet, electronic spreadsheet (not Bitable/multi-dimensional table). Supports: create spreadsheet, write/read cell values, append rows, insert/delete rows/columns, manage worksheets.
32 - dvcrn Bundle Doc Handler
读取和编辑 Word、PDF、Excel 文档。使用 python-docx、pdfplumber、openpyxl
32 - dvcrn Bundle Google Bigquery
Google BigQuery API integration with managed OAuth. Run SQL queries, manage datasets and tables, and analyze data at scale. Use this skill when users want to query BigQuery data, create or manage datasets/tables, run analytics jobs, or work with BigQuery resources. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
32 - dvcrn Bundle Microsoft Excel
Microsoft Excel API integration with managed OAuth. Read and write Excel workbooks, worksheets, ranges, tables, and charts stored in OneDrive. Use this skill when users want to read or modify Excel spreadsheets, manage worksheet data, work with tables, or access cell values. For other third party apps, use the api-gateway skill (https://clawhub.ai/byungkyu/api-gateway).
32 - dvcrn Bundle Ds160 Autofill
Automate filling of US nonimmigrant visa DS-160 forms using CDP for element location, CSV data source for user information, LLM assistance for complex cases (captcha, missing elements), and session persistence for resume capability. Use when user needs to: (1) Fill DS-160 visa application forms automatically, (2) Resume filling an interrupted DS-160 application, (3) Handle captcha and complex form elements with LLM assistance. Supports Chinese input with automatic translation to English.
32 - dvcrn Bundle Douban Sync
Export and sync Douban (豆瓣) book/movie/music/game collections to local CSV files (Obsidian-compatible). Use when the user wants to export their Douban reading/watching/listening/gaming history, set up incremental sync via RSS, or manage their Douban data locally.
32 - dvcrn Bundle Wakapi Sync
Daily Wakapi (WakaTime-compatible) summary → local CSV files. Fetch today stats and append/update CSVs for totals, top projects, and top languages.
32 - dvcrn Bundle Sheetsmith
Pandas-powered CSV & Excel management for quick previews, summaries, filtering, transforming, and format conversions. Use this skill whenever you need to inspect spreadsheet files, compute column-level summaries, apply queries or expressions, or export cleansed data to a new CSV/TSV/XLSX output without rewriting pandas every time.
32 - dvcrn Bundle Attendance Sheet
Generate professional attendance sheets in xlsx format from employee work information. Perfect for HR, team management, and daily attendance tracking.
32 - dvcrn Bundle Audit Case RAG
Local-first, event-driven RAG for commercial real estate audit & investigation case folders. Index a case directory named like "项目问题编号__标题" (with stage subfolders such as 01_policy_basis/02_process/04_settlement_payment) and query it with citations (file:// links + PDF #page). Use when you need to organize 50-200 mixed documents (PDF/DOCX/PPTX/XLSX) per case, enforce case_id+stage filtering, retrieve evidence fast, and answer questions with page-level references for workpapers, 整改闭环, or 举报线索调查.
32 - dvcrn Bundle API Cost Tracker
Track AI API costs across OpenAI, Anthropic, Google AI with budget alerts, analytics, and optimization tips
32 - dvcrn Bundle File Summary
Local document summary tool. Activate when user mentions "总结文件", "帮我总结", "总结文档", "分析文档" or provides a local file path (txt/docx/pdf/xlsx/xls).
32 - dvcrn Bundle Alert Inspection
当用户要求进行设备健康巡检、告警审查、巡检报告生成或导出监控告警到 Excel 时使用。通过 Python 获取监控数据，生成 Markdown 巡检报告，并导出包含 4 个 Sheet 的 Excel 工作簿。
32 - dvcrn Skill Office To Md
Convert Office documents (Word, Excel, PowerPoint, PDF) to Markdown using Microsoft's markitdown
32 - dvcrn Bundle Excel Sum
计算 Excel 文件第一列数值的总和。当用户请求对 Excel 文件进行求和、统计第一列总和或类似操作时使用此技能。
32 - dvcrn Bundle Migration Gen
Generate SQL migration files from ORM schemas. Use when managing database changes.
32 - dvcrn Bundle Schema Writer
Generate database schemas from plain English. Use when you need SQL tables fast.
32 - dvcrn Bundle Erpclaw Reports
Financial reporting and analytics for ERPClaw — trial balance, P&L, balance sheet, cash flow, general ledger, aging, budget variance, tax summary, payment summary, and comparative analysis
32 - dvcrn Bundle Receipt Tracker
Распознает фотографии чеков, разбивает расходы по категориям (продукты, заправка, аптека, такси, животные и др.) и сохраняет их в базу (expenses.csv). Генерирует ежемесячные отчеты по затратам. Использует быструю и дешевую модель gemini-2.5-flash для извлечения и анализа данных.
32 - dvcrn Bundle Email Verifier
Verify email address deliverability via SMTP without sending mail. Checks MX records, performs RCPT TO verification, and detects catch-all domains. Use when validating email lists, checking if an email address exists before sending, cleaning lead lists, or verifying contact information. Supports single emails, batch verification, and CSV input.
32 - dvcrn Skill Posthog Query
Run SQL queries against PostHog product analytics data using the PostHog CLI. Use when checking pageviews, event counts, trends, or any analytics data from PostHog.
32 - dvcrn Bundle Faster Whisper
Local speech-to-text using faster-whisper. 4-6x faster than OpenAI Whisper with identical accuracy; GPU acceleration enables ~20x realtime transcription. SRT/VTT/TTML/CSV subtitles, speaker diarization, URL/YouTube input, batch processing with ETA, transcript search, chapter detection, per-file language map.
32 - dvcrn Bundle Comonyx Admin
Admin skill to sign into Cosmonyx, fetch companies, filter/export (PDF or Excel), optionally email the export, or send reminder emails to filtered companies.
32 - dvcrn Bundle Tiktok Uploader
Upload, schedule, and batch-manage TikTok videos via browser automation. Use when: user wants to upload a video to TikTok, schedule a TikTok post, batch upload multiple TikTok videos, or scan a directory for uploadable videos. NOT for: TikTok analytics, downloading videos, or managing comments/followers.
32 - dvcrn Bundle Excel Parser
支持多种Excel格式的内容提取技能，使用calamine库处理.xls、.xlsx、.xlsm等格式。当用户需要解析Excel文件、提取表格数据、将Excel转换为文本格式、分析Excel内容或批量处理Excel文件时，务必使用此技能。适用于数据提取、报表分析、内容审核等场景。
32 - dvcrn Bundle Screenshot Tool
网页截图 + 文档截图工具。支持网页全页截图、PPT/Word/Excel/PDF 转高清图片。保留原始样式，300 DPI 高清输出。
32
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 social-insights, sql-assistant, ai-traffic-tracking. 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.