# `treasury__treasury_dataframe_describe`

**Describe Treasury Dataframes**

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.

- Server: [US Treasury FiscalData](https://gateway.mcpharbor.dev/docs/servers/treasury) (`dev.mcpharbor.gateway/treasury`)
- Price per call: $0.0001 (100 micro-USD); only tools/call is charged
- Endpoint: `https://gateway.mcpharbor.dev/mcp` or `https://gateway.mcpharbor.dev/mcp/treasury`
- Upstream tool: exposed by the provider; called through this gateway as `treasury__treasury_dataframe_describe`
- Provider terms: <https://fiscaldata.treasury.gov/api-documentation/> (verified 2026-09-19)
- Upstream API documentation: <https://fiscaldata.treasury.gov/api-documentation/>
- Rate limit: 300 requests per minute
- Attribution required: Not stated as required

## Parameters

- `name` (string, optional): Optional dataframe table name (df_XXXXX_XXXXX) to describe a single dataframe. Omit to list all active dataframes.

## Example call

Request headers and body:

```http
POST /mcp HTTP/1.1
Host: gateway.mcpharbor.dev
Authorization: Bearer <your gateway API key>
Content-Type: application/json
Accept: application/json, text/event-stream
MCP-Protocol-Version: 2026-07-28
Mcp-Method: tools/call
Mcp-Name: treasury__treasury_dataframe_describe
```

```json
{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "_meta": {
      "io.modelcontextprotocol/clientCapabilities": {},
      "io.modelcontextprotocol/clientInfo": {
        "name": "example-agent",
        "version": "1.0.0"
      },
      "io.modelcontextprotocol/protocolVersion": "2026-07-28"
    },
    "arguments": {
      "name": "example"
    },
    "name": "treasury__treasury_dataframe_describe"
  }
}
```

A successful response:

```json
{
  "id": 1,
  "jsonrpc": "2.0",
  "result": {
    "_meta": {
      "dev.mcpharbor.gateway/call": {
        "chargedMicroUsd": 100,
        "id": "<the id of this charge>"
      }
    },
    "content": [
      {
        "text": "<whatever the upstream tool returned>",
        "type": "text"
      }
    ],
    "resultType": "complete"
  }
}
```

This call costs $0.0001 (100 micro-USD). Reading this page and listing the tool cost nothing.
The `dev.mcpharbor.gateway/call` record in the result is the receipt for that charge. Each
POST is metered separately, so sending the same call again buys another one: see
[agent.txt](https://gateway.mcpharbor.dev/agent.txt), section 7, before retrying.

## Attribution

This provider requires the attribution below wherever you use results from its tools.
Reproduce it verbatim:

> Not stated as required

## Tool definition

Exactly as `tools/list` returns it (free):

```json
{
  "_meta": {
    "dev.mcpharbor.gateway/pricing": {
      "currency": "USD",
      "pricePerCallMicroUsd": 100
    }
  },
  "annotations": {
    "idempotentHint": true,
    "openWorldHint": false,
    "readOnlyHint": true
  },
  "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.",
  "inputSchema": {
    "$schema": "https://json-schema.org/draft/2020-12/schema",
    "additionalProperties": false,
    "properties": {
      "name": {
        "description": "Optional dataframe table name (df_XXXXX_XXXXX) to describe a single dataframe. Omit to list all active dataframes.",
        "type": "string"
      }
    },
    "type": "object"
  },
  "name": "treasury__treasury_dataframe_describe",
  "outputSchema": {
    "$schema": "https://json-schema.org/draft/2020-12/schema",
    "additionalProperties": false,
    "anyOf": [
      {
        "not": {
          "required": [
            "error"
          ]
        },
        "required": [
          "dataframes"
        ]
      },
      {
        "required": [
          "error"
        ]
      }
    ],
    "properties": {
      "dataframes": {
        "description": "Active dataframes for this tenant, newest first. Empty when none are registered.",
        "items": {
          "additionalProperties": false,
          "description": "Provenance and schema for one dataframe.",
          "properties": {
            "column_schema": {
              "description": "Resolved column schema.",
              "items": {
                "additionalProperties": false,
                "description": "One column declaration in the dataframe schema.",
                "properties": {
                  "name": {
                    "description": "Column name.",
                    "type": "string"
                  },
                  "nullable": {
                    "description": "Whether the column permits NULL (all Treasury columns are nullable).",
                    "type": "boolean"
                  },
                  "type": {
                    "description": "Canvas column type (VARCHAR, BIGINT, DOUBLE, ...). Treasury API values are VARCHAR.",
                    "type": "string"
                  }
                },
                "required": [
                  "name",
                  "type",
                  "nullable"
                ],
                "type": "object"
              },
              "type": "array"
            },
            "created_at": {
              "description": "ISO 8601 creation timestamp.",
              "type": "string"
            },
            "expires_at": {
              "description": "ISO 8601 expiry timestamp. Sliding TTL touched on every dataframe op.",
              "type": "string"
            },
            "max_rows": {
              "description": "Materialization cap that produced `truncated`, when applicable.",
              "type": "number"
            },
            "name": {
              "description": "Canvas table name (df_XXXXX_XXXXX).",
              "type": "string"
            },
            "query_params": {
              "additionalProperties": {},
              "description": "Input parameters the source tool was called with.",
              "propertyNames": {
                "type": "string"
              },
              "type": "object"
            },
            "row_count": {
              "description": "Rows materialized in the dataframe.",
              "type": "number"
            },
            "source_tool": {
              "description": "Treasury tool that produced this dataframe.",
              "type": "string"
            },
            "truncated": {
              "description": "True when the upstream source had more rows than were materialized.",
              "type": "boolean"
            }
          },
          "required": [
            "name",
            "source_tool",
            "query_params",
            "created_at",
            "expires_at",
            "row_count",
            "truncated",
            "column_schema"
          ],
          "type": "object"
        },
        "type": "array"
      },
      "error": {
        "additionalProperties": {},
        "description": "Present when the call failed. Absent on success.",
        "properties": {
          "code": {
            "description": "JSON-RPC error code for this failure.",
            "maximum": 9007199254740991,
            "minimum": -9007199254740991,
            "type": "integer"
          },
          "data": {
            "additionalProperties": {},
            "properties": {
              "reason": {
                "description": "Machine-readable failure mode. Declared by this tool: `canvas_unavailable`: CANVAS_PROVIDER_TYPE is not set to duckdb Other values are possible when a failure originates below the handler.",
                "examples": [
                  "canvas_unavailable"
                ],
                "type": "string"
              },
              "recovery": {
                "additionalProperties": {},
                "description": "Actionable next step for the caller.",
                "properties": {
                  "hint": {
                    "type": "string"
                  }
                },
                "required": [
                  "hint"
                ],
                "type": "object"
              },
              "retryable": {
                "description": "Whether retrying may succeed.",
                "type": "boolean"
              }
            },
            "type": "object"
          },
          "message": {
            "description": "Human-readable description of what went wrong.",
            "type": "string"
          }
        },
        "required": [
          "code",
          "message"
        ],
        "type": "object"
      }
    },
    "type": "object"
  },
  "title": "Describe Treasury Dataframes"
}
```