Data & Analytics

knownasnaffy Bundle

local document summary & analysis tool. triggers: 帮我总结, 总结文件, 分析文档, 分析总结, 总结一下, 分析一下 summarize for me, analyze for me, summarize the file, analyze the document, file summary, document analysis Supported formats: txt, docx, pdf, xlsx, xls ⚠️ Privacy Note: Extracted content will be sent to OpenClaw LLM for summary/analysis — DO NOT use with sensitive/confidential files.

knownasnaffy Bundle

Generates Word (.docx) reports and Excel (.xlsx) workbooks as real downloadable files. Use when the user wants a file output — not a text answer — for SMSF, accounting, compliance, or business document workflows. Triggers include: "create a Word doc", "make an Excel spreadsheet", "generate a report", "draft a trustee summary", "build a budget workbook", "I need a .docx / .xlsx file". Do NOT trigger for plain-text answers, inline tables, or when no file is requested.

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

大数据开发工程师级数据分析与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

**触发词**: 用户发送 "复盘 [日期]" 或 "复盘A股 [日期]" 时触发此技能。 抓取 A 股大盘快照和全市场股票分组数据，输出指数 K 线、成交额、市场情绪、风格指数、涨跌幅分布以及涨幅榜、跌幅榜，并按固定模板生成市场日报（纯文本格式）。 用于用户要求获取某日市场快照、生成 snapshot JSON/CSV、绘制三指数 120 日 K 线图、输出结构化盘后总结时。 **触发示例**: - "复盘" → 获取今日（或最近交易日）市场快照 - "复盘 2026-03-13" → 获取指定日期市场快照 - "复盘 2026/03/13" → 获取指定日期市场快照

knownasnaffy Bundle

Explore Web3 on-chain data using Chainbase APIs. Use this skill when the user asks about blockchain data, token holders, wallet addresses, token prices, NFTs, ENS domains, transactions, DeFi portfolios, or any on-chain analytics. Triggers include: "top holders of", "who holds", "wallet address", "address labels", "token price", "token transfers", "NFT owners", "ENS domain", "on-chain data", "blockchain query", "SQL query on-chain", or any request to look up, analyze, or explore Web3/blockchain data across Ethereum, BSC, Polygon, Arbitrum, Optimism, Base, Avalanche, zkSync, and other EVM chains.

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

Korean Exchange (KRX) stock market data CLI. Fetch daily OHLCV, latest-close snapshots, market-cap rankings, index histories (KOSPI/KOSDAQ/KOSPI200/KRX100), and ticker↔name lookups for KOSPI/KOSDAQ/KONEX/ETF tickers. Use when a user asks for Korean stock prices, ticker resolution, or KRX market data in JSON or CSV. No API key required.

knownasnaffy Bundle

Manage Cloudflare domains, DNS records, SSL settings, zone configuration, firewall rules, tunnels, and analytics via the Cloudflare API. Use when the user asks to set up a domain, add/edit/delete DNS records, configure SSL, check zone settings, manage Cloudflare Tunnels, view analytics, or any Cloudflare account management task.

knownasnaffy Bundle

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

knownasnaffy Bundle

基于东方财富数据库，支持自然语言查询全球宏观经济数据，涵盖国民经济核算、价格指数、货币金融、财政收支、对外贸易、就业民生、产业运行等多个领域，适配各类宏观经济研究、市场分析、政策解读等多元专业场景需求。返回结果包含数据说明及 csv 文件。Natural language query for macroeconomic data from financial databases, covering national economic accounting, price indices, monetary finance, fiscal revenue and expenditure, foreign trade, employment, industrial operation, and other fields. It supports diverse scenarios including macroeconomic research, market analysis, and policy interpretation.

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

Scrape Amazon Brand Analytics (ABA) weekly hot keyword rankings from AMZ123 and return structured keyword trend data. Use when the user asks about Amazon keyword rankings, hot search terms, keyword trends, ABA data, or wants a CSV/JSON of popular Amazon search terms. Trigger phrases include: 'hot keywords', 'search term rank', 'keyword trend', 'Amazon keyword', 'ABA data', '热搜词', '关键词排名', '关键词趋势'.

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

Perform bank reconciliation between bank statement and general ledger Excel files. Supports custom thresholds for amount matching and semantic description matching. Use when the user wants to reconcile financial records, find matching transactions, and generate a reconciliation report in Excel.

knownasnaffy Bundle

Protects sensitive files (contracts, transaction data, personal/customer privacy) by performing deep content inspection for text and binary formats (PDF, DOCX, XLSX) before any read, search, or send operation.

knownasnaffy Bundle

Design, analyze, optimize and evolve database schemas. Use when the user asks to design schemas from scratch, choose between SQL and NoSQL engines, analyze or fix an existing schema (normalization, naming, constraints), plan index strategy, generate migration scripts, or interpret EXPLAIN plans.

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

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

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

Interact with PostHog analytics via its REST API. Capture events, evaluate feature flags, query data with HogQL, manage persons, insights, dashboards, experiments, surveys, cohorts, annotations, and session recordings. Use when the user mentions "PostHog", "PostHog API", "PostHog events", "PostHog feature flags", "PostHog insights", "PostHog query", "HogQL", "PostHog persons", "PostHog dashboards", "PostHog experiments", "PostHog surveys", "PostHog cohorts", "PostHog recordings", "capture events PostHog", or "PostHog analytics".

knownasnaffy Bundle

Programmatic backtesting framework for trading strategies. Runs backtests with historical price data (yfinance or CSV), supports momentum/mean-reversion/factor/signal-based strategies, walk-forward optimization, out-of-sample testing, transaction cost modeling, regime-aware splits, and full performance metrics (Sharpe, Sortino, Calmar, max drawdown, CAGR, win rate, profit factor). Distinct from einstein-research-backtest (which provides methodology guidance). Use when a user wants to actually run a backtest, test a specific strategy on historical data, or generate performance metrics.

knownasnaffy Bundle

Bilingual Xianyu (闲鱼) listing and lightweight operations workflow for second-hand goods, side-hustle products, and marketplace distribution. Use when the user wants to create, optimize, or batch-produce Xianyu listing assets such as titles, selling points, product descriptions, image prompts, reply scripts, pricing angles, posting checklists, or simple operating SOPs in Chinese and English. Also use when the user asks to turn product info or CSV-like SKU data into publish-ready marketplace materials, wants category-specific Xianyu templates, needs buyer chat replies, or wants a reusable batch-oriented Xianyu sales process for physical goods, digital products, or AI services.

knownasnaffy Bundle

This skill provides comprehensive file format conversion capabilities. It should be used when users need to convert files between different formats, including PDF to Word, Word to PDF, image format conversions (PNG/JPG/WebP/BMP/GIF/TIFF), and Excel/CSV bidirectional conversion. Supports both single file and batch processing. Trigger keywords: 转换, convert, 格式转换, PDF转Word, Word转PDF, 图片转换, Excel转CSV, CSV转Excel.

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

基于东方财富数据库，支持自然语言查询金融数据，覆盖A港美、基金、债券等多种资产，含实时行情、公司信息、估值、财务报表等，可用于投资研究、交易复盘、市场监控、行业分析、信用研究、财报审计、资产配置等场景，适配机构与个人多元需求。返回结果包含数据说明及 xlsx 文件。Natural language query for financial data across all markets, including A-shares, ETFs, bonds, Hong Kong and US stocks, and funds. It provides L1/L2 data, financial indicators, company profiles and valuation metrics. Ideal for investment research, strategy backtesting, market monitoring and industry analysis. It meets the needs of diverse institutions and individuals.

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

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

Comprehensive YouTube channel management with video publishing, data analytics, and report generation. Use when user mentions 'YouTube data', 'channel analysis', 'video statistics', 'monitor YouTube', 'YouTube reports', 'publish video', 'upload YouTube', or needs end-to-end YouTube workflow automation including video uploads, performance monitoring, and analytics reporting.

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

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

Format, minify, and lint SQL queries from the command line. Formats SQL with proper indentation and keyword casing, minifies by removing whitespace and comments, and lints for common anti-patterns (SELECT *, inconsistent casing, missing semicolons, trailing whitespace). No external dependencies — pure Python. Use when formatting SQL queries, cleaning up SQL files, minifying SQL for production, or checking SQL quality.

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.

knownasnaffy Bundle

OCR-based receipt tracker for expense, travel, freelance logging using tesseract. Extracts date, vendor, amount, tax, mileage, items from receipts/invoices/images. Outputs structured JSON/CSV. Use for

knownasnaffy Bundle

Automated test case generation from project documents. This skill should be used when generating structured test cases from requirements documents, API specifications, or project documentation. It extracts test variables, analyzes embedded images and flowcharts, creates flow diagrams, performs path coverage analysis, and outputs Excel test case files following standard templates.

knownasnaffy Bundle

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