Skip to main content
Glama

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

Get U.S. Public Contract Discount Rates off List Price (kake ratio)

get_us_contract_discounts
Read-only

州と共同購買の契約書が公開している、定価からの値引き率を返す(ワシントン州 DES 23623 配管部材・11121 電気資材、NASPO ValuePoint の資材 MRO の Grainger・Fastenal・MSC・Lawson・HD Supply、Home Depot の塗料)。掛け率 = 1 - 値引き率(computed:true)。定価への上乗せ(Over MSRP)と業者の目録からの値引き(Catalog Off)は別の列で、掛け率には入れない。率は上限で、定価の基準は行ごとに違う。例: query='eaton breakers'。 / Published discount rates off list price in U.S. public contracts (Washington DES plumbing and electrical, NASPO ValuePoint MRO), with kake_ratio = 1 - discount (computed:true). Over-MSRP and catalog-off rows are kept separate. Rates are ceilings; list bases differ by row.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
basisNo値引きの基準で絞る: MSRP Discount 定価からの値引き、Over MSRP 定価への上乗せ、Catalog Off 業者の目録からの値引きなど。 / Discount basis filter, e.g. MSRP Discount, Over MSRP, Catalog Off.
limitNo返す行の上限(1〜100)。 / Maximum rows to return (1 to 100).
queryNoメーカー・製品系列・分野・業者の語(英語)。 / Manufacturer, product line, category or vendor words.
offsetNo飛ばす行の数。limit と組んで次のページを取る。 / Rows to skip; use with limit to page through results.
vendorNo業者名(英語。例 Grainger, Fastenal)。 / Vendor name.
source_idNo契約の出典: wa-des-23623 ワシントン州の配管部材、wa-des-11121 同じく電気資材、naspo-mro-ak NASPO ValuePoint の資材 MRO。 / Contract source: wa-des-23623 (Washington DES plumbing), wa-des-11121 (Washington DES electrical), naspo-mro-ak (NASPO ValuePoint MRO).
manufacturerNoメーカー名(英語)。 / Manufacturer name.

Output Schema

TableJSON Schema
NameRequiredDescriptionDefault
rowsNo契約・メーカーごとの値引き率と kake_ratio / discount and kake ratio
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.
summary_by_vendorNoメーカーごとの要約 / summary by vendor

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observed

TDQS

A3.6/5.0
Behavior4/5

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

Annotations already cover the safety profile (readOnlyHint, destructiveHint=false, openWorldHint=false), so the description adds real value on top: it discloses that kake_ratio is computed as 1 - discount, that Over-MSRP and Catalog-Off rows are kept in separate columns and excluded from kake_ratio, and that rates are ceilings with list bases varying by row. These are substantive semantic caveats not present in the annotations.

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

Conciseness3/5

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

The core purpose is front-loaded and the example is useful, but the entire text is duplicated in Japanese and English, roughly doubling length without adding information. Several caveats are packed into dense clauses that would be clearer as separate sentences.

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 explanation is not required. The description adequately covers data provenance (specific contract IDs), the computed kake_ratio, and the ceiling/list-base caveats, giving an agent enough to interpret results correctly; only explicit alternative-tool routing is missing.

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

Parameters3/5

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

Schema description coverage is 100% and all seven parameters carry bilingual schema descriptions, so the baseline is 3. The description adds an example query value and clarifies that the returned 'rate' is a ceiling, but it does not add per-parameter meaning beyond what the schema already provides for basis, vendor, source_id, limit, or offset.

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?

The description states a specific verb and resource — returns published discount rates off list price from U.S. public contracts — and enumerates the exact contract sources (Washington DES 23623 plumbing, 11121 electrical, NASPO ValuePoint MRO) plus named vendors. It is clearly distinguishable from pricing siblings like get_price_range or get_fair_price_sources, though it never explicitly contrasts itself with them.

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?

An example query ('eaton breakers') and the enumerated sources imply when the tool is useful, but there is no explicit when-to-use statement, no conditions for choosing this over get_us_construction_prices or get_fair_price_sources, and no stated exclusions. Usage is only inferable.

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.