Skip to main content
These examples show how the assistant chains multiple tools together to answer complex questions. Each demonstrates a realistic workflow from question to final result.

​
From question to dashboard

A single question that triggers schema discovery, SQL, execution, visualization, and sharing.
1

Ask the question

Show me stablecoin market share by issuer over the last 90 days,
and create a dashboard I can share.
2

Schema search

The assistant searches for relevant tables and finds crosschain.dex.trades. It checks documentation for best practices on stablecoin analysis.
3

SQL generation and validation

SELECT
    DATE(block_timestamp) AS date,
    CASE
        WHEN symbol IN ('USDT', 'USDT.e') THEN 'Tether'
        WHEN symbol IN ('USDC', 'USDC.e') THEN 'Circle'
        WHEN symbol = 'DAI' THEN 'MakerDAO'
        WHEN symbol = 'BUSD' THEN 'Paxos'
        ELSE 'Other'
    END AS issuer,
    SUM(usd_amount) AS daily_volume
FROM crosschain.dex.trades
WHERE block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '90 days'
    AND symbol IN ('USDT', 'USDT.e', 'USDC', 'USDC.e', 'DAI', 'BUSD', 'FDUSD', 'TUSD')
GROUP BY date, issuer
ORDER BY date DESC;
The assistant validates this with EXPLAIN before asking you to confirm execution.
4

Dashboard creation

After execution, the assistant:
  • Creates a dashboard with an area chart showing stablecoin volume share over time
  • Adds a summary table with total volume by issuer
  • Makes the dashboard public and returns a share link
5

Result

Here’s your stablecoin market share dashboard for the last 90 days. Tether leads with 62% of volume, followed by Circle at 28%. Dashboard: app.allium.so/s2/abc123 Want me to share a summary on X?

​
Real-time portfolio analysis

Using real-time APIs (no SQL) to analyze a wallet’s holdings.
1

Ask the question

What tokens does vitalik.eth hold? Give me a full breakdown with current values.
2

Address resolution

The assistant resolves vitalik.eth to 0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045 and looks up the address label to confirm it’s Vitalik Buterin’s wallet.
3

Balance lookup

Calls the real-time wallet balances API to get current token holdings across chains - no SQL query needed.
4

Price enrichment

Fetches current token prices for all held tokens to calculate USD values and portfolio allocation.
5

Result

Vitalik Buterin’s Portfolio (Ethereum)
TokenBalanceUSD Value% of Portfolio
ETH1,234$3.2M45.2%
USDC890,000$890K12.6%
…………
Total value: ~$7.1M across 24 tokens Want me to check balances on other chains too?

​
Cross-chain comparison

Multi-chain analysis using SQL with schema discovery.
1

Ask the question

Compare average gas costs across L2s this month.
Show me which L2 is cheapest for a simple transfer.
2

Schema discovery

The assistant searches for gas-related schemas across multiple chains. It finds <chain>.raw.transactions tables and documentation on gas calculation differences between L2s.
3

Cross-chain SQL

Writes a UNION ALL query across multiple L2 chains (Arbitrum, Optimism, Base, Polygon zkEVM, etc.), calculating average gas cost in USD per simple transfer.
4

Result

Average gas cost per transfer (this month)
L2Avg Gas CostMedian95th Percentile
Base$0.001$0.0008$0.003
Arbitrum$0.003$0.002$0.01
Optimism$0.004$0.003$0.012
…………
Base is currently the cheapest for simple transfers at ~$0.001 avg. Want me to create a dashboard tracking this over time?

​
Building on previous context

A multi-turn conversation showing how the assistant builds on earlier work.
1

Turn 1: Initial question

How many daily active wallets does Uniswap have on Ethereum?
The assistant finds ethereum.dex.trades, writes SQL filtering for Uniswap, and returns daily active wallet counts.
2

Turn 2: Refine

Break that down by Uniswap version (v2 vs v3)
The assistant modifies the previous query to add a version breakdown - no need to re-explain the context.
3

Turn 3: Expand scope

Add Sushiswap and Curve for comparison
Expands the query to include multiple DEXes, adjusting the WHERE clause and grouping.
4

Turn 4: Visualize

Create a dashboard with this data
Creates a dashboard with:
  • Line chart of daily active wallets by DEX over time
  • Stacked bar chart showing version breakdown for Uniswap
5

Turn 5: Share

Make it public and share on X
Makes the dashboard public, generates a tweet with key insights and the dashboard link, and returns the X intent URL for you to review and post.