Financial data is informational and may be inaccurate. See Disclaimer.

drillr.ai
API keys →

Datasets

TOOLget_table_schema

One table’s columns and types, with its usage note — required filters, coverage, gotchas. Read it before writing SQL.

Coverage
US / CN / JP
Billing
Free · 0

Input parameters

ParameterTypeRequiredDescription
table_namestringrequiredOne name from the catalog. The tool’s input schema enumerates every legal value; list_tables shows the alt-data ones.

Example

Arguments
{ "table_name": "company_snapshot" }
Response
Table: company_snapshot
IMPORTANT: Use `FROM company_snapshot` in your SQL query.

Real-time, one row per company. Pre-computed metrics ONLY — ratios, percentages,
per-share figures, growth rates — NOT raw statement line items. For raw statements
use financial_statements; for qualitative company discovery use company_search.

column_name | data_type
--- | ---
ticker | text
company_name | text
sector | text
market_capitalization | double precision
pe_ratio_ttm | double precision
revenue_growth_ttm | double precision
market | text

Trimmed: Seven of about 170 columns shown, and the table’s coverage paragraph cut.

Limits

LimitValuePast it
Tables per call1
ColumnsAll, never cut
Column descriptionsAlt-data tables onlyCore tables carry a usage note instead

Errors

Invalid arguments are refused before the tool runs; the rest arrive as a tool failure whose text is the message. The four shapes are on MCP server.

WhenYou getDo
Name not in catalogInvalid arguments, accepted names listedPick one from the list
Catalog name missing on the database"Table '<name>' does not exist in the public data surface."Use list_tables to see what is live

Notes

  • The note at the top is the table’s contract: which filters are mandatory, which markets it reaches, which sibling tool answers the question better. An empty result from a table whose note says "US only" is not a finding.
  • Ticker form is the market: US bare (AAPL), A-shares .SH / .SZ (600519.SH), Japan .T (6758.T).

Endpoint, client setup and billing are common to all tools. For details, please refer to MCP server.