Skip to main content
Flipside’s data warehouse contains thousands of tables across 20+ blockchains. The MCP provides tools to help you find exactly what you need.

​
How It Works

Instead of memorizing table names, describe what you’re looking for:
You: I need data about NFT sales on Ethereum Claude: Let me find relevant tables… [uses find_tables] Found these tables:
  • ethereum.nft.ez_nft_sales - Aggregated NFT sales data
  • ethereum.nft.ez_nft_transfers - NFT transfer events
  • ethereum.core.ez_token_transfers - All token transfers

​
Available Tools

​
find_tables

Semantic search to find tables based on a natural language question. 
Tool: find_tables
Parameters:
  - question: What you're looking for (e.g., "DeFi lending on Arbitrum")
  - limit: Max tables to return
Example questions:
  • “DEX swaps on Ethereum”
  • “Staking data for Solana”
  • “Bridge transactions to Arbitrum”
  • “NFT marketplace activity”
  • “Token prices and market data”

​
find_tables_by_name

Find tables by name pattern using regex matching. 
Tool: find_tables_by_name
Parameters:
  - tableName: Pattern to match (supports regex)
  - limit: Max tables to return
Example patterns:
  • ez_dex - Tables containing “ez_dex”
  • ethereum.*fact_ - Ethereum fact tables
  • .*lending.* - Any lending-related tables
  • solana.defi - Solana DeFi tables

​
get_table_schema

Get detailed schema information for a specific table. 
Tool: get_table_schema
Parameters:
  - tableName: Full table name (e.g., "ethereum.defi.ez_dex_swaps")
Returns:
  • Column names and data types
  • Column descriptions
  • Table metadata

​
Table Naming Conventions

Flipside uses consistent naming patterns:

​
Schema Structure

{blockchain}.{category}.{table_name}
Examples:
  • ethereum.core.fact_transactions
  • solana.defi.ez_dex_swaps
  • arbitrum.nft.ez_nft_sales

​
Table Prefixes

PrefixDescription
fact_Raw event/transaction data
dim_Dimension/reference tables
ez_Curated, easy-to-use tables

​
Common Categories

CategoryContains
coreBlocks, transactions, transfers
defiDEX, lending, staking data
nftNFT sales, transfers, metadata
priceToken prices and market data
govGovernance and voting
statsAggregated metrics

​
Example Workflows

​
Finding DEX Data

You: What tables have Uniswap data? Claude: [uses find_tables with “Uniswap swaps”] Found:
  • ethereum.defi.ez_dex_swaps - All DEX swaps including Uniswap
  • ethereum.uniswap.ez_swaps - Uniswap-specific swap data

​
Exploring a New Chain

You: What data do you have for Base? Claude: [uses find_tables_by_name with “base.”]* Base has tables for:
  • Core transactions and blocks
  • DEX trading activity
  • NFT transfers and sales
  • Bridge transactions

​
Understanding Table Structure

You: What columns are in the DEX swaps table? Claude: [uses get_table_schema] ethereum.defi.ez_dex_swaps columns:
  • block_timestamp - When the swap occurred
  • tx_hash - Transaction hash
  • origin_from_address - Wallet that initiated
  • token_in / token_out - Tokens swapped
  • amount_in_usd / amount_out_usd - USD values

​
Tips

​
Start Broad, Then Narrow

  1. Use find_tables with a general question
  2. Review the results
  3. Use get_table_schema on promising tables
  4. Ask Claude to query the best match

​
Use “ez_” Tables First

The ez_ (easy) tables are curated and enriched:
  • Pre-joined with useful data
  • Human-readable labels
  • USD values calculated
  • Cleaned and validated

​
Ask About Data Coverage

“What date range does ethereum.defi.ez_dex_swaps cover?” “How often is the solana.core.fact_transactions table updated?”