{"uid":"cap_kbshI0GkZWU1HDrpAYKWL","slug":"blockrun-ai-3e498368","name":"BlockRun.AI On-Chain ClickHouse Schema Introspection","description":"Pay for the outcome. One endpoint for every model, tool and data source an agent needs — each call priced before it runs, at the best value per dollar. 103 models and 100 data and tool APIs.","url":"https://blockrun.ai/api/v1/surf/onchain/schema","method":"GET","headers":{},"bodySchema":null,"responseSchema":null,"example":{"request":{"input":{"body":{}}},"response":{"_truncated":true,"_originalSize":56143}},"exampleRequest":{"input":{"body":{}}},"tags":["x402"],"displayCostAmount":"0.02","displayCostAsset":"USDC","priceDynamic":false,"priceHint":null,"priceStatus":"priced","priceSource":"settled","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.02/call","primary":{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.0085","per":"call","confidence":"exact"},"accepted":[{"kind":"static","protocol":"x402","network":"base","amountUsd":"0.0085","per":"call","confidence":"exact"}]},"paymentMethods":[{"uid":"pm_tVuqkaiAxWvCsdwibJT8f","protocol":"x402","methodType":"crypto","chain":"base","mode":"charge","costAmount":"0.0085","costPer":"request","priority":0,"asset":"0x833589fCD6eDb6E08f4c7C32D4f71b54bdA02913","unit":"request","depositMicros":null,"planRef":null}],"brandName":null,"brandSlug":null,"brandBaseUrl":null,"brandDocsUrl":null,"whatItDoes":"Returns the ClickHouse table schema for on-chain blockchain data, enabling structured query planning and data exploration.","exampleAgentPrompt":"Show me the ClickHouse table schema for BlockRun's on-chain data so I can understand what columns and data types are available to query.","exampleUseCases":[{"title":"Build dynamic blockchain query builder","prompt":"I need to create a tool that auto-generates SQL queries for on-chain data analysis. Can you fetch the ClickHouse schema so I know what tables and columns to work with?"},{"title":"Audit available blockchain data fields","prompt":"Help me explore what blockchain data BlockRun has available—I want to see the full table structure and column types so we can determine what analytics we can actually run."},{"title":"Debug failed data pipeline queries","prompt":"Our data pipeline is failing because we're querying columns that might not exist. Can you pull the current on-chain ClickHouse schema so I can verify our query matches the actual database structure?"}],"resultDescription":"Returns a structured description of the ClickHouse table schema for on-chain blockchain data, including table names, column names, and data types that can be used to plan SQL queries against the database.","failureModes":["Schema unavailable if underlying ClickHouse cluster is unreachable — returns 500 or timeout","Authentication/payment failure via x402 protocol if USDC balance is insufficient — returns 402","Rate limiting if too many schema requests are made in quick succession — returns 429"],"whenToPreferThis":"Use this endpoint when you need to understand the structure of BlockRun's on-chain ClickHouse database before constructing queries — essential for query planning, data pipeline design, or exploring what blockchain data fields are available. Prefer over manual documentation lookups when building dynamic query generation or schema-aware data agents.","instructions":null,"reviewSummary":null,"reviewSummaryHighlights":null,"reviewSummaryConcerns":null,"reviewSummaryGeneratedAt":null,"activationCount":0,"lastUsedAt":null,"lastSuccessfullyRanAt":null,"lastHealthCheckAt":"2026-09-13T13:03:33.047Z","isFirstParty":false}