Data & Analytics

lord1egypt Skill

Real-time smart money analytics API for Polymarket prediction markets, Hyperliquid perpetual futures, and Meteora Solana LP/AMM pools. 63 endpoints. Pay-per-request via x402 on Solana Mainnet USDC. No API keys.

lord1egypt Skill

Convert Microsoft Office documents (DOCX, XLSX, PPTX) to Markdown without any external dependencies. Use when the user needs to extract text from Word documents, Excel spreadsheets, or PowerPoint presentations for analysis, indexing, or LLM processing. Pure Python implementation — no pip install, no subprocess calls, no network downloads required. Works offline.

lord1egypt Skill

Analyze local OpenClaw session token usage from a generated SQLite ledger and markdown summaries. Use when the user asks for a token audit, token体检报告, context-bloat diagnosis, session efficiency review, largest sessions, daily token trends, input/output ratio analysis, cache-read heavy sessions, or wants SQL/SQLite-based inspection of local OpenClaw session usage.

lord1egypt Skill

采集A股和港股指定股票的历史数据。支持多股票批量采集、多种时间周期（日线/周线/月线/分钟线）、数据导出为CSV格式。使用场景：(1) "采集贵州茅台和腾讯的历史数据"，(2) "批量采集我的自选股"，(3) "获取某只股票的所有历史数据"。

lord1egypt Skill

Use when analyzing folders/tranches of declassified UAP/UFO/FOIA PDFs such as war.gov/UFO PURSUE, FBI Vault, NARA boxes, or AARO releases. Runs inventory, text extraction, entity/redaction analytics, and builds a standardized 11-section REPORT.md with caveats.

lord1egypt Skill

Generate technical-analysis trade setups from OHLCV CSV using SMA/EMA/RSI/MACD/ATR with clear entry, stop, target, and position size.

lord1egypt Skill

Analyze Google Ads search-term CSV exports locally and draft negative-keyword plans with dry-run safety. Use when an AI agent needs setup, usage, safety boundaries, or troubleshooting for Google Ads Intent MCP.

lord1egypt Skill

使用 NautilusTrader 配置驱动的 BacktestNode 运行高性能多市场回测，支持 Parquet 数据目录和外部 CSV 数据导入，策略可直接过渡到实盘交易。。

lord1egypt Skill

Use this skill when the user wants to manage social media scheduling, analytics, cross-posting, or AI-assisted content creation across Instagram, TikTok, Twitter/X, LinkedIn, or Facebook.

lord1egypt Skill

Create, inspect, and edit Microsoft Excel workbooks and XLSX files with reliable formulas, dates, types, formatting, recalculation, and template preservation. Use when (1) the task is about Excel, `.xlsx`, `.xlsm`, `.xls`, `.csv`, or `.tsv`; (2) formulas, formatting, workbook structure, or compatibility matter; (3) the file must stay reliable after edits.

lord1egypt Skill

Collect all customer reviews from an Amazon product URL or product-reviews URL through a logged-in Chrome session on port 9222, export a 14-column factual workbook, optionally fill translations through DeepLX, and then help the model tag the rows into a final delivery-ready spreadsheet. Use when the user sends an Amazon link and wants review scraping, competitor review analysis, review export, or a delivery-ready spreadsheet with usernames, review links, review time, helpful votes, translation, summary, sentiment, categories, and tags.

lord1egypt Skill

Schedule, compose, and publish social media posts across X (Twitter), LinkedIn, and Instagram from OpenClaw. Manage a content calendar, queue posts with approval workflows, track engagement analytics, and maintain brand voice consistency. Use when: (1) scheduling or publishing social media posts, (2) managing a content calendar, (3) drafting posts for multiple platforms, (4) reviewing post performance/analytics, (5) setting up automated posting workflows, or (6) maintaining a social media presence.

lord1egypt Skill

Generate a deterministic, template-preserving 16-section SDS/MSDS package from 1 DOCX template, 1 prompt/rule file, and 1-3 source SDS/MSDS files, with DOCX/PDF output plus structured JSON, provenance CSV, and review checklist artifacts.

lord1egypt Skill

Fetch live ClawHub publisher metrics for a specific user, including published skills, author rank, total downloads, stars, current installs, all-time installs, comments, and top-skill breakdowns. Use when users ask to 查某个 ClawHub/OpenClaw 用户发布了哪些 skill、查作者数据、查发布者表现、查技能市场数据、看安装量/下载量/星标/评论、统计某个作者的 skills、分析某个发布者的 marketplace performance, publisher stats, author stats, creator analytics, install counts, download counts, star counts, comment counts, top skills, or a per-skill metrics report.

lord1egypt Skill

电商数据分析工具，支持CSV销售数据上传、生成销售趋势图/产品排名/渠道收入占比/利润率分析/库存预警，一键生成PDF报告，集成SkillPay支付接口。适用于电商卖家分析销售业绩、生成业务报告。

lord1egypt Skill

提供 A 股市场的因子计算、存储与 tear sheet 分析能力，支持 Pandas/Polars 零拷贝数据转换和 QIFI 账户回测模拟，适用于多数据源量化研究。

lord1egypt Skill

Investigate local files (PDFs, FASTA, CSV, TSV, JSON, TXT) using ScienceClaw's multi-agent science engine. Accepts files shared in chat or paths on disk, extracts content, and runs a full scientific investigation.

lord1egypt Skill

Integrate AI agents with business data via Model Context Protocol. Query ads, analytics, CRM data through normalized interfaces. Use when connecting agents to business systems, enabling data access, or building MCP servers. Triggers on "MCP", "Model Context Protocol", "business data", "agent integration", "Claude MCP".

lord1egypt Skill

Automatically merge reimbursement folders into one PDF. Supports recursive folder scanning, PDF merging, two invoices per A4 page, phone screenshots/images placed as A4 half-page slots, and Excel workbooks with multiple sheets converted to PDF before merging.

lord1egypt Skill

Use when Codex needs to create, review, or update equity research work products such as earnings previews, post-earnings notes, model updates, initiating coverage, sector overviews, catalyst calendars, thesis trackers, idea generation screens, valuation memos, investor briefs, or public-company research that requires filings, transcripts, market data, spreadsheet work, citations, and analyst-review guardrails.

lord1egypt Skill

专为文件操作、数据分析、可视化、数据库连接、API 接入和敏感数据处理设计的系统级 Agent Skill。 【强制触发场景】： - 用户提及任何文件操作：Excel / WPS / Word / TXT / Markdown / RTZ / CSV / JSON - 「分析」「读取」「提取」「处理」「建模」「预测」「异常检测」 - 「生成图表」「可视化」「做仪表盘」「出报告」 - 「连数据库」「查 SQL」「查 MySQL / PostgreSQL」 - 「调 API」「从接口拉数据」「爬接口」 - 「脱敏」「敏感数据」「隐私处理」「数据安全」 【核心能力】：文件操作（自动降级）× 深度分析 × 专业可视化 × 数据库 × API × 安全脱敏 IMPORTANT: 只要涉及上述任一场景，必须使用此 skill，不得因"任务简单"而跳过。

lord1egypt Skill

Diagnose spreadsheet structure and recommend practical Excel/WPS-compatible formulas and workflows for cleaning, lookup and matching, summarization, text and date cleanup, and common formula troubleshooting. Use when the user asks what formula to use, how to process a table, how to clean messy columns, how to match sheets, how to make a solution work in both Excel and WPS, or when headers and sample rows should be inspected before deciding what to do next.

lord1egypt Skill

Supervised, policy-gated DeFi intelligence and execution manual for FarmDash MCP tools (48 tools). Covers swap routing (0x/Li.Fi/x402), mandatory pre-execution swap simulation, typed intents, Trail Heat intelligence, sybil risk auditing, portfolio optimization + simulation, historical analytics, portfolio reads, guarded workflow orchestration, security checks, yield comparison, hedge planning, ledger review, Hyperliquid perps research/execution, and the Autonomous Operator (sessions, FarmingContext, event snapshots, delegation, bounded autopilot). Wallet-changing actions are split into explicit authority modes: local user-signed execution, or user-configured bounded delegation/autopilot with budgets, allowlists, revocation, and execution gates. FarmDash never receives private keys or seed phrases and never holds user funds.

lord1egypt Skill

GitHub team collaboration toolkit for managing team workflows, code reviews, issue tracking, sprint planning, and team metrics. Supports PR automation, issue triage, milestone management, and team productivity analytics. Use when teams need to coordinate development workflows, automate code review processes, track sprint progress, or analyze team collaboration metrics on GitHub.

lord1egypt Skill

Track pageviews and custom events via the Plausible Events API, and query stats (top pages, top sources, countries, realtime visitors). Use when you need to send analytics events or fetch analytics data from a self-hosted or plausible.io site.

lord1egypt Skill

Complete implementation guide for Telegram/Teamgram premium features and monetization (v2.0.0). Use when building membership systems, payment integration, subscription lifecycle, coupons, analytics, and global payment solutions. Covers ten iterations of optimization from basic implementation to production-ready systems.

lord1egypt Skill

Complete spreadsheet methodology — data cleanup, transformation, analysis, dashboards, automation, and reporting. Works with CSV, Excel, Google Sheets, or any tabular data. Use when the user needs to clean messy data, build reports, create dashboards, automate recurring spreadsheet tasks, or transform data between formats.

lord1egypt Skill

Use when YouTube data is needed through MyBrandMetrics: search YouTube videos, get video metadata, inspect channel info, browse playlists, list comments, check live broadcasts, query YouTube Analytics, and work with YouTube Reporting jobs. Covers YouTube Data API v3, YouTube Analytics API v2, and YouTube Reporting API v1 after YouTube is connected in MyBrandMetrics.

lord1egypt Skill

将不同银行导出的流水 Excel / CSV 批量转换为监管报送标准格式（9 列）。Use when: 用户需要转换银行流水格式、汇总多银行多账户流水、整理监管报送数据。NOT for: 非银行流水文件处理、加密/损坏文件修复。需要 Python3 + openpyxl + xlrd。

lord1egypt Skill

从财务部固定格式月度 Excel 底稿生成月度财务报告正文、Markdown 和 Word 文件。Use when: 用户上传月度财报底稿、要求生成月报正文、需要 Word 下载文件、需要复用 Dify 月度财报智能体的 Excel 处理逻辑。NOT for: 非固定模板 Excel、财务审计判断、补造或修改底稿数据。需要 Python3 + openpyxl；.xls 需要 xlrd。

lord1egypt Skill

园区企业服务智能助手（完全自包含版）。一站式提供客户管理、费用催缴、合同续租预警、工单分派、库存监控、C+服务匹配、走访计划管理7大核心功能。基于Excel台账数据（[你的园区数据.xlsx]），自动生成风险预警和日报推送。当用户需要管理园区企业服务事务时使用此skill。

lord1egypt Skill

Scan websites for common vulnerabilities including SQL injection, open ports, and DevTools-related issues. This skill is designed for testing user-owned websites and is compatible with OpenClaw.

lord1egypt Skill

Choose between relational, document, and graph data models for an application by analyzing data shape, relationship complexity, and query patterns. Use when asked "should I use MongoDB or PostgreSQL?", "when does a graph database make sense?", "how do I choose between SQL and NoSQL?", or "what data model fits my access patterns?" Also use for: evaluating impedance mismatch between data model and application code; deciding schema-on-read vs. schema-on-write for heterogeneous data; diagnosing whether many-to-many relationships call for relational or graph model; choosing between property graphs and triple-stores; deciding when polyglot persistence is appropriate. Produces a concrete recommendation with trade-off analysis — not "it depends." Covers relational (PostgreSQL, MySQL), document (MongoDB, CouchDB), and graph (Neo4j, Datomic) models including schema enforcement strategies and data locality trade-offs. For storage engine internals (LSM-tree vs B-tree), use storage-engine-selector instead. For OLTP vs. an

lord1egypt Skill

The AI Agent FinOps Playbook: Budget Enforcement, Cost Allocation & Spend Analytics for Multi-Agent Systems. Complete guide to cost governance for multi-agent systems: per-agent wallets, budget caps, spend alerts via webhooks, cost attribution, volume discounts, fleet dashboards, and API key isolation. Includes detailed Python code examples with full API integration.

lord1egypt Skill

Plan-aware UseClick link-shortening and analytics API workflows for geo links, affiliate links, link management, QR generation, and custom/branded domains. Use when users want to integrate UseClick in code, automations, or AI agents to create/manage short links, fetch click analytics, configure geo-targeting, or map feature availability to pricing tiers. Also use when users need upgrade-aware guidance for plan-limited features before building dashboards or production integrations.

lord1egypt Skill

Interact with Excel files (.xlsx, .xlsm, .xlsb, .xls, .ods) using the agent-xlsx CLI for data extraction, analysis, writing, formatting, visual capture, VBA analysis, and sheet management. Use when the user asks to: (1) Read, analyse, or search data in spreadsheets, (2) Write values or formulas to cells, (3) Inspect formatting, formulas, charts, or metadata, (4) Take screenshots or visual captures of sheets, (5) Export sheets to CSV/JSON/Markdown, (6) Manage sheets (create, rename, delete, copy, hide), (7) Analyse or execute VBA macros, (8) List/export embedded objects (charts, shapes, pictures), (9) Check for formula errors, or (10) Any task involving Excel file interaction. Prefer over openpyxl/pandas scripts — faster, structured JSON optimised for AI.