Run a bounded read-only SQL query against documented blockchain tables. Returns rows from a bounded read-only SQL query on supported blockchain tables, together with available result metadata. Use one Toolmu account and a shared prepaid balance across available Tools. Pay per use; no separate supplier subscription is required. The current execution ceiling for this Tool is 0.0288 Toolmu credits per call. This is a maximum, not the settled charge. Before execution, get the current Tool contract and check availability, the latest maximumCredits, your balance and budget. Supplier response credits_used, when present, describes supplier API credits and is not the Toolmu customer charge.
Up to 0.0288 credits / call
The final charge is based on confirmed usage. Unused reserved credits return to your available balance.
Surf
Blockchain Data API: Run Read-Only SQL Queries
Run a bounded read-only SQL query against documented blockchain tables. Returns rows from a bounded read-only SQL query on supported blockchain tables, together with available result metadata. Use one Toolmu account and a shared prepaid balance across available Tools. Pay per use; no separate supplier subscription is required. The current execution ceiling for this Tool is 0.0288 Toolmu credits per call. This is a maximum, not the settled charge. Before execution, get the current Tool contract and check availability, the latest maximumCredits, your balance and budget. Supplier response credits_used, when present, describes supplier API credits and is not the Toolmu customer charge.
You receive
Returns rows from a bounded read-only SQL query on supported blockchain tables, together with available result metadata. Synchronous SQL has a documented 30-second timeout. Restrict partitions and row counts; a timeout does not authorize automatically submitting another paid query.
Start with your task
Describe the blockchain information you want to find in everyday words. If you know them, add [coin], [network], or [time period]. I’ll check the available records and explain the results. You don’t need to write code or find a long address.
Inputs & outputs
Inspect the current inputs, availability, and maximum charge before starting.
Input schema
Input schema
Field / Path
Type
Requirement
Meaning
bodybody
object
Required
Required fields
sql
sqlbody.sql
string
Required
Read-only ClickHouse SELECT/WITH query. Discover tables with /onchain/schema. Rules (server-enforced or query-killing): SELECT/WITH only (read-only); table references must be database-qualified as agent.<table>; ALWAYS filter on block_date or block_number (partition key — without it the query times out); compare address columns directly against lowercase literals (wrapping the column in lower() is rejected); never filter on symbol columns (unindexed full scan, and symbol matches surface scam clones — resolve a ticker to a contract address with /search/token first); on transfer tables use separate UNION ALL branches instead of OR across from/to; use single quotes for strings, e.g. toDate('2026-04-07'). Example: SELECT block_date, sum(amount_usd) FROM agent.ethereum_dex_trades WHERE block_date >= today() - 7 GROUP BY block_date.
Minimum length
1
max_rowsbody.max_rows
integer
Optional
Maximum rows to return. Example: 100. Defaults to 1000 (server-side), capped at 10000.
Minimum
1
Maximum
10000
View raw JSON
{
"type": "object",
"required": [
"body"
],
"properties": {
"body": {
"type": "object",
"$schema": "https://json-schema.org/draft/2020-12/schema",
"required": [
"sql"
],
"~standard": {
"vendor": "zod",
"version": 1,
"jsonSchema": {}
},
"properties": {
"sql": {
"type": "string",
"minLength": 1,
"description": "Read-only ClickHouse SELECT/WITH query. Discover tables with /onchain/schema. Rules (server-enforced or query-killing): SELECT/WITH only (read-only); table references must be database-qualified as agent.<table>; ALWAYS filter on block_date or block_number (partition key — without it the query times out); compare address columns directly against lowercase literals (wrapping the column in lower() is rejected); never filter on symbol columns (unindexed full scan, and symbol matches surface scam clones — resolve a ticker to a contract address with /search/token first); on transfer tables use separate UNION ALL branches instead of OR across from/to; use single quotes for strings, e.g. toDate('2026-04-07'). Example: SELECT block_date, sum(amount_usd) FROM agent.ethereum_dex_trades WHERE block_date >= today() - 7 GROUP BY block_date."
},
"max_rows": {
"type": "integer",
"maximum": 10000,
"minimum": 1,
"description": "Maximum rows to return. Example: 100. Defaults to 1000 (server-side), capped at 10000."
}
},
"additionalProperties": false
}
},
"additionalProperties": false
}
Result schema
Output fields have not been documented yet.
Additional notes
Run a bounded read-only SQL query against documented blockchain tables
How to use this Tool
Use the deployed input fields below. Required fields must be supplied; optional filters narrow the result.
body.sql (Required): Read-only ClickHouse SELECT/WITH query. Discover tables with /onchain/schema. Rules (server-enforced or query-killing): SELECT/WITH only (read-only); table references must be database-qualified as agent.<table>; ALWAYS filter on block_date or block_number (partition key — without it the query times out); compare address columns directly against lowercase literals (wrapping the column in lower() is rejected); never filter on symbol columns (unindexed full scan, and symbol matches surface scam clones — resolve a ticker to a contract address with /search/token first); on transfer tables use separate UNION ALL branches instead of OR across from/to; use single quotes for strings, e.g. toDate('2026-04-07'). Example: SELECT block_date, sum(amount_usd) FROM agent.ethereum_dex_trades WHERE block_date >= today() - 7 GROUP BY block_date.
body.max_rows (Optional): Maximum rows to return. Example: 100. Defaults to 1000 (server-side), capped at 10000.
What this Tool returns
Returns rows from a bounded read-only SQL query on supported blockchain tables, together with available result metadata.
Response fields and how to read them
The table follows the official response contract, including nested fields and useful response metadata. [] denotes an array item. Required means required within its parent object, not that a conditional parent always exists. A nullable type permits null; an optional field can be absent. Use the documented conditions below to distinguish missing, empty and zero values. Units and reporting windows apply only where explicitly documented.
Field, type and presence
Meaning and conditions
meta.cached
boolean; Required within parent
Whether this response was served from cache
meta.credits_used
integer; Required within parent; format: int64
Credits deducted for this request
meta.empty_reason
string; Optional within parent
Hint explaining why the data array is empty, when applicable
meta.has_more
boolean; Optional within parent
Whether more items may exist beyond this response. For offset-paged endpoints, continue with a larger offset. For time-series endpoints without offset/cursor controls, true means the requested time range hit an upstream cap; narrow from/to to continue. Omitted when exhaustion cannot be proven.
meta.limit
integer; Required within parent; format: int64
Maximum number of items returned in this response
meta.offset
integer; Required within parent; format: int64
Number of items skipped (pagination offset)
meta.total
integer; Optional within parent; format: int64
Total number of matching items (before pagination). Omitted when total is unknown.
meta.watermark
integer; Optional within parent; format: int64
Warehouse watermark (Unix seconds) this response was computed at, on warehouse-backed endpoints (e.g. Hyperliquid /trades/aggregate) — rows up to this time come from the warehouse, newer rows from the live tail. Omitted elsewhere.
Coverage, units and freshness
Synchronous SQL has a documented 30-second timeout. Restrict partitions and row counts; a timeout does not authorize automatically submitting another paid query.
Inspect any returned observation time, cache status, watermark, pagination and errors using their documented meanings. A successful request alone does not establish complete coverage. Where no freshness or completeness guarantee is documented, treat it as unknown. Saved Examples are historical and viewing them does not refresh data or execute a new call.
Data source and references
Surf supplies this endpoint through its Data API. Response contract and deployed Tool inputs reviewed on 2026-10-03 against official OpenAPI v0.2.102. This is a contract review date, not a data observation time. Coverage depends on the selected endpoint and request.
Use one Toolmu account and a shared prepaid balance across available Tools. Pay per use; no separate supplier subscription is required. The current execution ceiling for this Tool is 0.0288 Toolmu credits per call. This is a maximum, not the settled charge. Before execution, get the current Tool contract and check availability, the latest maximumCredits, your balance and budget. Supplier response credits_used, when present, describes supplier API credits and is not the Toolmu customer charge.
Example request: [Show daily Ethereum trading volume for the last 7 days].
Describe the blockchain information you want to find in everyday words. If you know them, add [coin], [network], or [time period]. I’ll check the available records and explain the results. You don’t need to write code or find a long address.
Find the largest transfers
Example request: [Find the 10 largest USDC transfers on Ethereum in the last 7 days].
Questions about this tool.
Inputs, results and details to know before running it.
Describe the blockchain information you want to find. Add a coin, network, or time period if you know them. You do not need to write code or find a long address.
Returns rows from a bounded read-only SQL query on supported blockchain tables, together with available result metadata.
Synchronous SQL has a documented 30-second timeout. Restrict partitions and row counts; a timeout does not authorize automatically submitting another paid query.
Use one Toolmu account and a shared prepaid balance across available Tools. Pay per use; no separate supplier subscription is required. The current execution ceiling for this Tool is 0.0288 Toolmu credits per call. This is a maximum, not the settled charge. Before execution, get the current Tool contract and check availability, the latest maximumCredits, your balance and budget. Supplier response credits_used, when present, describes supplier API credits and is not the Toolmu customer charge.
Ask your agent to Run a bounded read-only SQL query against documented blockchain tables. Provide the required inputs above. If Toolmu is already connected, reuse that connection; otherwise use the setup instructions on this page. Before a paid execution, the agent must read the current Tool contract and check availability, the credit ceiling, balance, budget and your authorization. It should then execute the Tool and explain the returned fields and limitations.
Inspect any returned observation time, cache status, watermark, pagination and errors using their documented meanings. A successful request alone does not establish complete coverage. Where no freshness or completeness guarantee is documented, treat it as unknown. Saved Examples are historical and viewing them does not refresh data or execute a new call.
