payroll-normalizer-mcp
Server Configuration
Describes the environment variables required to run the server.
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Instructions
Guidance the server publishes about itself, which clients place ahead of the tool catalog so the model reads it before choosing anything.
This server publishes no instructions, or was last inspected before Glama recorded them.
Capabilities
Features and capabilities supported by this server
Protocol revision2025-11-25
| Capability | Details |
|---|---|
| tools | {
"listChanged": false
} |
| prompts | {
"listChanged": false
} |
| resources | {
"subscribe": false,
"listChanged": false
} |
| experimental | {} |
Tools
Functions exposed to the LLM to take actions
| Name | Description |
|---|---|
| standard_columnsA | 返回社保测算标准模板的 10 列定义、身份类型可选值与关键口径（应发≠实发等）。 模型在做列映射前应先读这个。 |
| inspect_payrollA | 检查文件夹内每个工资表(.xlsx/.xls/.csv)：返回表头、前3行样本、自动识别到的字段映射、应发口径与问题。 当某文件无法自动映射时，模型据此判断每列含义，再在 normalize_payroll 的 overrides 里给出 column_map/entity/ym。 folder: 存放工资表的文件夹绝对路径。 |
| normalize_payrollA | 把文件夹内所有工资表整理成『社保测算标准模板』(xlsx) + 整理报告(md)，按自然人跨主体跨月归并。 folder: 存放工资表的文件夹绝对路径。 output_dir: 产出目录(默认与 folder 相同)。 overrides_json: 可选 JSON 字符串，用于修正自动识别不了的文件，形如： {"某文件.xlsx": {"entity": "甲公司", "ym": "2025-03", "column_map": {"name": "员工", "gross": "税前总额", "id": 0}}} column_map 的值可为"表头文字"或列序号(从0起)；字段名取标准字段： name/id/entity/ym/gross/total/unit_ss/net/stype/gjj_paid/gjj_base/gjj_ratio。 返回 JSON：产出路径、记录数、应发口径分布、需人工接管的文件清单、报告 markdown。 |
| generate_blank_templateA | 生成空白的『社保测算标准工资模板』(xlsx)：含顶部填表说明、身份类型/是否缴公积金下拉、示例行。 output_path: 输出文件绝对路径(默认当前目录下 社保测算-标准工资模板.xlsx)。返回实际路径。 |
Prompts
Interactive templates invoked by user choice
| Name | Description |
|---|---|
No prompts | |
Resources
Contextual data attached and managed by the client
| Name | Description |
|---|---|
No resources | |
TDQS
Scored across 4 tools
Each tool has a clearly distinct purpose: template generation, folder inspection, normalization with overrides, and column reference. No overlaps.
All tools use consistent snake_case verb_noun pattern (generate_blank_template, inspect_payroll, normalize_payroll, standard_columns).
4 tools cover the core workflow (template, inspect, normalize, reference) without being excessive or insufficient for the payroll normalization domain.
The tool surface provides a complete workflow from inspection to normalization with overrides. Minor gap: no separate tool for post-normalization validation, but overrides handle corrections.