← Back to Skills Marketplace
89
Downloads
0
Stars
0
Active Installs
1
Versions
Install in OpenClaw
/install annual-insurance-word-report
Description
Generate annual insurance welfare Word reports from `gh_hg_bscyearall_dues` in OpenClaw format. The packaged Python entry extracts the target year, inspects...
README (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.
Usage Guidance
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.
Capability Assessment
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.
How to Use
- Make sure OpenClaw is installed (local or Docker)
- Run the install command in chat:
/install annual-insurance-word-report - After installation, invoke the skill by name or use
/annual-insurance-word-report - Provide required inputs per the skill's parameter spec and get structured output
Version History
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.
Metadata
Frequently Asked Questions
What is lin?
Generate annual insurance welfare Word reports from `gh_hg_bscyearall_dues` in OpenClaw format. The packaged Python entry extracts the target year, inspects... It is an AI Agent Skill for Claude Code / OpenClaw, with 89 downloads so far.
How do I install lin?
Run "/install annual-insurance-word-report" in the OpenClaw or Claude Code chat to install it in one step — no extra setup required.
Is lin free?
Yes, lin is completely free, licensed under MIT-0. You can download, install and use it at no cost.
Which platforms does lin support?
lin is cross-platform and runs anywhere OpenClaw / Claude Code is available (cross-platform).
Who created lin?
It is built and maintained by 番茄番茄番茄范 (@lin-shiwu); the current version is v1.0.0.
More Skills