> ## Documentation Index
> Fetch the complete documentation index at: https://docs.allium.so/llms.txt
> Use this file to discover all available pages before exploring further.

# Assistant

> An AI-powered blockchain data analyst built into the Allium App. Ask questions in plain English, get SQL queries, dashboards, reports, and live data.

The Allium AI Assistant is an **agentic blockchain data analyst** built into [app.allium.so](https://app.allium.so/assistant). It goes beyond simple SQL generation - it can search schemas, write and execute queries, create dashboards, share results, look up wallets, generate PDF reports, and even deploy live web apps, all through natural language conversation.

<Frame>
  <img src="https://mintcdn.com/allium-e770e2b7/taCjEpcAKO8PScSx/images/assistant-chat.png?fit=max&auto=format&n=taCjEpcAKO8PScSx&q=85&s=e556361778219eef783fbb71c89350d2" alt="AI Assistant chat interface showing a multi-step analytical workflow" width="1212" height="616" data-path="images/assistant-chat.png" />
</Frame>

## Capabilities

<CardGroup cols={2}>
  <Card title="Natural language to SQL" icon="database" href="/ai/assistant/capabilities#natural-language-to-sql">
    Schema discovery, SQL generation, validation, and execution with confirmation flow
  </Card>

  <Card title="Dashboards & visualizations" icon="chart-mixed" href="/ai/assistant/capabilities#dashboards-and-visualizations">
    Create interactive dashboards with charts, then share them publicly
  </Card>

  <Card title="Sharing & export" icon="share-nodes" href="/ai/assistant/capabilities#sharing-and-export">
    Public links, share to X/LinkedIn, PDF reports
  </Card>

  <Card title="Real-time data" icon="bolt" href="/ai/assistant/capabilities#real-time-data">
    Token prices, wallet balances, and transaction history - no SQL needed
  </Card>

  <Card title="Organization memory" icon="brain" href="/ai/assistant/memory">
    Persistent context shared across your entire org
  </Card>

  <Card title="Web search" icon="globe" href="/ai/assistant/capabilities#web-search">
    Current events, market context, and protocol research
  </Card>

  <Card title="Data pipelines (Beam)" icon="arrow-progress" href="/ai/assistant/capabilities#data-pipelines-beam">
    Create real-time data pipelines with natural language
  </Card>

  <Card title="Live web apps (Vercel)" icon="browser" href="/ai/assistant/capabilities#live-web-apps-vercel">
    Deploy interactive Next.js apps from conversation
  </Card>
</CardGroup>

## Getting started

<Steps>
  <Step title="Open the Assistant">
    Click the **Assistant** icon in the sidebar of the [Allium App](https://app.allium.so).

    <Frame>
      <img src="https://mintcdn.com/allium-e770e2b7/taCjEpcAKO8PScSx/images/assistant-in-sidebar.png?fit=max&auto=format&n=taCjEpcAKO8PScSx&q=85&s=a9941e1698db56e16d98570814ffdd2f" alt="AI Assistant sidebar panel in Allium App" width="430" height="528" data-path="images/assistant-in-sidebar.png" />
    </Frame>
  </Step>

  <Step title="Ask a question">
    Type your question in plain English. The assistant plans and executes the steps needed to answer it.

    **Example questions:**

    * "Show me DEX volume by chain for the last 30 days"
    * "What are the top 10 tokens by trading volume on Ethereum?"
    * "Create a dashboard showing daily active wallets on Solana"
    * "What's the current price of ETH?"
    * "Look up this wallet: 0xabc..."
  </Step>

  <Step title="Iterate and refine">
    Continue the conversation to drill deeper. The assistant remembers your full session context, so you can say things like "break that down by DEX" or "add a chart for that" without repeating yourself.
  </Step>
</Steps>

## Example workflow

<Accordion title="From question to dashboard">
  **Question:**

  > Show me DEX trading volume by blockchain over the last 90 days and create a dashboard for it.

  **What the assistant does:**

  1. **Searches schemas** to find the right tables (`crosschain.dex.trades`)
  2. **Writes and validates SQL:**

  ```sql theme={null}
  SELECT
      DATE(block_timestamp) AS date,
      chain,
      SUM(usd_amount) AS usd_volume,
      COUNT(DISTINCT transaction_from_address) AS traders
  FROM
      crosschain.dex.trades
  WHERE
      block_timestamp >= CURRENT_TIMESTAMP - INTERVAL '90 days'
  GROUP BY
      date, chain
  ORDER BY
      date DESC;
  ```

  3. **Executes the query** and returns results
  4. **Creates a dashboard** with charts visualizing volume and trader counts by chain
  5. **Shares a link** so you can access the dashboard anytime
</Accordion>

<Info>
  See [Examples](/ai/assistant/examples) for more detailed end-to-end walkthroughs.
</Info>

## Tips

<CardGroup cols={2}>
  <Card title="Be specific" icon="bullseye">
    The more precise your question, the better the assistant can find the right schemas and write accurate queries.
  </Card>

  <Card title="Let it work" icon="gear">
    The assistant handles multi-step workflows automatically. Ask for the end result and let it figure out the steps.
  </Card>

  <Card title="Iterate naturally" icon="arrows-rotate">
    Build on previous results in the same conversation - refine queries, add filters, or request visualizations.
  </Card>

  <Card title="Review results" icon="check-circle">
    Always review generated queries and dashboards to ensure they match your requirements.
  </Card>
</CardGroup>

## Need help?

<Info>
  For specific queries or deeper insights beyond the AI Assistant, reach out to [support@allium.so](mailto:support@allium.so). We're happy to set up a Slack or Telegram channel for easy communication.
</Info>