{"uid":"cap_8hcbwIzyj1xQOiR53malF","slug":"drillr-list-data-tables-95cec07b","name":"Drillr List Data Tables","description":"List all available drillr data tables","url":"https://gateway.drillr.ai/api/x402/data/list_tables","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"categories":{"type":"array","items":{"type":"string"},"maxItems":5,"minItems":1}}},"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_3ZSuguBkgvu1DokrewWFl","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 a list of all available data tables in the Drillr financial database, optionally filtered by category","exampleAgentPrompt":"Can you show me all the available Drillr financial data tables in the earnings and fundamentals categories so I know what I can query?","exampleUseCases":[{"title":"Exploring financial database schema","prompt":"What tables does Drillr have available for company fundamentals and earnings data? I want to know what I can query before writing any SQL."},{"title":"Filtering tables by market data category","prompt":"Show me all the Drillr tables related to price and trading data — I want to see what market data categories are available before I start building queries."},{"title":"Discovering SEC filing tables","prompt":"What Drillr data tables are available in the filings or SEC categories? I'm trying to figure out which tables to use for pulling 10-K and 10-Q data."}],"resultDescription":"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.","failureModes":["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"],"whenToPreferThis":"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.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-14T00:38:51.763Z","isFirstParty":false}