Skip to main content
The Flipside CLI enables you to query blockchain data, interact with AI agents, and manage analytics workflows directly from your terminal. Access blockchain data across 20+ chains.

​
Why Use the CLI?

AI-Powered Analysis

Ask questions in natural language and let AI agents write SQL, analyze data, and generate insights for you

20+ Blockchains

Query data across Ethereum, Solana, Bitcoin, Arbitrum, Base, and more from a single interface

Automate Workflows

Build automated pipelines that run on schedule, process data, and deliver reports

Extend with Custom Agents

Create and deploy your own AI agents with custom skills tailored to your analysis needs

​
Get Started

Installation Guide

Install the CLI, authenticate, and run your first query

​
Key Capabilities

Agents

Run AI-powered agents or create custom ones for specialized analysis

Skills

Package domain knowledge and tools for agents to use

SQL Queries

Execute and manage queries against 7+ trillion data points

Interactive Chat

Conversational AI for exploring blockchain data

Automations

DAG-based pipelines for scheduled data processing

Data Uploads

Upload CSV files to join with on-chain data

​
Core Commands

​
Interactive Chat

Start a conversational session with AI agents for natural language querying: 
flipside chat
You can also send a single message: 
flipside chat send-message "What were the top 10 NFT collections by volume yesterday?"

​
SQL Queries

Execute and manage SQL queries: 
# Create and run a query
flipside query create "SELECT * FROM ethereum.core.fact_transactions LIMIT 100"

# List saved queries
flipside query list

# Execute an existing query
flipside query execute <query-id>

​
Agents

Run pre-built agents or create your own: 
# List available agents
flipside agents list

# Run an agent with a message
flipside agents run flipside/sql_agent --message "Show me the top DEXes by volume on Ethereum"

# Initialize a new custom agent
flipside agents init my-agent

​
Skills

Skills provide domain knowledge and tools to agents: 
# List available skills
flipside skills list

# Create a new skill
flipside skills init my-skill

# Deploy a skill
flipside skills push my-skill.yaml

​
Data Uploads

Upload CSV files to join with blockchain data: 
# Upload a CSV file
flipside uploads upload wallets.csv

# List uploads
flipside uploads list
Reference uploads in SQL using the ${upload:filename} syntax: 
SELECT w.label, b.balance
FROM ${upload:wallets.csv} w
JOIN ethereum.core.fact_balances b ON w.address = b.address

​
Command Reference

CommandDescription
flipside loginAuthenticate with your Flipside account
flipside logoutClear stored authentication
flipside whoamiDisplay current user and organization info
flipside chatStart an interactive chat session
flipside queryCreate, list, and execute SQL queries
flipside query-runManage query execution runs
flipside agentsManage and run AI agents
flipside skillsManage skills for agents
flipside uploadsUpload and manage CSV files
flipside automationsManage automated workflows
flipside quickstartSet up example agents and skills
flipside configManage CLI configuration
flipside updateUpdate CLI to the latest version

​
Global Flags

These flags work with any command:
FlagDescription
-j, --jsonOutput results as JSON
-v, --verboseShow detailed request/response information
-e, --envEnvironment selection (local, staging, prod)
-h, --helpShow help for any command

​
AI Assistant Integration

Integrate Flipside directly into your AI-powered development environment:

Claude Code

Connect via MCP for seamless blockchain data access

Cursor

Use the MCP integration with Cursor IDE
Copy the integration files into your project:
  • CLAUDE.md for Claude Code
  • AGENTS.md for Cursor and similar tools

​
Resources

GitHub Repository

Source code, issues, and releases

API Reference

Full API documentation