Data & Analytics

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

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

基于东方财富数据库，支持自然语言查询全球宏观经济数据，涵盖国民经济核算、价格指数、货币金融、财政收支、对外贸易、就业民生、产业运行等多个领域，适配各类宏观经济研究、市场分析、政策解读等多元专业场景需求。返回结果包含数据说明及 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

Manipulate CSV files from the command line — view, filter, sort, select columns, convert CSV to/from JSON, compute statistics, deduplicate, and merge files. Use when the user needs to work with CSV data, inspect a spreadsheet export, clean up tabular data, convert formats, or get quick column stats. Zero external dependencies.

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

Full production-grade migration of a Dialogflow CX agent (v3beta1) to Google Customer Engagement Suite (CES) Conversational Agents. Migrates flows→sub-agents, pages→instructions, intents→routing hints, entity types, webhooks→tools, and test cases→golden evaluations CSV. Includes retry logic, dry-run mode, and a complete migration report.

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

基于东方财富专业数据库，支持自然语言查询金融数据，覆盖A股、ETF、债券、港美股、基金等全品类资产，含实时行情、公司信息、估值、财务报表等，数据实时、权威、全面，可用于投资研究、交易复盘、行业分析、信用研究、财报审计、资产配置、报告撰写等场景，一站式满足机构与个人投资分析、市场监控、数据检索等需求。返回结果包含数据说明及 xlsx 文件。

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港美、基金、债券等多种资产，含实时行情、公司信息、估值、财务报表等，可用于投资研究、交易复盘、市场监控、行业分析、信用研究、财报审计、资产配置等场景，适配机构与个人多元需求。返回结果包含数据说明及 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

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

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

Convert CSV files to professionally formatted Excel workbooks with Chinese character support, automatic formatting, and multi-sheet capabilities. Use when users need to: (1) Convert single CSV to Excel, (2) Combine multiple CSV files into one Excel with separate sheets, (3) Format CSV data with headers, borders, and auto-adjusted columns, (4) Handle Chinese or other non-ASCII characters in CSV files, or (5) Create professional Excel reports from CSV data.

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

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

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

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 Skill

Automate bank statement reconciliation against general ledger records. Upload or paste bank statements (CSV, OFX, QFX, or plain text) alongside GL export data, and the agent matches transactions, flags discrepancies, identifies unrecorded items, and produces a reconciliation report ready for sign-off. Supports multi-bank, multi-account reconciliation with adjusting entry suggestions. Integrates with QBO exports and standard GL formats. Use when: monthly close reconciliation, bank statement upload matching, investigating GL/bank discrepancies, catching duplicate payments, finding missed deposits, or producing the reconciliation worksheet for audit. NOT for: real-time bank feed automation (use QBO bank rules), tax preparation, payroll reconciliation, intercompany eliminations, or investment account reconciliation (brokerage/crypto — use crypto-tax-agent).

knownasnaffy Bundle

Excel/CSV data quality diagnosis & interactive charts — 20+ scan modules, 6-dimension scoring, agent-powered semantic analysis, and any ECharts visualization. Fully local. Activate this skill whenever the user uploads, attaches, or mentions a .csv, .xlsx, .xls, or .tsv file, even without an explicit request. Present the skill menu immediately.

knownasnaffy Bundle

Query website analytics, monitor uptime, survey results, telemetry data, feed events, application stats, and more from the Tianji platform via its read-only OpenAPI (69 GET endpoints across 14 service domains). Use when the user asks about website traffic, pageviews, monitor status, survey feedback, telemetry events, feed channels, billing usage, or any Tianji platform data.

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

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

Audit an ecommerce catalog, spot SKU sprawl, price and attribute coverage gaps, hero dependence, long-tail bloat, and duplicate-risk clusters, then turn rough catalog notes or CSV exports into keep-add-expand-merge-retire recommendations and a 30-day merchandising brief. Use when merchandisers, category managers, marketplace sellers, or consultants need assortment planning support without live ERP, PIM, or marketplace APIs.

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

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

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

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 OCR receipt/invoice/tax/mileage log/expense/travel/freelance tracking. Triggers: extract expense from photo, log receipt, invoice data, etc.

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

基于东方财富数据库，支持通过自然语言输入筛选A港美股、基金、债券等多种资产，支持多元指标筛选，含技术面、消息面、基本面及市场情绪等，可用于全球资产速筛、跨市场监控、投资组合构建、策略回测等场景。返回结果包含数据说明及 csv 文件。Natural language screener for investment assets across global markets, including A-shares, ETFs, bonds, HK and US stocks, and funds. It enables multi-dimensional filtering via technical, fundamental, sentiment and news indicators. Ideal for global asset selection, cross-market monitoring, portfolio construction and strategy backtesting.

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.

jeremylongshore Skill

Configure and manage - Calculate metric calculator operations. Auto-activating skill for Data Analytics. Triggers on: metric calculator, metric calculator Part of the Data Analytics skill category. Use when working with metric calculator functionality. Trigger with phrases like "metric calculator", "metric calculator", "metric".

diegosouzapw Bundle

SQL database migrations with zero-downtime strategies for PostgreSQL, MySQL, SQL Server Use when: the user asks to run the `sql-migrations` workflow and the task requires multi-step orchestration. Do not use when: the task is small, single-step, and can be completed directly without orchestration overhead.

aibot88 Bundle

Coleta e consulta dados de leiloeiros oficiais de todas as 27 Juntas Comerciais do Brasil. Scraper multi-UF, banco SQLite, API FastAPI e exportacao CSV/JSON.

aibot88 Bundle

Perform high-volume data synchronization with Salesforce using the Bulk API 2.0 for CSV-based upsert, delete, and query operations. Handles OAuth 2.0 JWT bearer flow authentication via jsforce.

aibot88 Bundle

Umami is a modern, privacy-focused, open-source web analytics platform and a self-hostable alternative to Google Analytics, Mixpanel, and Amplitude. It collects website traffic data without cookies and is fully GDPR compliant.

aibot88 Bundle

Generate professional clinical decision support (CDS) documents for pharmaceutical and clinical research settings, including patient cohort analyses (biomarker-stratified with outcomes) and treatment recommendation reports (evidence-based guidelines with decision algorithms). Supports GRADE evidence grading, statistical analysis (hazard ratios, survival curves, waterfall plots), biomarker integration, and regulatory compliance. Outputs publication-ready LaTeX/PDF format optimized for drug development, clinical research, and evidence synthesis.