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
| Parameter | Type | Required | Description |
|---|---|---|---|
| table_name | string | required | One 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 | textTrimmed: Seven of about 170 columns shown, and the table’s coverage paragraph cut.
Limits
| Limit | Value | Past it |
|---|---|---|
| Tables per call | 1 | — |
| Columns | All, never cut | — |
| Column descriptions | Alt-data tables only | Core 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.
| When | You get | Do |
|---|---|---|
| Name not in catalog | Invalid arguments, accepted names listed | Pick 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.