← 返回 Skills 市场
89
总下载
0
收藏
0
当前安装
1
版本数
在 OpenClaw 中安装
/install annual-insurance-word-report
功能描述
Generate annual insurance welfare Word reports from `gh_hg_bscyearall_dues` in OpenClaw format. The packaged Python entry extracts the target year, inspects...
使用说明 (SKILL.md)
Annual Insurance Word Report
What this package does
- Resolves the target year from
yearor fromrequest_text - Queries
gh_hg_bscyearall_dues - Reads
INFORMATION_SCHEMA.COLUMNScomments before rendering - Fills the bundled yearly Word template without depending on Word COM
- Writes the finished
.docxfile tooutputs/by default
Inputs
request_text: optional natural-language request, for example帮我生成2023年业务报告year: optional explicit year, for example2023template_path: optional custom.docxtemplate pathoutput_path: optional custom output.docxpathdb_host: optional, default127.0.0.1db_port: optional, default3306db_user: optional, defaultrootdb_password: optional, defaultrootdatabase: optional, defaulttest_dbtable_name: optional, defaultgh_hg_bscyearall_duescharset: optional, defaultutf8mb4mysql_cli: optional fallback path tomysqlCLI ifPyMySQLis unavailable
Run
Install dependencies:
pip install -r requirements.txt
Run with an explicit year:
python src/main.py --year 2023
Run with request text extraction:
python src/main.py --request-text "帮我生成2023年业务报告"
Custom database example:
python src/main.py --year 2023 --database test_db --db-user root --db-password root
Notes
- The default output path is
outputs/annual-insurance-report-\x3Cyear>.docx. - The default template is stored as text in
assets/beijing_office_annual_template.docx.base64.txtand is restored to a temporary.docxat runtime. - The package keeps the original business mapping:
团意、子女、女工、重疾、轻症、住院、津贴、补充、两癌、综合A、综合B、合计. - If
PyMySQLis not installed, the entry falls back to themysqlCLI whenmysql_cliis provided ormysqlis onPATH.
安全使用建议
This skill appears to do what it says: generate a .docx report from a MySQL table using an embedded template. Before running it: (1) don't run it with high-privilege or production DB credentials — provide a least-privilege, read-only account scoped to the reporting schema; (2) inspect the bundled template (assets/...base64.txt) if you need to confirm its contents; (3) be aware the code may call the mysql CLI fallback (subprocess.run) if PyMySQL is unavailable — ensure mysql on PATH is the binary you expect; (4) run in an isolated environment if you are unsure (or review the full src/main.py for any additional behavior). Overall there are no red flags that contradict the declared purpose, but treat any DB access as sensitive and use appropriate credentials and environment isolation.
能力评估
Purpose & Capability
Name/description, SKILL.md, skill.json, and src/main.py all describe querying a MySQL table, reading INFORMATION_SCHEMA column comments, mapping fields, and producing a .docx from a bundled base64 template. The declared inputs (db_host, db_user, db_password, database, table_name, year, etc.) are exactly what this task needs.
Instruction Scope
Runtime instructions are focused: install requirements, run src/main.py with db parameters or request_text. The entry code reads the bundled base64 template, queries MySQL (via PyMySQL or a mysql CLI fallback), reads INFORMATION_SCHEMA, and writes outputs/. It does not contact external network endpoints or attempt to read unrelated system files. Note: the code may invoke the mysql CLI via subprocess.run when PyMySQL isn't available — this is expected for the provided fallback but means the system must have mysql on PATH if used.
Install Mechanism
There is no remote download; requirements.txt only lists PyMySQL. The template is embedded in-repo as a base64 text file. No install script pulls arbitrary code from the network or writes binary blobs to unusual locations.
Credentials
The skill requests database connection parameters as inputs (db_host/db_user/db_password/database/table_name), which are proportionate to querying MySQL. No unrelated environment variables or external service credentials are requested.
Persistence & Privilege
always is false; the skill is user-invocable and does not request permanent/force-installed privileges or modify other skills or system-wide agent settings.
如何使用
- 确保已安装 OpenClaw（本地或 Docker 部署）
- 在对话框中输入安装命令：
/install annual-insurance-word-report - 安装完成后，直接呼叫该 Skill 的名称或使用
/annual-insurance-word-report触发 - 根据 Skill 的参数说明提供必要输入，即可获得结构化输出
版本历史
v1.0.0
Annual Insurance Word Report v1.0.0
- Initial release: Generate annual insurance welfare Word reports in OpenClaw format.
- Automatically extracts the target year from input or natural-language request.
- Queries MySQL table `gh_hg_bscyearall_dues` and reads column comments for field mapping.
- Fills and exports yearly business data into a bundled Word `.docx` template without Word COM.
- Supports flexible configuration for database connection, template, and output paths.
- Falls back to `mysql` CLI if `PyMySQL` is unavailable.
元数据
常见问题
lin 是什么？
Generate annual insurance welfare Word reports from `gh_hg_bscyearall_dues` in OpenClaw format. The packaged Python entry extracts the target year, inspects... 它是一个面向 Claude Code / OpenClaw 的 AI Agent Skill 插件，目前累计下载 89 次。
如何安装 lin？
在 OpenClaw 或 Claude Code 对话框中运行命令「/install annual-insurance-word-report」即可一键安装，无需额外配置。
lin 是免费的吗？
是的，lin 完全免费，采用 MIT-0 许可证，可自由下载、安装和使用。
lin 支持哪些平台？
lin 跨平台运行，可在任意部署了 OpenClaw / Claude Code 的环境中使用（cross-platform）。
谁开发了 lin？
由 番茄番茄番茄范（@lin-shiwu）开发并维护，当前版本 v1.0.0。
推荐 Skills