Skip to main content
Glama
cliwant

mcp-sam-gov

by cliwant

treasury_query_dataset

Read-only

Query seven confirmed US Treasury Fiscal Data datasets including debt, interest rates, and exchange rates. Filter, sort, and paginate results without any API key.

Instructions

Escape-hatch query over 7 confirmed US Treasury Fiscal Data datasets (keyless): debt_to_penny, avg_interest_rates, mts_table_1 (Monthly Treasury Statement), rates_of_exchange, debt_outstanding, interest_expense (actual interest PAID / debt-service cost), tror (Treasury Report on Receivables — federal receivables + delinquent-debt collections by agency). Choose dataset (enum — no free path), and optionally project fields (CSV), filter (CSV 'col:op:val', ops lt|lte|gt|gte|eq|in, AND-combined), and sort (CSV, '-' = desc), with page[size]/page[number] pagination. Returns raw rows plus a truthful _meta (totalAvailable = upstream total-count, offset pagination). Value/amount fields are raw upstream strings — the string "null"/empty means 'no value', never 0. Covers rates_of_exchange + debt_outstanding without a dedicated tool.

Input Schema

TableJSON Schema
NameRequiredDescriptionDefault
sortNoOptional CSV sort columns; prefix '-' for descending (e.g. '-record_date').
fieldsNoOptional CSV column projection (e.g. 'record_date,exchange_rate'). An unknown column ⇒ upstream HTTP 400 ⇒ invalid_input (surfaced as an error, never silently dropped).
filterNoOptional CSV of upstream filters 'col:op:val' (ops: lt|lte|gt|gte|eq|in), AND-combined — e.g. 'record_date:gte:2024-01-01,country_currency_desc:eq:Canada-Dollar'.
datasetYesWhich confirmed Treasury Fiscal Data dataset to query: debt_to_penny (daily total public debt), avg_interest_rates (avg rate by security type), mts_table_1 (Monthly Treasury Statement receipts/outlays/deficit), rates_of_exchange (quarterly FX by currency), debt_outstanding (historical fiscal-year-end debt), interest_expense (ACTUAL interest PAID / debt-service cost by security type — distinct from the rate), tror (Treasury Report on Receivables: federal receivables + delinquent-debt collections BY AGENCY).
pageSizeNoRows per page (upstream page[size]); 1..500, default 100.
pageNumberNo1-based page number (upstream page[number]); default 1.
Behavior4/5

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

Annotations already declare readOnlyHint=true and openWorldHint=true, so the agent knows it is a safe read operation. The description adds useful behavioral context: keyless access, raw string values for amounts, null/empty handling, pagination behavior, and the truthful _meta field. No contradiction with annotations.

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 dense and informative, covering many aspects in a single paragraph. It front-loads the core purpose and dataset list. Could be slightly more structured (e.g., bullet points for parameters) but remains efficient with minimal waste.

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?

There is no output schema, so the description must cover return values. It does so: 'Returns raw rows plus a truthful `_meta` (totalAvailable = upstream total-count, offset pagination)' and explains that value/amount fields are raw strings with null/empty meaning 'no value'. It also describes error behavior for unknown columns. For a tool with 6 parameters and no output schema, this is comprehensive.

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?

Schema description coverage is 100%, but the description adds significant extra meaning: explains that unknown columns in fields cause an upstream HTTP 400 error, provides filter syntax with examples, describes sort prefix '-' for descending, and gives pagination bounds (1..500, 1-based). Dataset enum values are explained in more detail. The description compensates completely for any ambiguity.

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 specifies it is an escape-hatch query over 7 confirmed US Treasury Fiscal Data datasets, listing them explicitly (debt_to_penny, avg_interest_rates, etc.). It distinguishes from sibling tools by noting it covers rates_of_exchange and debt_outstanding without a dedicated tool.

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?

The description states 'Choose `dataset` (enum — no free path)' and describes the tool as an escape-hatch for 7 specific datasets. It implicitly guides usage by listing datasets and mentioning that it covers datasets without dedicated tools. No explicit when-not-to-use or alternatives, but the context of sibling tools provides clear differentiation.

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/cliwant/mcp-sam-gov'

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