Data & Analytics

knownasnaffy Bundle

A comprehensive toolkit for Microsoft Office documents (Word, Excel, PowerPoint) and PDF files. Supports reading, writing, format conversion, and batch processing. Features: - DOCX: Read/write with styles, tables, images - PPTX: Read/write slides, extract text - XLSX: Read/write spreadsheets, formulas - PDF: Read text, create from documents - Convert: DOCX→PDF, PPTX→PDF

knownasnaffy Bundle

automate buyma order processing for regular daily runs and ad hoc order-range runs. use when chatgpt needs to access buyma in chrome, check or fill receipt memo numbers, download or use a provided buyma csv, write the tmazon order workbook, enrich rows from prior workbook history, and send the result by naver mail before a deadline or after an ad hoc request. stop immediately and notify by telegram with file attachment on buyma, csv, or mail failure.

knownasnaffy Bundle

根据历史销售数据预测未来销量并生成补货建议。核心能力：(1) 销量预测 - 基于移动平均、指数平滑、Holt-Winters、Prophet 等模型自动预测未来销量；(2) 补货计算 - 结合库存参数自动计算补货触发点和建议补货量；(3) 活动预测 - 叠加促销效应系数预测大促期间销量峰值；(4) 断货预警 - 识别高风险 SKU 并推送预警。 触发场景：用户提供历史销售数据（Excel/CSV），要求预测销量、计算补货量、备战大促、分析库存风险、生成补货计划等。也适用于用户提到"预测"、"补货"、"销量预测"、"需求预测"、"库存预测"、"大促备货"、"季节性"、"历史数据"、"销售曲线"、"备货计划"等关键词。

knownasnaffy Bundle

Intelligent QA assistant that automates writing test cases from project documentation. Use when the user wants to generate test cases from requirements, runs /init, /parse, /style, /plan, /generate, /export, or works with PDF/DOCX/XLSX requirement documents and TestRail-ready Excel export.

knownasnaffy Bundle

Analyze wearable health CSV exports (steps, heart rate, sleep, calories, SpO2, exercise, distance) and produce compact JSON reports for hourly, daily, weekly, monthly, sleep (last 30h) and cross-temporal alerts. Use when running or packaging Skill Health analyses and when explaining output semantics, data quality, or known caveats.

knownasnaffy Bundle

Local-first chart generation engine for trends, comparisons, distributions, and quick visual explanations. Use whenever the user wants to visualize data, compare numbers, plot a trend, turn CSV or JSON into a chart, or decide which chart type fits a dataset best. Generates charts locally and stores outputs in the user's workspace.

knownasnaffy Bundle

Natural language bookkeeping — parse Chinese/English expense descriptions and append to QianJi CSV. Trigger phrases: 记账, 记一笔, add expense, spent, 花了, 买了, lunch, dinner, 打车, 咖啡, or any input that looks like "[item] [amount]" or "[amount] [item]".

knownasnaffy Bundle

Generate draw.io diagrams from Mermaid, XML, or CSV code. Use this skill when the user requests any visual diagram including flowcharts, UML diagrams, ERD, architecture diagrams, mind maps, timelines, org charts, network topology, wireframes, BPMN, or any other visual representation. The skill creates a markdown link that opens the diagram in draw.io.

knownasnaffy Bundle

Expense tracking and accounting for AI agents. Log purchases, set budgets, generate spending reports, and manage multi-currency finances — all stored locally. Privacy.com card import, natural language queries, CSV/JSON export. Use when agents make purchases and need a financial audit trail.

knownasnaffy Bundle

Reconcile Indian GST invoice data with UPI transaction statements and produce audit-ready matched/unmatched reports. Use when the user asks to reconcile GST vs UPI collections, find missing payments, detect unmatched invoices, prepare month-end books, or investigate cashflow gaps from CSV exports (Tally/Zoho/ERP + bank/payment app exports).

knownasnaffy Bundle

Bidirectional file management system for OpenClaw workspaces. Organizes, indexes, and retrieves files exchanged with users via any channel. Use when: a user sends a file (PDF, image, CSV, code, dataset, etc.) and it should be saved; the agent generates a file (report, analysis, chart) to send; user asks to find, list, or search previously received/sent files; user asks "what files do I have?", "find the PDF I sent last week", or any file organization/retrieval request. NOT for: task tracking, calendar events, or non-file content like text messages.

knownasnaffy Bundle

Generate import-ready data from user-provided Excel or CSV import templates based on the customer's described business scenario. Use when Codex receives an uploaded template, workbook, or CSV and the user asks to generate, fill, mock, fabricate, prepare, or output corresponding template data, sample rows, initialization data, test data, or import content. This skill must be used whenever the user uploads a template and requests corresponding template data generation.

knownasnaffy Bundle

WOS 文献一站式工具：Web of Science 检索爬取 + PDF 批量下载，全部在同一个 Web 界面完成。 基于 Selenium 爬取 WOS 文献列表，导出 Excel 后自动调用多渠道 PDF 下载器（Sci-Hub/CORE/S2 OA/OpenAlex/Unpaywall/Publisher）。 This skill should be used when the user wants to search and download academic papers from WOS, or mentions "WOS", "Web of Science", "文献检索下载", "论文下载", "WOS爬虫".

knownasnaffy Bundle

Local-first chart generation engine for trends, comparisons, distributions, and quick visual explanations. Use whenever the user wants to visualize data, compare numbers, plot a trend, turn CSV or JSON into a chart, or decide which chart type fits a dataset best. Generates charts locally and stores outputs in the user's workspace.

knownasnaffy Bundle

Lightweight document utility designed to convert files to Markdown (MD), built specifically for intelligent agents (e.g., OpenClaw, ClaudeCode) to read and process content. Requires no external dependencies and accurately preserves document structure and formatting. Supported formats include docx, doc, pdf, ppt, pptx, xls, xlsx, jpg, jpeg, png, ceb, teb, caj, odt, ofd, cebx, odp, ott, wps, ods, et, dps, epub, chm, sdc, sdd, sdw, mobi

knownasnaffy Bundle

automate buyma order processing for regular daily runs and ad hoc order-range runs. use when chatgpt needs to access buyma in chrome, check or fill receipt memo numbers, download or use a provided buyma csv, write the tmazon order workbook, enrich rows from prior workbook history, and send the result by naver mail before a deadline or after an ad hoc request. stop immediately and notify by telegram with file attachment on buyma, csv, or mail failure.

knownasnaffy Bundle

Guide for designing and implementing a PostgreSQL database that fuses PageIndex-style document trees with LightRAG-style entity-relationship anchors. Use this skill when Claude needs to design schemas, write ingestion logic, or implement retrieval SQL for a hybrid tree-graph knowledge base, especially when converting nested tree output into relational tables.

knownasnaffy Bundle

Generate realistic test data for software testing. Create structured data sets with Chinese locale support (names, ID cards, phone numbers, addresses, bank cards). Generate SQL inserts, JSON fixtures, CSV files, and API-ready payloads. Supports Faker (Python), custom generators, and data masking/desensitization. Use when: (1) generating test data for databases or APIs, (2) creating data fixtures, (3) building test user accounts, (4) generating Chinese locale data (身份证/手机号/姓名/地址), (5) data masking/desensitization for test environments, (6) "造数据", "测试数据", "生成数据", "假数据", "mock数据", "数据脱敏", "身份证号", "手机号生成", "Faker". NOT for: production data management, data analysis, or database administration.

comeonoliver Skill

Spreadsheet Skill

knownasnaffy Bundle

A full-featured management tool for solo Traditional Chinese Medicine (TCM) practitioners. Manages patient records, medical charts (Four Diagnostic Methods, pattern differentiation, prescriptions), herbal inventory (stock-in, stocktake, low-stock alerts), appointment scheduling, and financial bookkeeping with statistics. Data stored in Excel format. Use when: the user mentions patients, medical records, prescriptions, herbs, inventory, appointments, scheduling, billing, finances, clinic, consultation fees, or needs day-to-day clinic management. NOT for: academic TCM theory discussions, formula research, or herb pharmacology analysis.

knownasnaffy Bundle

This skill should be used when a user needs to analyze financial statements (Income Statement, Balance Sheet, Cash Flow Statement) from Excel or CSV files. It extracts financial data and calculates key metrics such as ROE, ROA, gross margin, and net margin. Trigger scenarios include requests like "analyze this financial report", "calculate ROE/ROA", "what's the gross margin", or any task involving reading and interpreting financial spreadsheets.

knownasnaffy Bundle

大数据开发工程师级数据分析与SQL技能。(1)多数据引擎SQL编写(Hive/SparkSQL/Presto/ClickHouse/Doris/MySQL/PG/BigQuery)。(2)复杂SQL改造调试与性能优化。(3)数仓建模(ODS/DWD/DWS/ADS)维度设计/SCD变更。(4)数据探查/指标设计/ETL管线编排。(5)数据质量检测与异常分析。(6)SQL改写(方言迁移/语法适配)。(7)UDF/UDTF开发规范。(8)表结构文档自动生成与迁移支持。(9)知识库目录生成与维护(schema/metrics/relations/enums)。触发:写SQL/改SQL/数仓建模/ETL/SQL优化/数据质量/指标设计/整理文档/生成md/迁移文档/知识库

knownasnaffy Bundle

Backtest stock trading strategies on historical OHLCV data and report win rate, return, CAGR, drawdown, Sharpe ratio, and trade logs. Use when evaluating or comparing strategy rules (SMA crossover, RSI mean reversion, breakout), quantifying transaction-cost impact, tuning parameters, or generating performance summaries from CSV data. Trigger for requests like "回测股票策略胜率", "测收益率", "compare two strategy backtests", and "build a strategy report from historical prices".

knownasnaffy Bundle

A full-featured management tool for solo Traditional Chinese Medicine (TCM) practitioners. Manages patient records, medical charts (Four Diagnostic Methods, pattern differentiation, prescriptions), herbal inventory (stock-in, stocktake, low-stock alerts), appointment scheduling, and financial bookkeeping with statistics. Data stored in Excel format. Use when: the user mentions patients, medical records, prescriptions, herbs, inventory, appointments, scheduling, billing, finances, clinic, consultation fees, or needs day-to-day clinic management. NOT for: academic TCM theory discussions, formula research, or herb pharmacology analysis.

knownasnaffy Bundle

华为云Config配置审计服务的专业助手,提供全局资源查询、资源配置查询、资源Schema查询、SQL条件查询以及合规规则查询能力。当用户需要查询华为云资源、进行资源审计、检查配置合规性、盘点云上资产、分析资源关系、查询特定资源状态、验证资源配置、或需要通过SQL进行复杂资源查询时,必须使用此技能。即使未明确提及"Config"或"配置审计",只要涉及华为云资源查询、资源管理、合规检查等场景,都应触发此技能。

knownasnaffy Bundle

Manage Control D DNS filtering service via API. Use for DNS profile management, device configuration, custom blocking rules, service filtering, analytics settings, and network diagnostics. Triggers when user mentions Control D, DNS filtering, DNS blocking, device DNS setup, or managing DNS profiles.

knownasnaffy Bundle

Analyze exported bank/credit card CSV files locally to track spending, categorize transactions with LLM reasoning, compare against user-defined budgets, and generate markdown reports. Use when the user mentions budgeting, spending analysis, finance tracking, bank statements, credit card exports, CSV transactions, monthly spending, or wants to know where their money is going. Fully local — no third-party APIs, complete privacy. Triggers on words like budget, spending, transactions, bank CSV, credit card export, finance report, monthly expenses.

knownasnaffy Bundle

During peak sales (Black Friday, Cyber Monday, Singles' Day, flash sales), align hot-SKU remaining inventory with live ad spend—surface sell-through risk, auto-style Pre-order messaging when stock crosses a threshold, and produce supplier restock chase communications. Use this skill whenever the user mentions inventory under ~20% while ads still run, the last 24 hours before a major promo, oversell risk, cutting Meta/Google/TikTok when stock is thin, switching PDP to pre-order, or supplier expedite emails—even if they only say "we might stock out during the sale" or "ads are still on but warehouse is low." Also trigger on safety stock breaches, SKU-level pacing, and multi-channel inventory sync. Do NOT use for annual financial inventory audits with no live promo or ads context, pure demand forecasting with no immediate copy or comms need, or legal product compliance for pre-orders in regulated categories without the user asking for operational templates.

knownasnaffy Bundle

Optimize LLM token usage and API costs for the openclaw-manager proxy platform. Provides model-tier routing (route simple prompts to glm-4.7-flashx instead of glm-4.7), heartbeat cost reduction (force heartbeat calls to use the cheapest model with optimized intervals), context lazy loading (generate optimized AGENTS.md that loads only necessary context files per prompt complexity), and platform-level usage analytics (query real usage_records from PostgreSQL to generate reports and quota-matching advice). Use this skill whenever the user mentions token optimization, reducing API costs, model routing, heartbeat optimization, context loading strategy, usage reports, quota analysis, or anything related to saving money on LLM API calls in the openclaw-manager project. Also trigger when the user asks about which model to use for different task types, or wants to analyze per-instance token consumption patterns.

knownasnaffy Bundle

Buy Xcatcher points via x402 on Solana USDC, obtain an API key, create X crawl tasks, poll status, and download XLSX results.

knownasnaffy Bundle

Mine historical orders for multi-SKU co-purchase patterns, quantify association strength between SKUs, and produce high-converting bundle and Frequently-Bought-Together (FBT) recommendations—including "if buy A then suggest B" logic chains, discount copy, and checkout hooks. Use this skill whenever the user mentions raising AOV, bundle design, FBT modules, cross-sell from order data, market-basket style rules, "what to pair with SKU X," Shopify bundle apps, or wants association coefficients from exports—even if they only say "customers who buy this also buy…" or paste a line-items CSV. Also trigger on PDP bundle blocks, cart upsell logic, and wholesale kit planning from purchase history. Do NOT use for single-SKU costing with no basket analysis, pure creative naming with no order data or methodology, or legal/compliance review of regulated product bundles.

knownasnaffy Bundle

Expense tracking and accounting for AI agents. Log purchases, set budgets, generate spending reports, and manage multi-currency finances — all stored locally. Privacy.com card import, natural language queries, CSV/JSON export. Use when agents make purchases and need a financial audit trail.

knownasnaffy Bundle

Mine historical orders for multi-SKU co-purchase patterns, quantify association strength between SKUs, and produce high-converting bundle and Frequently-Bought-Together (FBT) recommendations—including "if buy A then suggest B" logic chains, discount copy, and checkout hooks. Use this skill whenever the user mentions raising AOV, bundle design, FBT modules, cross-sell from order data, market-basket style rules, "what to pair with SKU X," Shopify bundle apps, or wants association coefficients from exports—even if they only say "customers who buy this also buy…" or paste a line-items CSV. Also trigger on PDP bundle blocks, cart upsell logic, and wholesale kit planning from purchase history. Do NOT use for single-SKU costing with no basket analysis, pure creative naming with no order data or methodology, or legal/compliance review of regulated product bundles.

knownasnaffy Bundle

automate buyma order processing for regular daily runs and ad hoc order-range runs. use when chatgpt needs to access buyma in chrome, check or fill receipt memo numbers, download or use a provided buyma csv, write the tmazon order workbook, enrich rows from prior workbook history, and send the result by naver mail before a deadline or after an ad hoc request. stop immediately and notify by telegram with file attachment on buyma, csv, or mail failure.

comeonoliver Skill

Cube — Semantic Layer for Analytics

comeonoliver Skill

Ibis — Portable Python Analytics