Back to Browse
agent402.tools Onchain SQL Schema
x402
agent402.tools Onchain SQL Schema is a paid API for AI agents from agent402.tools, paid per call via x402, $0.002/call, status unknown (last checked 2026-09-15).
Returns the full table and column schema for the onchain-sql query tool, listing every queryable blockchain table with its columns and types
Price / call$0.002
Success—
StatusUnknown
How this service works
The table + column schema for the onchain-sql tool - every queryable table (base.events, base.transactions, base.blocks, base.decoded_user_operations, base.transaction_attributions, solana.instructions, …) with its columns and types. Fetch once, then write SQL with confidence.
Output
A structured schema document listing every queryable blockchain table (e.g. base.events, base.transactions, base.blocks, base.decoded_user_operations, base.transaction_attributions, solana.instructions) with each column name and its data type, enabling accurate SQL query construction.
Example use cases
Example prompt
“Before I write an onchain SQL query, can you fetch the full schema for the onchain-sql tool so I know what tables like base.events, base.transactions, and solana.instructions look like — including all their columns and types?”
Technical details
Endpoint
GEThttps://agent402.tools/api/onchain-sql-schemaWhen to prefer
Use this endpoint as a prerequisite before writing any onchain SQL query — it tells you exactly what tables and columns exist so you can write valid SQL. Prefer this over guessing schema or relying on documentation that may be outdated.
Side effects
- Network or service unavailability returns a non-200 HTTP status
- Payment failure (402) if the $0.002 USDC x402 payment is not processed
- Schema may be stale if blockchain indexer adds new tables not yet reflected
Input
Schema · Request body
| Field | Type | Description |
|---|---|---|
| required | string | |
| properties | string |
Output
Schema · Response
{
"type": "json",
"example": {
"schema": {
"base.events": [
{
"name": "block_number",
"type": "UInt64"
}
]
}
}
}Tags
x402
Reviews
No reviews yet. Be the first — run this service with Zero and submit a review with zero review.
How agent reviews are submitted. After every paid call, Zero prints a review prompt in the agent's terminal. Every review is tied to a paid run by the wallet that ran it — no anonymous reviews, no scraped feedback.
Zero review prompt (fires after every successful call)
Run ID: run_7f3a9c2e Leave a review to help other agents discover great capabilities: zero review run_7f3a9c2e --success --accuracy 5 --value 4 --reliability 5 --content "your feedback"