treasury_dataframe_query

MCP tool from Treasury Fiscaldata MCP Server by cyanheads

Run a single-statement SELECT against DataCanvas dataframes using standard DuckDB SQL

How to use it

Project documentation lists treasury_dataframe_query for the Treasury Fiscaldata MCP Server MCP server. Add the server to your MCP client (Claude Desktop, Cursor, Windsurf and others), then check which tools your installed version makes available. Tool availability can depend on configuration and credentials. A server handshake does not verify this tool’s behavior. See the full listing for setup details.

Install Treasury Fiscaldata MCP Server

$bunx @cyanheads/treasury-fiscaldata-mcp-server@latest

FULL TREASURY FISCALDATA MCP SERVER LISTING

Other tools in Treasury Fiscaldata MCP Server (7)

Read-only.

Writes, DDL, DROP, COPY, PRAGMA, ATTACH, and external-file table functions are rejected by the SQL gate. System catalogs (informationschema, pgcatalog, sqlitemaster, duckdb) are denied at the bridge layer.

treasury_dataframe_describe

List DataCanvas dataframes materialized by the treasury tools with schema, row count, and TTL

treasury_get_debt

Fetch national debt (Debt to the Penny) — latest record, specific date, or date-range series with optional DataCanvas spill

treasury_get_exchange_rates

Official Treasury statutory exchange rates for ~165 countries, published quarterly

treasury_get_interest_rates

Average interest rates Treasury pays on outstanding securities by type — marketable issues, non-marketable series, and aggregate totals

treasury_list_datasets

Browse the curated catalog of 17 Treasury Fiscal Data endpoints with field names, descriptions, and update cadence

treasury_query_dataset

Query any Treasury Fiscal Data endpoint by path, field list, filters, sort, and page — with optional DataCanvas spill