{"uid":"cap_MW11eTYQ6rSzwBMrR_aOe","slug":"drillr-get-table-schema-99590243","name":"Drillr Get Table Schema","description":"Get column definitions for a drillr data table","url":"https://gateway.drillr.ai/api/x402/data/get_table_schema","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"table_name":{"type":"string"}}},"responseSchema":null,"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.01","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"probe","requiresHandshake":false,"reviewCount":0,"rating":{"score":"0.00","successRate":"0.00","reviews":0,"stars":null,"state":"unrated"},"availabilityStatus":"unknown","priceObserved":null,"sessionDeposit":null,"pricing":{"kind":"static","summary":"$0.01/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.01","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_EDU5xC2dcAIteW7viElpB","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.01","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Returns column definitions (schema) for a named table in the Drillr financial database","exampleAgentPrompt":"What columns and data types are available in the 'income_statement' table in the Drillr financial database?","exampleUseCases":[{"title":"Explore table structure before querying","prompt":"Before I write a SQL query against the Drillr database, can you show me the column definitions for the 'balance_sheet' table so I know what fields are available?"},{"title":"Understand SEC filing table fields","prompt":"What columns does the 'sec_filings' table in Drillr have? I want to know the field names and types before I start filtering by company or date."},{"title":"Build dynamic query from schema","prompt":"Can you pull the schema for the 'trading_signals' table in Drillr so I can figure out which columns to include in my analysis query?"}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:33:19.649Z","isFirstParty":false}