{"report":"{\"v\":1,\"package\":\"@cyanheads/treasury-fiscaldata-mcp-server\",\"version\":\"0.5.0\",\"ranAt\":\"2026-11-16T11:56:31.025Z\",\"install\":{\"ok\":true,\"integrity\":\"sha512-ItHWqO874DsFrExTrcqAh4NJL5ceM6PyivZT0wIheSUX0FGBUxy0xGQwtK2ozV0S2R1FNOwK3KwozNczmxk8kA==\",\"deps\":47,\"scripts\":[],\"bins\":[\"treasury-fiscaldata-mcp-server\"],\"license\":\"Apache-2.0\",\"engines\":\"node >=24.0.0\",\"repository\":\"git+https://github.com/cyanheads/treasury-fiscaldata-mcp-server.git\",\"bin\":\"treasury-fiscaldata-mcp-server\"},\"start\":{\"ok\":true,\"ms\":357,\"serverName\":\"treasury-fiscaldata-mcp-server\",\"serverVersion\":\"0.5.0\",\"protocol\":\"2025-06-18\",\"stderr\":\"tion\\\":\\\"StorageService.get\\\",\\\"requestId\\\":\\\"WKB48-T8AVI\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:56:45.603Z\\\",\\\"jsonRpcId\\\":7,\\\"toolName\\\":\\\"treasury_dataframe_describe\\\",\\\"key\\\":\\\"canvas-id\\\",\\\"msg\\\":\\\"[StorageService] get operation\\\"}\\n{\\\"level\\\":20,\\\"time\\\":1794830205605,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.5.0\\\",\\\"pid\\\":59,\\\"operation\\\":\\\"HandleToolRequest\\\",\\\"requestId\\\":\\\"WKB48-T8AVI\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:56:45.603Z\\\",\\\"jsonRpcId\\\":7,\\\"toolName\\\":\\\"treasury_dataframe_describe\\\",\\\"msg\\\":\\\"[InMemoryProvider] Getting key: canvas-id for tenant: default\\\"}\\n{\\\"level\\\":20,\\\"time\\\":1794830205605,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.5.0\\\",\\\"pid\\\":59,\\\"operation\\\":\\\"StorageService.list\\\",\\\"requestId\\\":\\\"WKB48-T8AVI\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:56:45.603Z\\\",\\\"jsonRpcId\\\":7,\\\"toolName\\\":\\\"treasury_dataframe_describe\\\",\\\"prefix\\\":\\\"df-meta/\\\",\\\"limit\\\":100,\\\"hasCursor\\\":false,\\\"msg\\\":\\\"[StorageService] list operation\\\"}\\n{\\\"level\\\":20,\\\"time\\\":1794830205605,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.5.0\\\",\\\"pid\\\":59,\\\"operation\\\":\\\"HandleToolRequest\\\",\\\"requestId\\\":\\\"WKB48-T8AVI\\\",\\\"tenantId\\\":\\\"default\\\",\\\"timestamp\\\":\\\"2026-11-16T11:56:45.603Z\\\",\\\"jsonRpcId\\\":7,\\\"toolName\\\":\\\"treasury_dataframe_describe\\\",\\\"options\\\":{\\\"limit\\\":100},\\\"msg\\\":\\\"[InMemoryProvider] Listing keys with prefix: df-meta/ for tenant: default\\\"}\\n{\\\"level\\\":30,\\\"time\\\":1794830205605,\\\"env\\\":\\\"development\\\",\\\"version\\\":\\\"0.5.0\\\",\\\"pid\\\":59,\\\"operation\\\":\\\"HandleToolRequest\\\",\\\"requestId\\\":\\\"WKB48-T8AVI\\\",\\\"timestamp\\\":\\\"2026-11-16T11:56:45.603Z\\\",\\\"jsonRpcId\\\":7,\\\"toolName\\\":\\\"treasury_dataframe_describe\\\",\\\"metrics\\\":{\\\"durationMs\\\":1.8,\\\"isSuccess\\\":true,\\\"inputBytes\\\":2,\\\"outputBytes\\\":17},\\\"msg\\\":\\\"Tool execution finished.\\\"}\\n\"},\"tools\":[{\"name\":\"treasury_list_datasets\",\"description\":\"Browse the curated catalog of US Treasury Fiscal Data API endpoints. Returns endpoint paths, field names, descriptions, and update cadence for each dataset. Use this tool before treasury_query_dataset to discover the correct endpoint path and field names. The catalog is a curated subset of the full API — pass any endpoint path directly to treasury_query_dataset to query datasets not listed here; a field name the endpoint lacks fails with an error that lists every field it has. The catalog covers debt, interest rates, exchange rates, revenue/spending, savings bonds, and securities datasets.\",\"params\":[\"category\",\"search\"]},{\"name\":\"treasury_query_dataset\",\"description\":\"Query any Treasury Fiscal Data endpoint by path, field list, filters, sort, and page. Call treasury_list_datasets first to get the correct endpoint path and exact field names; a field name the endpoint lacks fails with an error listing every field it has. Filter syntax: each condition is { field, operator, value } where operator is eq/gt/gte/lt/lte/in (e.g., record_date:gte:2024-01-01). Multiple conditions are ANDed together. All response values are strings per the API contract, including numbers and dates; \\\"null\\\" (string) means no value. Supply canvas_id to stage the page result as a DataCanvas table — read its column schema with treasury_dataframe_describe, then run SQL over it with treasury_dataframe_query (requires CANVAS_PROVIDER_TYPE=duckdb on the server).\",\"params\":[\"endpoint\",\"fields\",\"filters\",\"sort\",\"page_size\",\"page_number\",\"canvas_id\"]},{\"name\":\"treasury_get_debt\",\"description\":\"Fetch national debt (Debt to the Penny) — total public debt outstanding broken into publicly-held debt and intragovernmental holdings. Three modes: \\\"latest\\\" returns the most recent business day's record; \\\"date\\\" returns the record for a specific date (must be a business day — the API only records debt on days markets are open); \\\"series\\\" returns a date range, staging the full result as a DataCanvas table when canvas_id is set or the range matches more than 500 rows — read the table's column schema with treasury_dataframe_describe, then run SQL over it with treasury_dataframe_query. Records go back to 1993-04-01.\",\"params\":[\"mode\",\"date\",\"start_date\",\"end_date\",\"canvas_id\"]},{\"name\":\"treasury_get_interest_rates\",\"description\":\"Average interest rates Treasury pays on its outstanding securities by security type. Answers \\\"what is the government's cost of borrowing?\\\" Covers every type Treasury reports — marketable issues, non-marketable series, and the aggregate totals — and which types it reports changes over the years, so omit security_type to see the ones a given period carries. Rates are percentages, not basis points. Updated monthly (end-of-month records). Mode \\\"latest\\\" returns the most recent month's rates for all or one security type; \\\"series\\\" returns a time history, staging the result as a DataCanvas table when canvas_id is set or the range matches more than 200 rows — read the table's column schema with treasury_dataframe_describe, then run SQL over it with treasury_dataframe_query.\",\"params\":[\"mode\",\"security_type\",\"start_date\",\"end_date\",\"canvas_id\"]},{\"name\":\"treasury_get_exchange_rates\",\"description\":\"Official Treasury reporting exchange rates for ~165 countries — the rates US federal agencies are required to use when converting foreign currency to USD for official reporting. Published quarterly (March 31, June 30, Sep 30, Dec 31); mode \\\"latest\\\" returns the most recently published quarter. Rate is expressed as foreign currency units per 1 USD (e.g., a Japan-Yen rate of 159.41 means 1 USD = 159.41 JPY). These are NOT market exchange rates and are not suitable for financial transaction pricing. Mode \\\"series\\\" stages the result as a DataCanvas table when canvas_id is set or the range matches more than 500 rows — read the table's column schema with treasury_dataframe_describe, then run SQL over it with treasury_dataframe_query.\",\"params\":[\"mode\",\"countries\",\"start_date\",\"end_date\",\"canvas_id\"]},{\"name\":\"treasury_dataframe_describe\",\"description\":\"List DataCanvas dataframes materialized by treasury_query_dataset, treasury_get_debt, treasury_get_interest_rates, and treasury_get_exchange_rates. Each entry surfaces source tool, query parameters, creation/expiry timestamps, row count, and column schema. Use this tool before treasury_dataframe_query to discover table names and column types. Requires CANVAS_PROVIDER_TYPE=duckdb.\",\"params\":[\"name\"]},{\"name\":\"treasury_dataframe_query\",\"description\":\"Run a single-statement SELECT against DataCanvas dataframes registered by treasury_query_dataset, treasury_get_debt, treasury_get_interest_rates, and treasury_get_exchange_rates. Read-only: writes, DDL, DROP, COPY, PRAGMA, ATTACH, and external-file table functions are rejected. System catalogs (information_schema, pg_catalog, sqlite_master, duckdb_*) are denied at the bridge layer. Tables staged from Treasury API rows hold every column as VARCHAR — CAST to DECIMAL or DATE for arithmetic and date comparisons; a register_as table keeps the column types its SELECT produced. Use treasury_dataframe_describe to list available table names and column schemas before querying.\",\"params\":[\"sql\",\"register_as\",\"preview\",\"row_limit\"]}],\"toolsHash\":\"19d84ed7c416ee11fde65e774b2e9c4eb6d9e54652a634c79832ca62c4d6ad9b\",\"wrote\":[],\"callsAt\":\"2026-11-16T11:56:43.256Z\",\"calls\":[{\"tool\":\"treasury_list_datasets\",\"ok\":true,\"ms\":8,\"bytes\":23700},{\"tool\":\"treasury_get_debt\",\"ok\":true,\"ms\":348,\"bytes\":156},{\"tool\":\"treasury_get_interest_rates\",\"ok\":true,\"ms\":349,\"bytes\":1208},{\"tool\":\"treasury_get_exchange_rates\",\"ok\":true,\"ms\":641,\"bytes\":12939},{\"tool\":\"treasury_dataframe_describe\",\"ok\":true,\"ms\":3,\"bytes\":21}],\"host\":{\"commit\":\"eaaffffaf52255d1b77dc4aacffdfaf353f0c12c\",\"run\":\"https://github.com/itsHaddad/bragproof/actions/runs/43857070216\"},\"network\":{\"names\":[\"registry.npmjs.org\"],\"conns\":[],\"callNames\":[\"api.fiscaldata.treasury.gov\"],\"callConns\":[]}}","token":"eyJhbGciOiJSUzI1NiIsImtpZCI6IjM4ODI2YjE3LTZhMzAtNWY5Yi1iMTY5LThiZWI4MjAyZjcyMyIsInR5cCI6IkpXVCIsIng1dCI6InlrTmFZNHFNX3RhNGsyVGdaT0NFWUxrY1lsQSJ9.eyJhY3RvciI6Iml0c0hhZGRhZCIsImFjdG9yX2lkIjoiMTE0NzMyNjEiLCJhdWQiOiJicmFncHJvb2YtcmVwb3J0OmMwZjk0ODU1YmEzMjEzOGYwYWI0ZTE4YmVmYjIzYjJiYjJmN2VlNjQyOTBmZmRiNjg2ZjU2M2JjZDcxN2IzYTUiLCJiYXNlX3JlZiI6IiIsImNoZWNrX3J1bl9pZCI6IjEzMzI2Mzk5NTMyNCIsImV2ZW50X25hbWUiOiJzY2hlZHVsZSIsImV4cCI6MTc5NDgzMDUxMCwiaGVhZF9yZWYiOiIiLCJpYXQiOjE3OTQ4MzAyMTAsImlzcyI6Imh0dHBzOi8vdG9rZW4uYWN0aW9ucy5naXRodWJ1c2VyY29udGVudC5jb20iLCJqb2Jfd29ya2Zsb3dfcmVmIjoiaXRzSGFkZGFkL2JyYWdwcm9vZi8uZ2l0aHViL3dvcmtmbG93cy9yZXBvcnQueW1sQHJlZnMvaGVhZHMvbWFpbiIsImpvYl93b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIiwianRpIjoiZDQ1Y2Y3NTUtOGVjNS00YjhmLWE3MzItYTViZjlmOTFjYjBlIiwibmJmIjoxNzk0ODI5OTEwLCJyZWYiOiJyZWZzL2hlYWRzL21haW4iLCJyZWZfcHJvdGVjdGVkIjoiZmFsc2UiLCJyZWZfdHlwZSI6ImJyYW5jaCIsInJlcG9zaXRvcnkiOiJpdHNIYWRkYWQvYnJhZ3Byb29mIiwicmVwb3NpdG9yeV9pZCI6IjE0NTQ2MjExODMiLCJyZXBvc2l0b3J5X293bmVyIjoiaXRzSGFkZGFkIiwicmVwb3NpdG9yeV9vd25lcl9pZCI6IjExNDczMjYxIiwicmVwb3NpdG9yeV92aXNpYmlsaXR5IjoicHVibGljIiwicnVuX2F0dGVtcHQiOiIxIiwicnVuX2lkIjoiNDM4NTcwNzAyMTYiLCJydW5fbnVtYmVyIjoiMjQiLCJydW5uZXJfZW52aXJvbm1lbnQiOiJnaXRodWItaG9zdGVkIiwic2hhIjoiZWFhZmZmZmFmNTIyNTVkMWI3N2RjNGFhY2ZmZGZhZjM1M2YwYzEyYyIsInN1YiI6InJlcG86aXRzSGFkZGFkQDExNDczMjYxL2JyYWdwcm9vZkAxNDU0NjIxMTgzOnJlZjpyZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvdyI6InJlcG9ydCIsIndvcmtmbG93X3JlZiI6Iml0c0hhZGRhZC9icmFncHJvb2YvLmdpdGh1Yi93b3JrZmxvd3MvcmVwb3J0LnltbEByZWZzL2hlYWRzL21haW4iLCJ3b3JrZmxvd19zaGEiOiJlYWFmZmZmYWY1MjI1NWQxYjc3ZGM0YWFjZmZkZmFmMzUzZjBjMTJjIn0.J7O52vcSJvsdcmPycvdueyG2nJ76G47w4acsqMiEengBixKYSJyC6aNLrqwHTAMKYjKd86a0RCLplelpGcQco0wWIeF1skTh1qob9nC9KaPfs4KYlMGwNweuU7fXVFtOjd37CM0HCFy6LuwjB02wYJwXcvJx4IKOmW_a5ljiyTZ_QzZyYxdo7jgNdnqlf9H4jbN4nOPHCUvtV9WO0U5LwjOziMaZ5tW8PHo-TViokNC6RibyWqr_8rmUkmaydDaNg24PBmTASjGBTdt9aVdy7dHBqA6VtIZblHJbuDLKEQDdqC-b0cL1E1dAvISnNZkA15kyJqH8UW8B3uYPE3mWRw"}