warehouse

通过 Python 脚本读取仓库 SQLite 数据库，输出库存状态饼图、分类收入图、30 天利润趋势图、商品表格图片，以及缺货商品 CSV 和 KPI 摘要文本，便于嵌入 PDF 或幻灯片。

chinmayagit

热度 81.37

最近更新 2026-05-11 17:28:58

分类：数据依赖：代码执行 / 读写文件应用场景：报告撰写 / 数据处理 / 图像生成 / 工作流

安装技能

复制下面的话术发给你的 Agent，它会通过 secure-skills 检索并安装该技能。

执行命令安装此 skill： npx secure-skills-cli add warehouse-reports

Metadata

name: warehouse-chart-reports
description: Generate warehouse analytics charts, table images, and report-ready visuals from SQLite/CSV data. Use when the user asks for warehouse charts, product table images, stock health pie charts, revenue/profit visuals, missing-product visuals, or image assets for PDF/slide reporting.

Warehouse Chart Reports

Use this skill to produce clean chart/report images for warehouse demos.

Run full warehouse visual pack (recommended)

Execute:

python skills/warehouse-chart-reports/scripts/run_warehouse_reports.py \
  --db demo/warehouse_agent/warehouse_demo.db \
  --out demo/warehouse_agent/outputs

This generates:

stock_status_pie.png
revenue_by_category.png
daily_profit_30d.png
product_table_top40.png
missing_products.csv
kpi_summary.txt

Generate product table image only

Execute:

python skills/warehouse-chart-reports/scripts/product_table_image.py \
  --db demo/warehouse_agent/warehouse_demo.db \
  --out demo/warehouse_agent/outputs/product_table_top40.png \
  --limit 40

Notes

Prefer virtualenv Python when matplotlib is unavailable system-wide.
Keep chart style simple and readable for PDF embedding.
If sales timestamps are sparse for today, use the 30-day profit chart for trend visibility.