# Drillr Get Table Schema

> Drillr Get Table Schema is a paid API for AI agents from gateway.drillr.ai, paid per call via x402, $0.01/call, status unknown (last checked 2026-09-14).

Returns column definitions (schema) for a named table in the Drillr financial database

## Facts

- Endpoint: POST https://gateway.drillr.ai/api/x402/data/get_table_schema
- Price: $0.01/call
- Payment: x402
- Status: unknown
- Last checked: 2026-09-14
- Activations on Zero: 0
- Tags: x402
- Canonical page: https://www.zero.xyz/c/drillr-get-table-schema-99590243
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_MW11eTYQ6rSzwBMrR_aOe

Status and success rate cover calls made through Zero and Zero's own probes. Third-party monitors may report differently.

## How to call it through Zero

Zero handles the 402 payment challenge and records the run. With the Zero CLI installed (`npm i -g @zeroxyz/cli`):

```sh
zero fetch --capability drillr-get-table-schema-99590243 -d '<json body>'
```

Example prompt: What columns and data types are available in the 'income_statement' table in the Drillr financial database?

## When to prefer this

Use this endpoint when you need to understand the structure of a specific Drillr financial table before writing SQL queries or exploring data. It is the right choice when you know the table name (e.g. from the list-tables endpoint) and need column-level details. Prefer this over the list-tables endpoint when you already know which table you want and need its internal field definitions.

## Known failure modes

- Table name not found — returns error if the table_name does not exist in the Drillr database
- Missing table_name parameter — request fails without the required input
- Payment failure — $0.01 USDC charge not fulfilled, request rejected
- Transient gateway error — upstream service unavailable

## How this service works

Get column definitions for a drillr data table

## Output

A structured description of all columns in the specified Drillr table, including field names and data types, enabling downstream SQL query construction or data exploration.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "table_name": {
   "type": "string"
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/drillr-get-table-schema-99590243/health.json
- [Zero catalog index](https://www.zero.xyz/llms.txt)
- [Other services from gateway.drillr.ai](https://www.zero.xyz/host/gateway.drillr.ai/llms.txt)