Skip to main content
Glama

HORIZON SHIELD Construction Cost Data: JCCDB (Japan) and USCCDB (United States)

Get U.S. Wholesale and Retail Gross Margins (Census) and BEA Margin Structure

get_us_trade_margins
Read-only

米国の卸と小売の粗利率を NAICS で返す(Census AWTS 1992〜2022、ARTS 1993〜2022、AIES 2024)。kake_cost_ratio = 1 - 粗利率(売値のうち仕入れ原価の割合)。commodity か include_bea で BEA 2007 の建設業と家計の購入の流通構造(生産者価格・運賃・卸・小売・購入者価格)も。業種の平均で、個々の会社の仕入れ値ではない。例: naics='4233'(建材卸)、naics='444110'(ホームセンター)。 / U.S. wholesale and retail gross margins by NAICS (Census AWTS, ARTS, AIES 2024) with kake_cost_ratio = 1 - margin; optionally the BEA 2007 margin structure. Industry averages, not any firm's cost.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
yearNo年(例 2022。AIES は 2024)。 / Year, e.g. 2022 (AIES covers 2024).
limitNo返す行の上限(1〜200)。 / Maximum rows to return (1 to 200).
naicsNoNAICS の頭(4233 建材卸、423720 配管・暖房卸、4441 建材小売、444110 ホームセンター)。 / NAICS prefix.
queryNo業種の語(英語。例 plumbing, paint)。 / Industry words in English.
tradeNowholesale 卸 か retail 小売 で絞る。 / Filter to wholesale or retail.
historyNotrue で年ごと。 / All years.
commodityNoBEA の品目の語(英語。例 cement, lighting)。 / BEA commodity words.
include_beaNotrue で BEA 2007 の流通構造(生産者価格・運賃・卸・小売・購入者価格)も返す。 / true to add the BEA 2007 margin structure (producer price, freight, wholesale, retail, purchaser price).

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
rowsNoNAICS ごとの粗利率と kake_cost_ratio / margins and cost ratio by NAICS
countNoHow many records matched. 0 means the source was read and nothing matched. It never means the source could not be read, that returns isError: true.
lookupNook = the source was read and something matched. absent = the source was read and nothing matched. A source that could NOT be read never appears here: that returns isError: true and makes no claim about what does or does not exist.
source_readNotrue on every successful result. A failed lookup does not return a result at all, so this is never false, it is declared so a consumer can assert on it.
did_you_meanNoNear matches, when an exact match was not found.
margin_indexNoマージン物価指数 / trade-margin price indexes

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A3.8/5.0
Behavior4/5

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

Annotations already declare a safe read-only, non-open-world operation, so the bar is lower. The description adds genuine value beyond that: source coverage and years, the kake_cost_ratio definition, and the caveat that figures are industry averages rather than a firm's actual purchase cost.

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?

Purpose, formula, optional BEA behavior and the industry-average caveat are front-loaded before the examples. It is dense bilingual text but each clause carries information; only the duplicated EN/JA phrasing adds mild bulk.

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

Completeness4/5

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

An output schema exists, so return format need not be described. The description supplies source coverage, the derived metric definition, the optional BEA branch, and the key scope caveat, which is sufficient for an 8-param all-optional tool.

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

Parameters4/5

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

Schema coverage is 100%, so the schema already documents each parameter and the baseline is 3. The description goes further by showing the semantic link between commodity/include_bea and the optional BEA 2007 margin structure, and by mapping naics prefixes to trade categories.

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

Purpose4/5

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

States a specific verb+resource: returns U.S. wholesale and retail gross margins by NAICS, with named data sources (Census AWTS/ARTS/AIES) and the derived kake_cost_ratio. The resource is distinctive, but it does not distinguish itself from the sibling get_us_price_chain, which is also about a producer-to-purchaser price/margin chain.

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

Usage Guidelines3/5

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

Examples (naics='4233', '444110') and the scope caveat 'industry averages, not any firm's cost' imply usage without stating when to pick this over alternatives. There is no explicit when-not guidance or named sibling such as get_us_price_chain for a full chain request.

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

Try in Browser

Glama MCP Gateway

Add one secure layer between your agents and this server.