Preflight Blockchain SQL Query

surf.onchain.sql.preflightRaw endpoint · live

Validate and cost-estimate a ClickHouse SQL query (EXPLAIN ESTIMATE) without executing it.

Provider

Surfyour key

Runs on your own Surf key: add it under Provider keys in the app. Opentools doesn't charge for these runs.

Use it from your agent

Raw endpoints take the provider's own request: body, queryParams and pathParams, as the provider documents them. Agents find it with search_tools once Opentools is connected.

curl

curl https://opentools.opentools.workers.dev/v1/jobs \
  -H "Authorization: Bearer $OPENTOOLS_KEY" \
  -H "Content-Type: application/json" \
  -d '{"tool":"surf.onchain.sql.preflight","input":{"body":{}}}'

More from Surf

DEX Token OHLCV Pricesurf.dex.token.priceReturns DEX-pool-weighted OHLCV bars (timestamp, open, high, low, close, volume_usd) for a single token identified by chain + address.Exchange Historical Candlessurf.exchange.candlesReturns persisted OHLCV candles for a covered Bithumb, Upbit, HashKey, bitFlyer, Coinone, or Korbit spot market.Exchange Market Coveragesurf.exchange.coverageReturns covered spot markets on Bithumb, Upbit, HashKey, bitFlyer, Coinone, and Korbit with latest ticker metrics, candle availability, technical score, and data status.Exchange Order Book Depthsurf.exchange.depthReturns order book bid/ask levels with computed stats.Exchange Funding Rate Historysurf.exchange.funding-historyReturns historical funding rate records for a perpetual contract.Exchange OHLCV Candlestickssurf.exchange.klinesReturns OHLCV candlestick data with period summary stats (high, low, total volume).