query-onchain-data

Query decoded Base on-chain data via the CDP SQL API with x402.

1|1|Updated Mar 20, 2026

Search Tags:#authentication #queries #sql #blockchain #onchain #base #cdp-sql

Ready to run

npx skills add https://github.com/Shamrock2245/shamrock-trading-bot --skill query-onchain-data

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: query-onchain-data
Source: https://github.com/Shamrock2245/shamrock-trading-bot/tree/main/.agent/skills/coinbase-wallet/query-onchain-data
Command: npx skills add https://github.com/Shamrock2245/shamrock-trading-bot --skill query-onchain-data

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Query on-chain data from Base using the CDP SQL API via x402 to fetch decoded blocks, transactions, events, and related metadata in a structured, queryable format.

Core Features & Use Cases

CDP SQL access to decoded on-chain data (blocks, transactions, events, and balances) across Base networks.
Safe, indexed queries that promote performance and reduce full-table scans.
Use Case: Build dashboards or alerts by querying recent blocks, transfers, and events for a given address.

Quick Start

Authenticate your wallet and run a sample query against the Base CDP SQL endpoint using x402 to fetch on-chain data.

Frequently Asked Questions about query-onchain-data

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I query decoded Base on-chain data using SQL?▼

Query decoded Base on-chain data by executing SQL statements against the CDP SQL API via x402 to fetch blocks, transactions, events, and balances in a structured format.

Do I need wallet authentication to run CDP SQL queries on Base?▼

Yes, wallet authentication is required to run CDP SQL queries on Base. The skill enforces input validation and requires wallet auth status before fetching decoded on-chain data.

Can I retrieve decoded events and transactions for a specific Base address?▼

Yes, you can retrieve decoded events and transactions for a specific Base address by running safe, indexed queries against the CDP SQL API to support dashboards or alerts.

What is the best way to optimize on-chain SQL queries for Base network performance?▼

To optimize on-chain SQL queries for Base network performance, use safe indexed queries that target indexed fields to promote performance and reduce full-table scans.

What are the limitations when querying Base blockchain data with CDP SQL?▼

Limitations when querying Base blockchain data with CDP SQL include avoiding full-table scans by using indexed fields, and ensuring wallet authentication and safe input handling prerequisites are met.