Skip to main content
Glama
linimeanie

Eurostat TAM MCP server

by linimeanie

fill_tam_sheet

Fill TAM sheet SME and 250+ cells with Eurostat enterprise counts by NACE, supporting dry-run preview and automatic NACE code resolution.

Instructions

Read NACE codes out of the TAM workbook's "Company Counts by Segment" sheet, pull Eurostat counts for every segment, and write the SMEs (col F) and Corp Mid-cap 250+ (col G) cells.

Only yellow input cells on segment rows are written; blue subtotals, the grey public-sector row, and demand-side rows are left untouched. Class-level NACE codes (which Eurostat lacks) are resolved down to the nearest available group/division and flagged per row under "coarsened".

Args: input_path: path to the .xlsx (e.g. the TAM_Model_with_NAICS.xlsx). output_path: where to save. Defaults to "_FILLED.xlsx". Pass the same path as input ONLY if you intend to overwrite the original. dry_run: if True (default), nothing is written — returns the full plan (per-row resolved codes, levels, and the SME/250+ it WOULD write) so you can audit before committing. Set False to actually save. geo: Eurostat geos, default EU27 + Norway + Switzerland. year: single year, or omit for latest per code. exclude_micro: exclude micro firms (0-9) from the SME bucket.

Returns the plan (dry_run) or a write summary plus the plan.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
geoNo
yearNo
dry_runNo
input_pathYes
output_pathNo
exclude_microNo

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault

No arguments

Behavior5/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

With no annotations, the description fully discloses side effects: only yellow input cells on segment rows are written, blue subtotals/grey rows/demand-side rows are untouched, class-level NACE codes are resolved and flagged, and dry_run returns a plan while actual write returns a summary. This is exemplary transparency for a mutation tool.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness4/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is well-organized: a concise summary paragraph followed by a detailed Args bullet list. Every sentence provides useful information and avoids redundancy. Though longer than typical MCP descriptions, the complexity of the tool justifies the length, and the structure keeps it scannable.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness5/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The description covers the complete workflow, safety mechanisms (dry_run, overwrite warning), edge cases (class-level NACE resolution), and return values (plan or write summary plus plan). With an output schema present, the input side is fully specified. This is a complete and self-contained description for a complex tool.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters5/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

The schema has 0% description coverage, so the description completely takes over documenting all six parameters. Each parameter is explained with defaults, examples, and special conditions (e.g., output_path overwrite warning, dry_run behavior, exclude_micro meaning). This adds immense semantic value beyond the raw schema.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description clearly states the tool's specific action: reading NACE codes from the TAM workbook's 'Company Counts by Segment' sheet, pulling Eurostat counts, and writing to columns F and G. This distinguishes it from sibling tools which are all read-only getter tools; this is the write/fill operation.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

Provides strong usage context: dry_run default allows auditing before committing, warns against overwriting the original unless intended, and explains parameter behaviors. It does not explicitly name alternatives, but the sibling context makes it clear this is the only write tool. The guidance is practical and cautionary.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Install Server

Other Tools

Latest Blog Posts

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/linimeanie/eurostat-tam-mcp'

If you have feedback or need assistance with the MCP directory API, please join our Discord server