Blockchain SQL query

POST/gateway/v1/onchain/sql

curl -X POST https://api.orthogonal.com/v1/run \
-H 'Authorization: Bearer orth_live_••••' \
-H 'Content-Type: application/json' \
-d '{
"api": "surf",
"path": "/gateway/v1/onchain/sql",
"method": "POST",
"body": {
"max_rows": ,
"sql": ""
}
}'
{
"success": true,
"data": {
"data": [ 1 item ],
"meta": { … },
"$schema": "https://api.asksurf.ai/schemas/DataResponseOnchainRow.json"
}
}
A real response, recorded when Orthogonal checked this endpoint.

$0.02616per call

Every call costs the same.

You aren't charged for failed calls. A wallet payment for a failed call is refunded.

About this endpoint

Blockchain SQL Query: Run a raw ClickHouse SELECT query against blockchain data. All tables live in the agent database. Discover tables and columns first with GET /v1/onchain/schema. Send a JSON object, not raw SQL text. Example: {"sql":"SELECT ...","max_rows":1000}. Execution modes - The default response is synchronous and has a 30s timeout. - For queries that may exceed that window, send Prefer: respond-async. The same request is accepted as a durable job with 202 Accepted and Preference-Applied: respond-async. - Send a stable Idempotency-Key with respond-async so equivalent client retries reuse the retained job. - A synchronous timeout is non-retryable and returns recommended_action: use_async_job plus the async job URL. Do not resubmit the synchronous request automatically. - Synchronous and asynchronous ClickHouse executions share one cluster-wide per-owner concurrency budget. Accepted async jobs remain queued while that owner's execution slots are occupie

Body parameters

Response types

More from Surf API

  1. KOL rankingGET/gateway/v1/smart-money/kol/ranking$0.01308 per callFixed
  2. Liquidation chartGET/gateway/v1/market/liquidation/chart$0.01308 per callFixed
  3. KOL call historyGET/gateway/v1/smart-money/kol/history$0.01308 per callFixed
  4. Order book depthGET/gateway/v1/exchange/depth$0.00654 per callFixed
  5. Latest company financialsGET/gateway/v1/equity/latest-financialsUp to $0.03924 per callResponse-based
  6. Web page fetchGET/gateway/v1/web/fetch$0.00654 per callFixed
  7. Matched market pairsGET/gateway/v1/prediction-market/matching/pairs$0.02616 per callFixed
  8. Polymarket wallet positionsGET/gateway/v1/prediction-market/polymarket/positions$0.02616 per callFixed
  9. Hyperliquid trader leaderboardGET/gateway/v1/hyperliquid/leaderboard$0.02616 per callFixed
  10. Perpetual contract snapshotGET/gateway/v1/exchange/perp$0.00654 per callFixed
  11. KOL activityGET/gateway/v1/smart-money/kol/activity$0.01308 per callFixed
  12. Token DEX tradesGET/gateway/v1/token/dex-trades$0.02616 per callFixed
All 145 Surf API endpoints