# Drillr List Data Tables

> Drillr List Data Tables 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 a list of all available data tables in the Drillr financial database, optionally filtered by category

## Facts

- Endpoint: POST https://gateway.drillr.ai/api/x402/data/list_tables
- 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-list-data-tables-95cec07b
- Structured record (JSON): https://api.zero.xyz/v1/capabilities/cap_8hcbwIzyj1xQOiR53malF

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-list-data-tables-95cec07b -d '<json body>'
```

Example prompt: Can you show me all the available Drillr financial data tables in the earnings and fundamentals categories so I know what I can query?

## When to prefer this

Use this endpoint as a discovery step before executing SQL queries or requesting column definitions against the Drillr financial database. It is the right starting point when an agent does not know which tables exist or wants to scope its queries to specific categories. Prefer this over guessing table names before calling the SQL execution or column definition endpoints.

## Known failure modes

- Empty or invalid categories array returns an error or empty result
- Requesting more than 5 categories in a single call exceeds the maxItems limit
- Providing fewer than 1 category in the array violates the minItems constraint
- Unknown category strings may return empty results with no matching tables
- Network or payment failure (x402 protocol) results in no response

## How this service works

List all available drillr data tables

## Output

A list of available Drillr data table names along with metadata such as category tags, enabling the agent to know which tables exist before constructing SQL queries or column-level lookups against the 90+ table financial database.

## Request schema (JSON Schema)

```json
{
 "type": "object",
 "properties": {
  "categories": {
   "type": "array",
   "items": {
    "type": "string"
   },
   "maxItems": 5,
   "minItems": 1
  }
 }
}
```

## More

- Live health (JSON, refreshed every minute): https://www.zero.xyz/c/drillr-list-data-tables-95cec07b/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)