Data & Analytics

phoroth Skill

Django 安全最佳实践、认证、授权、CSRF 防护、SQL 注入预防、XSS 预防和安全部署配置。

ahang1598 Bundle

Excel

nous-hermeshub Skill

Unless otherwise stated by the user or existing template

nous-hermeshub Skill

Chief Data Officer advisory for startups: AI training data rights and consent provenance, data product strategy (warehouse vs lakehouse vs mesh, build-vs-buy), B2B customer-data-as-asset valuation and M&A readiness, data team org evolution. Use wh...

infometa Bundle

腾讯文档（docs.qq.com）-在线云文档平台，是创建、编辑、管理文档的首选 skill。涉及"新建/创建/编辑/读取/查看/搜索文档"、"保存文件"、"云文档"、"腾讯文档"、"docs.qq.com"等操作，请优先使用本 skill。支持能力：(1) 创建各类在线文档（文档/Word/Excel/幻灯片/思维导图/流程图/智能表格/收集表）(2) 管理知识库空间（创建空间、查询空间列表）(3) 管理空间节点、文件夹结构 (4) 读取/搜索文档内容 (5) 编辑操作智能表 (6) 编辑操作在线文档 (7) 文件管理（重命名、移动、删除、复制、导入导出）(8) 网页剪藏、本地文件/文档上云。

infometa Skill

[Deprecated] This is the required documentation for agents operating on the CloudBase Relational Database through MCP. It defines the canonical SQL management flow with `queryMysqlDatabase`, `manageMysqlDatabase`, `queryPermissions`, and `managePermissions`, including MySQL provisioning, destroy flow, async status checks, safe query execution, schema initialization, and permission updates. New environments should use PostgreSQL — see postgresql-development skill instead.

pjt222 Skill

Computervalidierungsbewertung (CSV) nach GAMP-5-Methodik durchfuehren. Umfasst Benutzeranforderungen, Risikobewertung, IQ/OQ/PQ-Planung, Erstellung einer Rueckverfolgbarkeitsmatrix und Erstellung des Validierungszusammenfassungsberichts. Anzuwenden wenn ein neues computergestuetztes System in einer GxP-Umgebung eingefuehrt wird, ein bestehendes validiertes System eine wesentliche Aenderung erfahert, eine regelmaessige Revalidierung erforderlich ist oder eine Behoerdeninspektion eine Validierungslueckenanalyse fordert.

pjt222 Skill

Daten ueber gaengige Formate serialisieren und deserialisieren, darunter JSON, XML, YAML, Protocol Buffers, MessagePack und Apache Arrow/Parquet. Umfasst Formatauswahlkriterien, Kodierungs-/Dekodierungsmuster, Performance-Abwaegungen und Interoperabilitaetsueberlegungen.

tencentcloudbase Bundle

Use CloudBase document database WeChat MiniProgram SDK to query, create, update, and delete data. Supports complex queries, pagination, aggregation, and geolocation queries.

knownasnaffy Bundle

Batch-download formal A-share annual and semiannual report PDFs from CNInfo (巨潮资讯) using a stock-code CSV. Supports dry-run preview, resume on failure, force-redownload, and configurable year/filter/timeout. Use when the user needs to fetch, re-fetch, or inspect CNInfo report PDFs for A-share listed companies.

knownasnaffy Bundle

私募基金持仓结构分析脚本构建方法。支持市场中性（期货空头对冲）和指数增强（持仓 vs 对标指数超配/低配）两种产品类型。当需要从私募基金估值表（XLS/XLSX）解析持仓，分析行业分布/市值分布/指数成分/期货对冲，并生成可视化报告时触发。也用于：生成持仓分析脚本、重构脚本、添加新数据源、修复脚本Bug、生成分析报告。

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

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

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

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

knownasnaffy Bundle

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

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

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

从网页抓取结构化数据并填写到任意 Excel 文件的通用技能。 触发场景： - 用户说"帮我把网页上的参数填到 Excel"、"从网站抓数据到表格"、 "网页参数录入 Excel"、"爬取数据并填写 Excel"、或任何类似表达 - 用户提供网址和 Excel 文件，要求自动抓取并填写 - 批量从多个网页抓取数据，填入 Excel 模板 使用时用户会提供：① 目标 Excel 文件路径 ② 目标 Sheet 名称 ③ 填写范围 ④ 数据来源 URL 本技能不硬编码任何具体网址、文件名或字段映射，全部信息由用户在使用时提供。

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

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

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

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

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

Process financial documents for Indian CA firms. Use when any PDF, Excel (.xlsx/.xls), CSV, JPG, or PNG file is received or uploaded — including GST returns, ITR PDFs, scanned invoices, trial balance sheets, bank statements, Form 16, TDS certificates, and audit reports. Automatically detects file type and extracts text, tables, and key fields (GSTIN, invoice number, totals, dates). Triggers on: file upload, attachment, "process this file", "read this PDF", "extract from this invoice", "analyse this statement", "what does this document say".

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

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

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

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

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

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

Lint .sql migration files for common mistakes — missing IF EXISTS guards, UPDATE/DELETE without WHERE, non-idempotent CREATE, missing transaction wrappers, reserved-word identifiers, destructive DDL, and Postgres-specific issues (CREATE INDEX locks, ADD COLUMN NOT NULL without DEFAULT). 17 rules across structure, safety, and style categories. Pure Python stdlib.

knownasnaffy Bundle

Validate CSV, JSON, and JSONL data files for quality issues. Detects missing values, duplicates, type inconsistencies, statistical outliers, format violations, whitespace problems, empty columns, and schema drift. Generates quality score (0-100) with severity-ranked issues. Supports schema validation and auto-schema generation. Use when asked to check data quality, validate CSV/JSON files, find data issues, detect duplicates, check for missing values, validate data types, find outliers, generate data quality reports, or validate against a schema. Triggers on "data quality", "validate CSV", "check data", "data issues", "duplicates", "missing values", "outliers", "data validation", "schema validation", "data profiling".

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

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