← 返回 Skills 市场
tujinsama

决策简报虾 (decision-briefing-claw)

作者 Ricky · GitHub ↗ · v1.0.0 · MIT-0
cross-platform ⚠ suspicious
81
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install decision-briefing-claw
功能描述
每日经营数据自动汇总与简报推送助手(决策简报虾)。从多个数据源(数据库/API/Excel/飞书多维表格)采集关键业务指标,自动计算同比环比,生成结构化简报,并推送到飞书/邮件/企业微信等渠道。激活场景:(1) 需要每日自动汇总经营数据;(2) 想要定时收到业务进展简报;(3) 需要将散落在多个系统的数据整合到一...
使用说明 (SKILL.md)

决策简报虾 (decision-briefing-claw)

每日经营数据自动汇总与简报推送。从多数据源采集 → 计算 KPI → 生成简报 → 多渠道推送 → 自动归档。

工作流程

步骤 1:了解配置需求

首次使用时,询问用户:

  • 数据源类型(数据库/API/Excel/飞书多维表格)及连接信息
  • 需要监控的核心指标(收入、订单数、用户数等)
  • 推送时间(如每天 09:00)和推送渠道(飞书群/个人/邮件)
  • 简报模板偏好(极简/标准/详细/高管版)

步骤 2:数据采集

使用 scripts/data-collector.py 从配置的数据源采集数据:

# 验证数据源连接
python3 scripts/data-collector.py validate --source \x3Cname>

# 采集所有数据源
python3 scripts/data-collector.py collect --all

# 测试单条 SQL
python3 scripts/data-collector.py test --query "SELECT COUNT(*) FROM orders WHERE DATE(created_at) = CURDATE() - INTERVAL 1 DAY"

数据源配置详见 references/data-sources.md

步骤 3:计算 KPI 与异常检测

  • 计算同比(YoY)、环比(MoM/DoD)
  • 标记超出阈值或大幅波动的异常数据
  • 指标计算规则详见 references/metrics-calculation.md

步骤 4:生成简报

使用 scripts/report-generator.sh 生成并推送简报:

# 生成简报(指定模板)
./scripts/report-generator.sh generate --template standard

# 推送到飞书
./scripts/report-generator.sh push --channel feishu

# 归档
./scripts/report-generator.sh archive --date $(date +%Y-%m-%d)

简报模板详见 references/report-templates.md

步骤 5:配置定时任务

使用 OpenClaw cron 或系统 crontab 设置定时触发:

# 每天早上 9:00 触发(crontab 示例)
0 9 * * * cd /path/to/skill && python3 scripts/data-collector.py collect --all && ./scripts/report-generator.sh generate --template standard && ./scripts/report-generator.sh push --channel feishu

步骤 6:归档与追溯

简报自动保存到 reports/YYYY-MM-DD.md,支持历史查询:

./scripts/report-generator.sh history --days 7

配置文件结构

config/
├── data-sources.json    # 数据源连接配置
└── channels.json        # 推送渠道配置
reports/                 # 归档简报目录

与其他 Skill 协作

  • 发现异常数据 → 调用 auto-data-analysis-claw 深度分析
  • 生成正式月报 → 调用 financial-report-render-claw 渲染
  • 获取战略建议 → 调用 strategy-advisor-claw
  • 推送到更多平台 → 调用 cross-platform-messenger-claw

常见问题

  • 数据库连接超时 → 检查网络权限,增加 connect_timeout
  • 推送失败 → 检查 webhook/token 是否有效,配置重试
  • 时区错乱 → 统一使用 Asia/Shanghai,SQL 中显式转换时区
  • SQL 慢 → 添加索引或改用数据仓库查询
安全使用建议
This skill appears to implement the described reporting workflow, but be cautious before installing and running it: - Expect to provide sensitive credentials: DB passwords, API tokens, and push-webhook URLs (e.g., Feishu webhook) are read from config files and expanded from environment variables (examples in references use ${MYSQL_PASSWORD}, ${FINANCE_API_TOKEN}). The skill metadata does not declare these env vars — verify and supply only least-privilege secrets (readonly DB accounts, scoped API tokens). - Review and secure config files: config/data-sources.json and config/channels.json will contain secrets or webhook endpoints. Store them with restricted file permissions and do not put production credentials in world-readable locations. - Arbitrary SQL capability: the test subcommand executes whatever SQL you pass against the first DB in the config. Avoid running untrusted queries and prefer readonly accounts to reduce risk. - Outbound push targets: the script will POST report content to whatever webhook URL is configured. Ensure webhooks point to trusted endpoints; a malicious webhook could exfiltrate sensitive business data. - Run first in a non-production / isolated environment: validate behavior using test credentials and sample data, confirm required tools (jq, mail, curl, Python deps) and consider adding explicit metadata about required env vars before deploying broadly. - Operational recommendations: use least-privilege DB users, rotate tokens, restrict file system locations it can read (avoid mounting / or sensitive dirs), and review cron entries for who can edit them. Given the unadvertised credential use and ability to execute SQL and post data externally, treat this skill as suspicious until you audit and harden its configuration.
功能分析
Type: OpenClaw Skill Name: decision-briefing-claw Version: 1.0.0 The 'decision-briefing-claw' skill is a legitimate business intelligence tool designed to automate daily data collection and reporting. It includes a Python script (scripts/data-collector.py) for querying databases and APIs, and a shell script (scripts/report-generator.sh) for generating Markdown reports and pushing them to user-configured channels like Feishu or email. The code follows standard practices, such as using environment variables for secrets and providing clear documentation in SKILL.md and the references/ directory. No evidence of malicious intent, unauthorized data exfiltration, or prompt-injection attacks was found.
能力评估
Purpose & Capability
The skill's functionality (DB/API/CSV/Feishu collection and push to webhooks/email) aligns with its description. However, the skill declares no required environment variables or primary credential while the code and reference configs expect sensitive credentials (e.g., MYSQL_PASSWORD, FINANCE_API_TOKEN, Feishu webhook/token). That mismatch is disproportionate: consumers will need to provide secrets but the skill metadata does not advertise or scope them.
Instruction Scope
Runtime instructions instruct the agent to run included scripts that read config/data-sources.json and config/channels.json, expand environment variables inside those configs, connect to databases and external APIs, run arbitrary SQL (via the test command), and post report content to external webhooks. The SKILL.md does not explicitly enumerate the environment variables the scripts will expand or warn about arbitrary-SQL execution or external webhook destinations.
Install Mechanism
There is no install spec (instruction-only), so nothing is downloaded at install time. The included code files are small local scripts that use standard tools (python requests/sqlalchemy, jq, curl, mail). No remote install URLs or archives are used.
Credentials
Although the registry metadata lists no required env vars, the references and scripts expect and expand environment variables such as MYSQL_PASSWORD and FINANCE_API_TOKEN and depend on user-provided webhook tokens in config/channels.json. Requesting/using DB credentials, API tokens, and webhook URLs is expected for this capability, but the absence of declared env requirements and lack of guidance about least-privilege credentials is an incoherence and increases risk.
Persistence & Privilege
always is false and the skill only writes to its own reports/ and config/ paths per SKILL.md. It doesn't request system-wide config modification or permanent platform-level privileges. It can be scheduled (cron) as intended; that is normal.
如何使用
  1. 确保已安装 OpenClaw(本地或 Docker 部署)
  2. 在对话框中输入安装命令:/install decision-briefing-claw
  3. 安装完成后,直接呼叫该 Skill 的名称或使用 /decision-briefing-claw 触发
  4. 根据 Skill 的参数说明提供必要输入,即可获得结构化输出
版本历史
v1.0.0
Initial release: 每日经营数据自动汇总与简报推送助手
元数据
Slug decision-briefing-claw
版本 1.0.0
许可证 MIT-0
累计安装 0
当前安装数 0
历史版本数 1
常见问题

决策简报虾 (decision-briefing-claw) 是什么?

每日经营数据自动汇总与简报推送助手(决策简报虾)。从多个数据源(数据库/API/Excel/飞书多维表格)采集关键业务指标,自动计算同比环比,生成结构化简报,并推送到飞书/邮件/企业微信等渠道。激活场景:(1) 需要每日自动汇总经营数据;(2) 想要定时收到业务进展简报;(3) 需要将散落在多个系统的数据整合到一... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件,目前累计下载 81 次。

如何安装 决策简报虾 (decision-briefing-claw)?

在 OpenClaw 或 Claude Code 对话框中运行命令「/install decision-briefing-claw」即可一键安装,无需额外配置。

决策简报虾 (decision-briefing-claw) 是免费的吗?

是的,决策简报虾 (decision-briefing-claw) 完全免费,采用 MIT-0 许可证,可自由下载、安装和使用。

决策简报虾 (decision-briefing-claw) 支持哪些平台?

决策简报虾 (decision-briefing-claw) 跨平台运行,可在任意部署了 OpenClaw / Claude Code 的环境中使用(cross-platform)。

谁开发了 决策简报虾 (decision-briefing-claw)?

由 Ricky(@tujinsama)开发并维护,当前版本 v1.0.0。

💬 留言讨论