coinbase avatar

Query Onchain Data

This lets you run SQL queries against onchain data on Base (blocks, transactions, decoded events) and pay per query using x402 micropayments. It's built on Coinbase's CDP SQL API and uses CoinbaseQL, a ClickHouse dialect. The main thing to know is that queries against the events table must filter on indexed fields (event_signature, contract address, or block_timestamp) or you'll hit performance walls. The skill handles wallet status checks and constructs the npx awal commands with proper escaping to avoid shell injection. Useful when you need to pull Transfer events, analyze contract activity, or grab transaction history without running your own node. The micropayment model means you pay only for what you query, though you need the authenticate-wallet skill set up first.

skills.sh installs
2.1K
GitHub stars
128
last updated
Aug 21, 2026

Install

$ npx -y skills add coinbase/agentic-wallet-skills --skill query-onchain-data --agent claude-code

Installs into .claude/skills of the current project.

Files

This lets you run SQL queries against onchain data on Base (blocks, transactions, decoded events) and pay per query using x402 micropayments. It's built on Coinbase's CDP SQL API and uses CoinbaseQL, a ClickHouse dialect. The main thing to know is that queries against the events table must filter on indexed fields (event_signature, contract address, or block_timestamp) or you'll hit performance walls. The skill handles wallet status checks and constructs the npx awal commands with proper escaping to avoid shell injection. Useful when you need to pull Transfer events, analyze contract activity, or grab transaction history without running your own node. The micropayment model means you pay only for what you query, though you need the authenticate-wallet skill set up first.

Browse the repository on GitHub

Sponsors

Details

Repository
github.com/coinbase/agentic-wallet-skills
Categories
Backend & APIs, AI & Agent Building, Finance & Trading, Databases, Web3 & Blockchain

More from coinbase/agentic-wallet-skills

All 10
1jezweb avatargoogle-apps-scriptjezweb/claude-skillsBuild Google Apps Script automation for Sheets and Workspace. Custom menus, triggers (onEdit / time-driven / form submit), dialogs, sidebars, email batches, PDF2Kskills.sh installs
2nvidia avatarphysical-ai-infrastructure-setup-and-resilient-scalingnvidia/skillsUse when the user wants to set up, scale, validate, or harden NVIDIA physical AI infrastructure for synthetic data generation workflows across local MicroK8s or2Kskills.sh installs
3alirezarezvani avatarengineering-advanced-skillsalirezarezvani/claude-skillsIndex of 37 advanced engineering agent skills for Claude Code, Codex, Gemini CLI, Cursor, OpenClaw. Use when browsing or choosing among the POWERFUL-tier engine2Kskills.sh installs
4neondatabase avatarpostgres-best-practicesneondatabase/postgres-skillsBest practices and guidelines for working with Postgres. Covers schema design, indexing strategies, query optimization, migrations, and common pitfalls. Use whe2Kskills.sh installs
5payloadcms avatarcms-migrationpayloadcms/skillsUse when user wants to migrate content from another CMS (WordPress, Contentful, Strapi, Sanity, Webflow, etc.) to Payload CMS2Kskills.sh installs
6apollographql avatarskill-creatorapollographql/skillsGuide for creating effective skills for Apollo GraphQL and GraphQL development. Use this skill when: (1) users want to create a new skill, (2) users want to upd2Kskills.sh installs