{"_id":"@bondli-skills/store-order-query","_rev":"4-c03b9cfd9b6ef0f3b4ce5ed034ce4f31","name":"@bondli-skills/store-order-query","dist-tags":{"latest":"1.0.3"},"versions":{"1.0.0":{"name":"@bondli-skills/store-order-query","version":"1.0.0","keywords":["order","query","mysql","analysis"],"license":"MIT","_id":"@bondli-skills/store-order-query@1.0.0","maintainers":[{"name":"bondli","email":"250934756@qq.com"}],"dist":{"shasum":"8a76cc3088d314ed6ebd3d8efe6b20916d683ae8","tarball":"https://registry.npmjs.org/@bondli-skills/store-order-query/-/store-order-query-1.0.0.tgz","fileCount":10,"integrity":"sha512-56dT1rGt24Dfxiqzq0uHA0kdLVWc4rSD/Xa4+dW6y3bJUvCc06t8ghpSc4rApDPv/LDOatP7sc7YIAN2b1lR3g==","signatures":[{"sig":"MEUCIQCLDxhOXrAgltLfQ+TpoMsMQiKPOzFQUPwQoDhQawD8gAIgUN9Y6zP2r5mZya7pjvr9Adc1/IaAZDR2p9uvTPoPFF8=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":39658},"main":"dist/index.js","type":"module","_from":"file:bondli-skills-store-order-query-1.0.0.tgz","scripts":{"build":"tsc","clean":"rm -rf dist","query":"tsx src/index.ts","analyze":"tsx src/analyze-orders.ts","typecheck":"tsc --noEmit","query-today":"tsx src/index.ts --date-range today && tsx src/analyze-orders.ts"},"_npmUser":{"name":"bondli","email":"250934756@qq.com"},"_resolved":"/private/var/folders/y7/4446sqhs4g3f3bmjzxmbdc740000gn/T/47711fc856e91a8ecc9067ede6c8952d/bondli-skills-store-order-query-1.0.0.tgz","_integrity":"sha512-56dT1rGt24Dfxiqzq0uHA0kdLVWc4rSD/Xa4+dW6y3bJUvCc06t8ghpSc4rApDPv/LDOatP7sc7YIAN2b1lR3g==","_npmVersion":"11.11.0","description":"通过连接MySQL数据库查询店铺订单的 OpenClaw Skill","directories":{},"_nodeVersion":"22.18.0","dependencies":{"mysql2":"^3.6.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/store-order-query_1.0.0_1773903886321_0.8330605350599698","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@bondli-skills/store-order-query","version":"1.0.1","keywords":["order","query","mysql","analysis"],"license":"MIT","_id":"@bondli-skills/store-order-query@1.0.1","maintainers":[{"name":"bondli","email":"250934756@qq.com"}],"dist":{"shasum":"0cc9dbb9857f179057c573cac39e05d24c6d51b4","tarball":"https://registry.npmjs.org/@bondli-skills/store-order-query/-/store-order-query-1.0.1.tgz","fileCount":12,"integrity":"sha512-gXikl1tEbYLltDUwYblqFGYRmIkPOiwtE0nh9xwvHgt4ety3foP4DCmHTiFoRz6ZprF2xh30X6Pksh5Kyfhkgg==","signatures":[{"sig":"MEYCIQDF2s+4Bp1D0U3pv6GvCnOwlA9vNqeeUCCHrOUbFAn4mAIhAJ9bhacX9Q0/57HhSADwlL08XvunfK9l5PwUpI3hCz02","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":41631},"main":"dist/index.js","type":"module","_from":"file:bondli-skills-store-order-query-1.0.1.tgz","types":"./dist/index.d.ts","scripts":{"build":"tsc","clean":"rm -rf dist","query":"tsx src/index.ts","analyze":"tsx src/analyze-orders.ts","typecheck":"tsc --noEmit","query-today":"tsx src/index.ts --date-range today && tsx src/analyze-orders.ts"},"_npmUser":{"name":"bondli","email":"250934756@qq.com"},"_resolved":"/private/var/folders/cj/r9_g5rts3xv744s65g3mg8q40000gn/T/fab41b6fe1e84b79ac650571fc6e99e4/bondli-skills-store-order-query-1.0.1.tgz","_integrity":"sha512-gXikl1tEbYLltDUwYblqFGYRmIkPOiwtE0nh9xwvHgt4ety3foP4DCmHTiFoRz6ZprF2xh30X6Pksh5Kyfhkgg==","_npmVersion":"11.5.2","description":"通过连接MySQL数据库查询店铺订单的 OpenClaw Skill","directories":{},"_nodeVersion":"22.17.0","dependencies":{"mysql2":"^3.6.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/store-order-query_1.0.1_1773991879276_0.1896933127780409","host":"s3://npm-registry-packages-npm-production"}},"1.0.2":{"name":"@bondli-skills/store-order-query","version":"1.0.2","keywords":["order","query","mysql","analysis"],"license":"MIT","_id":"@bondli-skills/store-order-query@1.0.2","maintainers":[{"name":"bondli","email":"250934756@qq.com"}],"dist":{"shasum":"1a4c9166f441a03d6650f760df9d6f4855eaa018","tarball":"https://registry.npmjs.org/@bondli-skills/store-order-query/-/store-order-query-1.0.2.tgz","fileCount":16,"integrity":"sha512-J52BYsDaDqjS4vCky6JY6hsIOTPQhc+AZS319h1MjldRh4SXot6IPE+x6cxkKenNqhrylrB8YlTog5bXV4ggxg==","signatures":[{"sig":"MEQCIE7PNik5YgxN+k0vRxrH17OD0t/NV1s8qB+vNY/E0GIpAiAJq0z2NJdqSvXXi8Ml+z+5+QfTq9katvPVP4m+Y1Izmg==","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":40966},"main":"dist/index.js","type":"module","_from":"file:bondli-skills-store-order-query-1.0.2.tgz","types":"./dist/index.d.ts","scripts":{"build":"tsc","clean":"rm -rf dist","query":"tsx src/index.ts","analyze":"tsx src/analyze-orders.ts","typecheck":"tsc --noEmit","query-today":"tsx src/index.ts --date-range today && tsx src/analyze-orders.ts"},"_npmUser":{"name":"bondli","email":"250934756@qq.com"},"_resolved":"/private/var/folders/cj/r9_g5rts3xv744s65g3mg8q40000gn/T/b6dc505b27b8f210d562e963819a4a2f/bondli-skills-store-order-query-1.0.2.tgz","_integrity":"sha512-J52BYsDaDqjS4vCky6JY6hsIOTPQhc+AZS319h1MjldRh4SXot6IPE+x6cxkKenNqhrylrB8YlTog5bXV4ggxg==","_npmVersion":"11.5.2","description":"通过连接MySQL数据库查询店铺订单的 OpenClaw Skill","directories":{},"_nodeVersion":"22.17.0","dependencies":{"mysql2":"^3.6.0"},"_hasShrinkwrap":false,"_npmOperationalInternal":{"tmp":"tmp/store-order-query_1.0.2_1774266858197_0.6419196997692092","host":"s3://npm-registry-packages-npm-production"}},"1.0.3":{"name":"@bondli-skills/store-order-query","version":"1.0.3","description":"通过连接MySQL数据库查询店铺订单的 OpenClaw Skill","type":"module","main":"dist/index.js","keywords":["order","query","mysql","analysis"],"dependencies":{"mysql2":"^3.6.0"},"license":"MIT","scripts":{"build":"tsc","typecheck":"tsc --noEmit","clean":"rm -rf dist","query":"tsx src/index.ts","analyze":"tsx src/analyze-orders.ts","query-today":"tsx src/index.ts --date-range today && tsx src/analyze-orders.ts"},"_id":"@bondli-skills/store-order-query@1.0.3","types":"./dist/index.d.ts","_integrity":"sha512-6HonUw2IyUBf4DOALoF3TKf2h5d94Iywy+OPs3Ggybv0OXFtsIyeDSLqajwpSTMI6TSk3zOlzL0VeHx6bXHQ8g==","_resolved":"/private/var/folders/cj/r9_g5rts3xv744s65g3mg8q40000gn/T/0f86eac4008932dca1259ac87dc888c8/bondli-skills-store-order-query-1.0.3.tgz","_from":"file:bondli-skills-store-order-query-1.0.3.tgz","_nodeVersion":"22.17.0","_npmVersion":"11.5.2","dist":{"integrity":"sha512-6HonUw2IyUBf4DOALoF3TKf2h5d94Iywy+OPs3Ggybv0OXFtsIyeDSLqajwpSTMI6TSk3zOlzL0VeHx6bXHQ8g==","shasum":"da731a970684a177b6dd25088fdf7d43c054d112","tarball":"https://registry.npmjs.org/@bondli-skills/store-order-query/-/store-order-query-1.0.3.tgz","fileCount":16,"unpackedSize":42726,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQCBmP8u78/Vpm/0wIXkmyC13PXU03EKfn79mbFcaSHKnAIgAK8yVJy0YXXwmYeU6XPYKUQK9YdjeU3uecd/pEdtY+4="}]},"_npmUser":{"name":"bondli","email":"250934756@qq.com"},"directories":{},"maintainers":[{"name":"bondli","email":"250934756@qq.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/store-order-query_1.0.3_1774532324222_0.8641408254851681"},"_hasShrinkwrap":false}},"time":{"created":"2026-03-19T07:04:46.224Z","modified":"2026-03-26T13:38:44.534Z","1.0.0":"2026-03-19T07:04:46.490Z","1.0.1":"2026-03-20T07:31:19.419Z","1.0.2":"2026-03-23T11:54:18.331Z","1.0.3":"2026-03-26T13:38:44.392Z"},"license":"MIT","keywords":["order","query","mysql","analysis"],"description":"通过连接MySQL数据库查询店铺订单的 OpenClaw Skill","maintainers":[{"name":"bondli","email":"250934756@qq.com"}],"readme":"# Store Order Query Skill\n\n通过连接MySQL数据库实现 **查询店铺订单** 的 OpenClaw Skill。\n\n该 Skill 会读取数据库配置信息，连接MySQL数据库进行订单数据查询，最后对数据进行呈现和分析。\n\n## 功能特性\n\n- 专为MySQL数据库设计\n- 支持实际业务表结构（Order、OrderItems）\n- 多种查询时间范围：今天、昨天、最近7天、最近30天、自定义日期\n- 自动生成详细的 Markdown 分析报告\n- 订单数据、商品销售、SKU分析全面覆盖\n\n## 交互形态\n\n1. 用户输入查询诉求（如：\"查询今天店铺订单\"、\"今天的订单怎么样\"）\n2. Agent 检查是否有配置文件，如无则引导用户配置数据库信息\n3. Agent 执行查询脚本获取订单数据\n4. Agent 执行分析脚本生成报告并展示给用户\n\n## 快速开始\n\n### 1. 配置数据库\n\n复制 `config.example.json` 为 `config.json`，并修改数据库配置：\n\n```bash\ncp config.example.json config.json\n```\n\n编辑 `config.json`，填入你的MySQL数据库信息：\n\n```json\n{\n  \"database\": {\n    \"type\": \"mysql\",\n    \"host\": \"localhost\",\n    \"port\": 3306,\n    \"database\": \"shop_db\",\n    \"user\": \"root\",\n    \"password\": \"your_password\"\n  },\n  \"tables\": {\n    \"orders\": \"Order\",\n    \"order_items\": \"OrderItems\"\n  },\n  \"fields\": {\n    \"orders\": {\n      \"id\": \"orderSn\",\n      \"created_at\": \"createdAt\",\n      \"total_amount\": \"orderActualAmount\",\n      \"payment_method\": \"payType\",\n      \"status\": \"orderStatus\"\n    },\n    \"order_items\": {\n      \"order_id\": \"orderSn\",\n      \"product_name\": \"name\",\n      \"sku\": \"sku\",\n      \"quantity\": \"counts\",\n      \"price\": \"actualPrice\"\n    }\n  }\n}\n```\n\n### 2. 测试数据库（可选）\n\n如果你想快速测试，可以使用提供的示例数据库脚本：\n\n```bash\nmysql -u root -p < scripts/example_database.sql\n```\n\n这会创建 `Order` 和 `OrderItems` 表，并插入一些测试数据。\n\n### 3. 查询订单\n\n```bash\n# 查询今天的订单\npnpm run query -- --date-range today\n\n# 查询昨天的订单\npnpm run query -- --date-range yesterday\n\n# 查询最近7天的订单\npnpm run query -- --date-range last7days\n\n# 查询自定义日期范围\npnpm run query -- --date-range custom --start-date 2024-01-01 --end-date 2024-01-31\n```\n\n### 4. 生成分析报告\n\n```bash\npnpm run analyze\n```\n\n**一键查询并分析：**\n\n```bash\npnpm run query-today\n```\n\n报告将保存到 `output/order_report.md`。\n\n## 生成的数据\n\n1. **订单原始数据** (`output/orders_data.json`)\n   - 符合查询条件的订单数据\n   - 关联的商品信息\n\n2. **分析报告** (`output/order_report.md`)\n   - 总体概况：订单量、总金额、平均订单金额、商品总数\n   - 支付方式分布\n   - 订单状态分布\n   - 热销商品 TOP 10\n   - SKU 销售分析（尺码、颜色等）\n\n## 目录结构\n\n```\nstore-order-query/\n├── SKILL.md                    # Skill 定义文件\n├── README.md                   # 使用说明\n├── package.json                # 依赖配置\n├── tsconfig.json               # TypeScript 配置\n├── config.example.json         # 配置文件示例\n├── config.json                 # 实际配置文件（需自行创建）\n├── src/\n│   ├── index.ts                # 订单查询入口\n│   └── analyze-orders.ts       # 数据分析入口\n├── scripts/\n│   └── example_database.sql   # 示例数据库脚本\n└── output/                     # 输出目录（自动创建）\n    ├── orders_data.json        # 订单原始数据\n    └── order_report.md         # 分析报告\n```\n\n## 数据库表结构\n\n### Order 表（订单表）\n\n```sql\nCREATE TABLE `Order` (\n    `orderSn` VARCHAR(50) PRIMARY KEY COMMENT '订单号',\n    `createdAt` DATETIME NOT NULL COMMENT '创建时间',\n    `orderActualAmount` DECIMAL(10, 2) NOT NULL COMMENT '订单实际金额',\n    `payType` VARCHAR(50) COMMENT '支付方式',\n    `orderStatus` VARCHAR(20) COMMENT '订单状态',\n    INDEX `idx_createdAt` (`createdAt`)\n);\n```\n\n### OrderItems 表（订单商品表）\n\n```sql\nCREATE TABLE `OrderItems` (\n    `id` INT AUTO_INCREMENT PRIMARY KEY COMMENT '主键ID',\n    `orderSn` VARCHAR(50) NOT NULL COMMENT '订单号',\n    `name` VARCHAR(200) NOT NULL COMMENT '商品名称',\n    `sku` VARCHAR(100) COMMENT 'SKU',\n    `counts` INT NOT NULL COMMENT '数量',\n    `actualPrice` DECIMAL(10, 2) NOT NULL COMMENT '实际价格',\n    INDEX `idx_orderSn` (`orderSn`)\n);\n```\n\n## Scripts\n\n| 命令                   | 说明                     |\n| ---------------------- | ------------------------ |\n| `pnpm run query`       | 运行查询脚本             |\n| `pnpm run analyze`     | 运行分析脚本             |\n| `pnpm run query-today` | 一键查询今天的订单并分析 |\n\n## 技术栈\n\n- **Node.js**: 运行环境（>= 18）\n- **TypeScript**: 开发语言\n- **mysql2**: MySQL 数据库驱动\n\n## 注意事项\n\n1. **数据库权限**：确保数据库用户有读取 Order 和 OrderItems 表的权限\n2. **安全性**：配置文件包含敏感信息，请勿提交到公共仓库，已添加到 `.gitignore`\n3. **日期字段**：确保 `createdAt` 字段是 DATETIME 类型，支持 `DATE()` 函数\n4. **字段映射**：如果你的表结构不同，请修改 `config.json` 中的字段映射\n\n## 常见问题\n\n### Q: 数据库连接失败？\n\n检查：\n\n1. MySQL 服务是否启动\n2. 配置文件中的用户名和密码是否正确\n3. 数据库名称是否存在\n4. 端口号是否正确（默认 3306）\n\n### Q: 查询结果为空？\n\n检查：\n\n1. 日期范围是否正确\n2. 数据库中是否有该时间段的数据\n3. Order 表中 `createdAt` 字段是否有值\n\n### Q: 字段不匹配错误？\n\n检查 `config.json` 中的字段映射是否与实际表结构一致。\n\n---\n\n**作者**: liwentao\n**仓库**: https://github.com/bondli/my-claw-skills.git\n","readmeFilename":"README.md"}