A powerful crypto intelligence skill providing AI agents with direct SQL access to curated DeFi metrics, stablecoin yields, and blockchain market analysis.
Install & Download
1. ClawHub CLI
The fastest way to install a skill directly from the registry.
npx clawhub@latest install pond3r-skill
2. Manual Installation
Copy the skill folder to one of these locations
~/.openclaw/skills/ <project>/skills/ Priority: Workspace > Local > Bundled
3. Prompt Installation
Copy this prompt to OpenClaw to install it automatically.
Help me install pond3r-skill using Clawhub. If Clawhub is not installed, install it first (npm i -g clawhub).
Prefer to download?
Get the raw skill files in a ZIP archive.
What is Pond3r Crypto Intelligence Skill?
The Pond3r Crypto Intelligence Skill empowers AI agents to query institutional-grade blockchain data through a Model Context Protocol (MCP) interface. It provides read-only SQL access to a vast repository of curated datasets including protocol metrics, stablecoin yields, and market trends.
By integrating this into Openclaw Skills, developers can build agents capable of performing complex financial analysis, tracking token opportunities, and monitoring cross-chain liquidity without leaving their coding environment. This skill bridges the gap between raw blockchain data and actionable intelligence, allowing for automated market research and risk-adjusted decision-making within any supported agent runtime.
Pond3r Crypto Intelligence Skill Use Cases
- Protocol Intelligence: Track AI agent launches, token graduations, and daily protocol metrics across DeFi platforms like Aave and Compound.
- Market Opportunity Detection: Identify new tokens on Uniswap with rising liquidity or monitor high-volume Polymarket trades.
- Risk-Adjusted Analysis: Monitor liquidation risks for DeFi positions and perform multi-dimensional risk scoring on market structures.
- Cross-Protocol Comparison: Compare USDC yields across different protocols and chains, such as comparing Arbitrum yields to Mainnet.
- Structured Decision Support: Perform statistical analysis and trend identification based on Farcaster sentiment and influencer activity.
How Pond3r Crypto Intelligence Skill Works
- Data Discovery: The agent uses the list_datasets tool to browse available blockchain datasets and table structures.
- Schema Inspection: The agent calls get_schema to understand specific column names, data types, and metric descriptions for the target dataset.
- Query Construction: Based on user intent, the agent generates a read-only SQL SELECT query following specific syntax rules (e.g., bare table names).
- Execution: The query is executed via the Pond3r MCP server or through local Node.js scripts in the Openclaw Skills environment.
- Synthesis: The agent parses the returned JSON data, applies filters or row limits, and presents a summarized analysis to the user.
Pond3r Crypto Intelligence Skill Setup
To enable crypto intelligence for your agent, follow these installation steps:
- Obtain API Key: Visit makeit.pond3r.xyz/api-keys to generate your credentials.
- Configure Environment: For Docker or Openclaw Skills deployments, add your key to the
.envfile:
POND3R_API_KEY=your_api_key_here
- Connect MCP (Claude Code):
claude mcp add pond3r-data \
--transport http \
https://mcp.pond3r.xyz/mcp \
--header "Authorization: Bearer <API_KEY>"
- Manual Script Usage: If native MCP is unavailable, use the provided CLI scripts:
node /opt/pond3r-skill-scripts/query.mjs --dataset-id <id> --sql "SELECT * FROM stablecoin_yields LIMIT 10"
Pond3r Crypto Intelligence Skill Data Schema & Taxonomy
The skill organizes crypto intelligence into several layers of metadata and tabular data:
| Component | Description |
|---|---|
| Datasets | Curated collections of data (e.g., yields, protocol metrics, market analysis). |
| Tables | Specific data structures within datasets like stablecoin_yields or polymarket_trades. |
| Schema | Metadata detailing column types (e.g., Float, String) and semantic descriptions for every field. |
| Results | JSON-formatted output from SQL queries, restricted to SELECT operations with a 10,000-row limit. |
Pond3r Crypto Intelligence Skill Advanced Features
- SQL-on-Chain: Direct read-only SQL access to complex blockchain datasets without needing to manage indexers or subgraphs.
- Multi-Runtime Flexibility: Native support for Cursor and Claude Desktop, with fallback Node.js scripts for headless Openclaw Skills integrations.
- Automated Reporting API: Access to the alternative Report API for scheduled delivery of executive summaries and market opportunities.
- Cost-Aware Querying: Built-in cost estimation that rejects queries exceeding tier limits before execution to prevent resource exhaustion.
- Cross-Chain Synthesis: Capability to join and compare metrics across different L1 and L2 ecosystems through unified SQL queries.
SKILL.md
Loading
Related Openclaw Skills
Openclast Wallet Agent Skill
A secure agent skill for managing crypto wallet operations, transaction approvals, and multi-chain balances.
ENS (Ethereum Name Service)
A comprehensive utility for resolving .eth names to Ethereum addresses and managing the lifecycle of ENS domains.
ERC-8004 Identity Skill
A specialized skill for minting and managing EIP-8004 compliant on-chain identities for AI agents on the Monad network.
Duffel Flights
A powerful flight management skill for searching, booking, and canceling flights across 300+ airlines using the Duffel API.
plsreadme
Instantly share markdown documents and text as clean, readable web links via plsreadme.com.
NotebookLM CLI Wrapper
A command-line interface wrapper for NotebookLM that enables automated AI research, source management, and artifact generation.
Featured*
