Menu
Keep generated MCP schemas strict-client compatible by avoiding nullable enum signatures.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
{what this skill teaches agents}
Excel CLI automation skill for Windows workbooks. Use when a coding agent needs token-efficient, scriptable, or unattended Excel automation via excelcli commands. Best for CI/CD, scheduled jobs, batch processing, PowerShell workflows, and bulk workbook edits. Supports Power Query, DAX, PivotTables, Tables, Ranges, Charts, VBA, Data Models, screenshots, and formatting. Triggers: excelcli, Excel CLI, command line, batch, script, automation, CI/CD, scheduled, PowerShell, unattended, coding agent, workbook processing.
Excel MCP Server skill for Windows workbook automation. Use when an assistant needs rich MCP tools to create, inspect, modify, format, or analyze Excel files. Supports Power Query (M), Data Model/DAX, PivotTables, Tables, Ranges, Charts, Slicers, formatting, screenshots, VBA macros, connections, and calculation mode. Triggers: Excel, spreadsheet, workbook, xlsx, xlsm, Power Query, DAX, PivotTable, chart, dashboard, VBA, MCP.
{what this skill teaches agents}
Catch packaging-script regressions by asserting the real script exit path and current overlay surface.
Use a validated tooling downgrade when Dependabot flags an unpatchable transitive vulnerability in build-only dependencies.
| name | mcp-schema-enum-regression |
| description | Keep generated MCP schemas strict-client compatible by avoiding nullable enum signatures. |
| domain | mcp-server |
| confidence | high |
| source | observed |
Use this when an MCP client rejects tool schemas because enum arrays include invalid sentinel members (often surfaced as null or empty strings).
ListToolsAsync() and recurse every schema node that contains an enum array.action parameter as a required enum when you want discoverable action lists.[FromString] enum paths, keep the string transport shape and let the existing service-side parser do the enum conversion.src/ExcelMcp.Generators.Mcp/McpToolGenerator.cs: required action enum, optional enum-like inputs as strings, local parse for direct enum parameters.tests/ExcelMcp.McpServer.Tests/Integration/Tools/GeneratedToolSchemaEnumRegressionTests.cs: recursive schema regression plus focused optional-parameter check..g.cs output by hand.action; scan every enum-bearing property across the tool catalog.