{"uid":"cap_VrOuehGnQQ9behQTPBXkb","slug":"onvexia-sql-schema-explorer-bb4348c1","name":"Onvexia SQL Schema Explorer","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/schema","method":"GET","headers":{},"bodySchema":{"type":"object","properties":{"properties":{"type":"string"}}},"responseSchema":{"type":"json","example":{"data":[],"meta":{"docs":"https://onvexia.com/openapi.json","endpoint":"/v1/sql/schema"}}},"example":null,"exampleRequest":null,"tags":["x402"],"displayCostAmount":"0.001","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.001/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.001","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_E2Xs8ikbCDupf3qNkL4Lg","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.001","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Returns the SQL schema definition for Onvexia's blockchain analytics database, enabling agents to discover available tables, columns, and data types before querying","exampleAgentPrompt":"Show me the full SQL schema for Onvexia's blockchain analytics database so I can see what tables and columns are available before I write a query about labelled addresses or asset supply history.","exampleUseCases":[{"title":"Pre-query schema discovery for crypto data","prompt":"Before I start querying Onvexia for token supply history, can you pull up the SQL schema so I know exactly which tables and column names to use?"},{"title":"Exploring labelled address data structure","prompt":"I want to look up labelled wallet addresses across multiple chains in Onvexia — first show me the database schema so I can see how the address labelling data is structured."},{"title":"Onboarding to Onvexia analytics API","prompt":"I'm new to Onvexia — can you fetch their SQL schema so I can understand what blockchain analytics data they have and how it's organized across their tables?"}],"resultDescription":"A JSON response containing an array of schema definitions (tables, columns, data types) for Onvexia's blockchain analytics SQL database, along with metadata including a link to the full OpenAPI documentation at onvexia.com/openapi.json and the endpoint path.","failureModes":["Empty data array returned if no schema is available or the service is initializing","402 Payment Required if the x402 micropayment of 0.001 USDC is not included","Invalid properties filter parameter may return empty or unfiltered results","Service unavailability returns no data with meta only"],"whenToPreferThis":"Use this endpoint when you need to introspect Onvexia's SQL database structure before constructing queries — especially when you are unfamiliar with available tables, column names, or data types. It is the natural first step before using Onvexia's SQL or GraphQL query endpoints for blockchain analytics on assets, labelled addresses, or supply history across supported chains.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-19T13:16:38.379Z","isFirstParty":false}