{"uid":"cap_xIR4QUcLZjqOGnKp9fLTz","slug":"onvexia-sql-query-blockchain-analytics-5914cddf","name":"Onvexia SQL Query — Blockchain Analytics","description":"Thousands of assets across ten chains, half a million analysed documents, labelled addresses and supply-age history reaching back to 2008 — fused into one reading per asset. REST, SQL, GraphQL and MCP.","url":"https://onvexia.com/v1/sql","method":"POST","headers":{},"bodySchema":{"type":"object","properties":{"properties":{"type":"string"}}},"responseSchema":{"type":"json","example":{"data":[],"meta":{"docs":"https://onvexia.com/openapi.json","endpoint":"/v1/sql"}}},"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_VEjbczM5rYridb0cnXGNX","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":"Execute SQL queries against Onvexia's blockchain analytics database covering thousands of assets, labelled addresses, and half a million analysed documents across ten chains.","exampleAgentPrompt":"Run a SQL query against Onvexia's blockchain database to show me the labelled addresses and supply history for Ethereum from 2015 onward — give me the chain, address labels, and token age data.","exampleUseCases":[{"title":"Whale address label lookup","prompt":"Query Onvexia to find all labelled addresses holding more than 1000 BTC on the Bitcoin chain and tell me what entity labels are associated with them."},{"title":"Token supply history audit","prompt":"Use Onvexia's SQL endpoint to pull the full supply and age history for USDC across all supported chains going back as far as records exist — I need year-by-year figures."},{"title":"Cross-chain asset analytics comparison","prompt":"I want to compare on-chain metrics for SOL and AVAX across all ten chains Onvexia covers — run a SQL query that gives me their document analysis counts, labelled address counts, and latest supply figures side by side."}],"resultDescription":"A JSON object with a 'data' array containing query result rows and a 'meta' object with documentation and endpoint references. Results reflect Onvexia's proprietary fusion of on-chain data, labelled addresses, supply-age history from 2008, and half a million analysed documents across ten blockchains.","failureModes":["Invalid or malformed SQL query returns an error response with no data rows","Querying unsupported chains or assets returns empty data array","Exceeding rate limits or quota returns a payment or 402 error","Schema mismatch in the properties input field causes a 400-level error","Network or service downtime returns a 5xx error"],"whenToPreferThis":"Choose this endpoint when you need flexible, ad-hoc SQL-based querying over deep blockchain analytics data — especially when you need labelled addresses, historical supply data dating to 2008, or cross-chain asset analytics fused from document analysis. Prefer it over REST or GraphQL siblings when your query logic is complex, multi-dimensional, or requires aggregation across assets, chains, or time periods.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-19T13:15:38.244Z","isFirstParty":false}