{"uid":"cap_jxi-XDUqtS5PfyrxJKgsP","slug":"drillr-sql-query-runner-f48f302f","name":"Drillr SQL Query Runner","description":"Execute read-only SQL against drillr financial database (90+ tables)","url":"https://gateway.drillr.ai/api/x402/data/run_sql","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"sql":{"type":"string","description":"Read-only SELECT statement"}}},"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_OGyb7n5-oP9tKh8v5xytg","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":"Executes a read-only SELECT SQL query against Drillr's dataset and returns the query results.","exampleAgentPrompt":"Run this SQL query against Drillr's data for me: SELECT company_name, revenue FROM companies WHERE industry = 'technology' AND revenue > 1000000 ORDER BY revenue DESC LIMIT 20.","exampleUseCases":null,"resultDescription":"Returns the rows and columns resulting from the SELECT query executed against Drillr's dataset — typically structured tabular data including company records, trading signals, or related financial data matching the query criteria.","failureModes":["Invalid or non-SELECT SQL statement (write queries rejected as read-only only)","Malformed SQL syntax returns a parse error","Query references tables or columns that don't exist in Drillr's schema","Payment failure if USDC balance insufficient","Timeout for very large or complex queries","Network or gateway error returning 5xx"],"whenToPreferThis":"Use this endpoint when you need flexible, ad-hoc access to Drillr's underlying data via custom SQL — especially when the sibling search/list endpoints don't expose the specific filtering, joining, or aggregation logic you need. Ideal for analytical queries, data exploration, or building derived views from Drillr company or trading signal data.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-15T00:37:19.476Z","isFirstParty":false}