skills.rest
Shamrock2245
Shamrock2245COMMUNITY
Explore all skills by this author →
WebsiteGitHub

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
One-click install
npx skills add https://github.com/Shamrock2245/shamrock-trading-bot --skill query-onchain-data
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
Tsin418Tsin418

query-onchain-data

Query decoded Base on-chain events, transactions, and blocks via the CDP SQL API.

Community
Intermediate
Pieverse-EngPieverse-Eng

morph-explorer

Query Morph L2 on-chain data via the Blockscout explorer API.

Official
Intermediate
borgheiborghei
467

data-analyst

Query SQL databases, create visualizations, and generate insights reports.

Community
Intermediate
ovachieverovachiever
52

gget

Query genomic data across multiple databases via CLI and Python interfaces.

Community
Advanced