> ## 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.

# Capabilities

> Everything the Allium AI Assistant can do: answer questions, chart and share results, automate recurring work, and build pipelines and apps.

Describe the result you want. The Assistant picks the tools, runs them in order, and shows each step as it goes.

<CardGroup cols={3}>
  <Card title="Answer" icon="comments" href="#answer-questions">
    SQL, curated metrics, Terminal, labels, and web search
  </Card>

  <Card title="Visualize" icon="chart-mixed" href="#chart-and-build-dashboards">
    Inline charts and interactive dashboards
  </Card>

  <Card title="Share" icon="share-nodes" href="#share-and-export">
    Public links, forkable sessions, social posts, PDFs
  </Card>

  <Card title="Automate" icon="repeat" href="#automate-recurring-work">
    Custom skills and organization memory
  </Card>

  <Card title="Bring context" icon="paperclip" href="#bring-your-own-context">
    Files, screenshots, and the tab you are on
  </Card>

  <Card title="Build" icon="hammer" href="#build-pipelines-and-apps">
    Beam pipelines and live web apps
  </Card>
</CardGroup>

<Info>
  Everything on this page runs in the [Allium App](https://app.allium.so/assistant). To give your own agent the same tools, see [Allium MCP](/ai/mcp/overview).
</Info>

## Answer questions

Ask in plain English. The Assistant uses the fastest source that answers the question correctly, in this order:

| Source | When the Assistant uses it | Example prompt |
| :- | :- | :- |
| **Metrics catalog** | Allium has a curated, precomputed metric for it. Categories include chains, DEXs, stablecoins, lending, bridging, perpetuals, RWAs, staking, prediction markets, and payments. | `Daily DEX volume on Base vs Solana, last 30 days` |
| **[Terminal](https://app.allium.so/terminal)** | An Allium analyst already built a dashboard for it. The Assistant links you to it and can reuse its SQL. | `What's the current stablecoin supply split across chains?` |
| **SQL** | Everything else. The Assistant searches schemas and docs, writes the query, validates it with `EXPLAIN`, and runs it. | `Which wallets bought more than $1M of PENDLE on Arbitrum this month?` |
| **Address labels** | You give it a wallet or contract address. It returns the name, category, and project. | `Who is 0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045?` |
| **Web search** | The question needs news or context that is not onchain. | `What changed in the latest Uniswap governance proposal?` |

Answers from the metrics catalog and Terminal match the numbers Allium publishes. Terminal results are precomputed, and the Assistant tells you when they were last refreshed.

### Metrics catalog

Ask `What was daily stablecoin supply on Ethereum, Tron and Solana over the last 30 days?` The Assistant lists the catalog metrics, pulls circulating supply split by chain, and answers with a table of the 30-day change: Ethereum goes from \$173.80B to \$173.64B (-0.1%), Tron from \$93.82B to \$94.22B (+0.4%), and Solana from \$15.86B to \$16.28B (+2.6%).

<Frame caption="Asking Allium Assistant for stablecoin supply on Ethereum, Tron, and Solana">
  <video src="https://mintcdn.com/allium-e770e2b7/e6d7py3H-pqTcS-q/videos/assistant/s1-metrics-catalog.mp4?fit=max&auto=format&n=e6d7py3H-pqTcS-q&q=85&s=1792c0633e3aecabd887e3758d22fba8" poster="/images/assistant/s1-metrics-catalog.jpg" autoPlay muted loop playsInline data-path="videos/assistant/s1-metrics-catalog.mp4" />
</Frame>

### Terminal dashboards

Ask `Is there an Allium Terminal dashboard on stablecoin supply by chain? Show me what it says.` The Assistant searches Terminal, reads the results of the closest dashboard, and answers with a link to it and its supply-by-chain numbers for USDC and USDT. In this recording, no dashboard covers all stablecoins in one view, so the Assistant used the closest one. The flow can differ between runs.

<Frame caption="Asking Allium Assistant to find a Terminal dashboard on stablecoin supply">
  <video src="https://mintcdn.com/allium-e770e2b7/e6d7py3H-pqTcS-q/videos/assistant/s2-terminal.mp4?fit=max&auto=format&n=e6d7py3H-pqTcS-q&q=85&s=cf44ffd1edb216c6579ef5510f8542fb" poster="/images/assistant/s2-terminal.jpg" autoPlay muted loop playsInline data-path="videos/assistant/s2-terminal.mp4" />
</Frame>

### Address labels

Ask `Who is 0x28C6c06298d514Db089934071355E5743bf21d60?` The Assistant looks up Allium's address labels and returns the entity (Binance), the category (Exchange (CEX)), and the chains where the address appears.

<Frame caption="Asking Allium Assistant who owns an Ethereum address">
  <video src="https://mintcdn.com/allium-e770e2b7/e6d7py3H-pqTcS-q/videos/assistant/s3-address-lookup.mp4?fit=max&auto=format&n=e6d7py3H-pqTcS-q&q=85&s=4aa9f96a8e2f9019d89d8b2a08afac01" poster="/images/assistant/s3-address-lookup.jpg" autoPlay muted loop playsInline data-path="videos/assistant/s3-address-lookup.mp4" />
</Frame>

<Accordion title="What a SQL answer looks like, step by step" icon="list-check">
  1. **Search schemas and docs** to find the right tables and columns.
  2. **Load Allium's SQL guidance**: partition pruning, address casing, and when to use `*.metrics.*` tables instead of raw aggregation.
  3. **Write the query and validate it** with `EXPLAIN`.
  4. **Run it** on your session's compute profile. The step shows the Explorer Units (EUs) it used.
  5. **Summarize the result.** When you want to keep a query, or chart it, the Assistant saves it to Explorer, so you can open, edit, and rerun it.

  Results return up to 250,000 rows, unless your organization sets a lower limit.

  <Frame caption="A query step, opened up">
    <img src="https://mintcdn.com/allium-e770e2b7/e6d7py3H-pqTcS-q/images/assistant/a7-tool-steps.png?fit=max&auto=format&n=e6d7py3H-pqTcS-q&q=85&s=f0dc3995cb606e777fd6e65fc1ca9bd0" alt="An expanded Run SQL Query tool step showing the SQL query against arbitrum.metrics.overview, the queued run result and 0.31 EU consumed, with callouts on the EU usage and the step." width="1920" height="1176" data-path="images/assistant/a7-tool-steps.png" />
  </Frame>

  1. **EU used**
  2. **Tool step, expanded**

  Expand any tool step to see its SQL arguments, its result, and the EUs it used.
</Accordion>

<Note>
  **Prices, balances, and wallet history** are answered with SQL over Allium's tables, so you get full history and cross-chain aggregation at Explorer freshness. For sub-second lookups in your own app, use the [Realtime APIs](/api/developer/overview).
</Note>

***

## Chart and build dashboards

The Assistant charts query results when a chart helps, and the chart renders in the conversation. Ask for a different shape at any time: "make that a stacked area", "switch to weekly".

Ask `Compare daily DEX volume on Base, Arbitrum and Solana over the last 30 days and chart it.` The Assistant fetches the data, builds a chart in the conversation, and summarizes the takeaways below it.

<Frame caption="Asking Allium Assistant to chart daily DEX volume on Base, Arbitrum, and Solana">
  <video src="https://mintcdn.com/allium-e770e2b7/e6d7py3H-pqTcS-q/videos/assistant/s4-chart-in-chat.mp4?fit=max&auto=format&n=e6d7py3H-pqTcS-q&q=85&s=54ed9cf0936ac62d19879f3d7f71a021" poster="/images/assistant/s4-chart-in-chat.jpg" autoPlay muted loop playsInline data-path="videos/assistant/s4-chart-in-chat.mp4" />
</Frame>

From there, turn the analysis into a dashboard. Ask `Build a dashboard of daily DEX volume and unique traders on Base and Arbitrum over the last 30 days.` The Assistant builds the dashboard and links it in the conversation. It opens next to your session, with a line chart of daily DEX volume and a line chart of daily unique traders, one line per chain.

<Frame caption="Asking Allium Assistant for a Base and Arbitrum DEX dashboard">
  <video src="https://mintcdn.com/allium-e770e2b7/e6d7py3H-pqTcS-q/videos/assistant/s5-dashboard.mp4?fit=max&auto=format&n=e6d7py3H-pqTcS-q&q=85&s=9dd9a633d8c63be5231c6a5f3659d016" poster="/images/assistant/s5-dashboard.jpg" autoPlay muted loop playsInline data-path="videos/assistant/s5-dashboard.mp4" />
</Frame>

To change a dashboard, ask in the same conversation:

```text wrap theme={null}
Build a dashboard from this with a 7-day moving average and a Solana vs rest ratio
```

| What you can ask for | Options |
| :- | :- |
| **Chart types** | Line, bar, area, value, table, pie, sankey, treemap, scatter, map, chord |
| **Dashboard elements** | Charts, markdown text, spacers, and input controls: dropdowns, switches, date ranges, radio groups |
| **Edits** | Add, move, resize, or remove elements, in the same conversation |

Dashboards are saved to [Explorer](/app/overview), and the charts stay attached to their queries. When a query changes, its charts update.

<Tip>
  Start from an existing dashboard: "find our stablecoin dashboard and add a chart for PYUSD". The Assistant can search your organization's dashboards and edit one element at a time.
</Tip>

***

## Share and export

| Output | How to ask | What you get |
| :- | :- | :- |
| **Public dashboard or query** | `Make this dashboard public` | A link anyone can open without logging in. Queries also get an embed URL for your site. A shared query shows its SQL unless you ask the Assistant to hide it. |
| **Shared conversation** | Click **Share** in the session header | A read-only link to the full conversation, including later messages. Logged-in viewers can **fork** it and continue from where you left off. |
| **Post to X or LinkedIn** | `Share a summary of this on X` | A pre-filled post with key takeaways and a dashboard link. You review and post it. The Assistant never posts for you. |
| **PDF report** | `Turn this analysis into a PDF report` | A PDF with tables, charts, and text. The download link works for 7 days. |

<Note>
  A fork copies the messages only. Queries and dashboards that the Assistant created stay with the original owner. To stop sharing a dashboard or query, turn off public access in the App. A shared conversation link cannot be turned off, so share only what you are happy to publish.
</Note>

***

## Automate recurring work

<CardGroup cols={2}>
  <Card title="Custom skills" icon="wand-magic-sparkles" href="/ai/assistant/skills">
    Save a prompt as a skill, for example `/daily-movers`, and run it with one keystroke. Private to your user.
  </Card>

  <Card title="Organization memory" icon="brain" href="/ai/assistant/memory">
    Store treasury addresses, focus chains, and definitions once. Every conversation uses them.
  </Card>
</CardGroup>

***

## Bring your own context

| Input | How | Limits |
| :- | :- | :- |
| **Files** | Click the paperclip, or drop a file into the composer | PDF up to 20 MB. CSV, Excel, Word, and Markdown up to 10 MB. Images up to 4 MB. Up to 10 files per message. |
| **Screenshot of the current tab** | Click the camera icon and share this tab | The current browser tab only, on desktop browsers |
| **Memory** | `Remember that our treasury wallet is 0x...` | 50 entries per organization. See [Organization memory](/ai/assistant/memory). |

Use files to give the Assistant a list of addresses to check, a research PDF to compare against onchain data, or a screenshot of a chart you want reproduced.

<Note>
  The Assistant reads a file's contents. It cannot run SQL against an uploaded file. For Excel files, it reads the first sheet. Large CSV, Excel, and Word files are cut to about 1,000 lines.
</Note>

***

## Build pipelines and apps

<Tabs>
  <Tab title="Beam pipelines">
    Create streaming pipelines that filter and transform blockchain events and deliver them to Kafka topics.

    ```text wrap theme={null}
    Create a pipeline that streams Polygon logs and filters for USDC transfer events
    ```

    The Assistant writes the pipeline config, deploys the workers, and returns Kafka credentials with Python and TypeScript consumer snippets. Create, update, deploy, tear down, and monitor pipelines from the chat. See [Beam](/beam/overview).

    <Note>
      Beam pipelines are available to organizations with Custom Transforms. Contact [support@allium.so](mailto:support@allium.so) for access.
    </Note>
  </Tab>

  <Tab title="Web apps">
    Deploy a working Next.js app on Allium data from a prompt.

    ```text wrap theme={null}
    Build a wallet app tracking holders of more than 10K ETH
    ```

    | App type | What it does |
    | :- | :- |
    | Wallet tracker | Holdings, PnL, and transactions |
    | Token analytics | Prices and token stats |
    | Custom dashboard | SQL-powered widgets |
    | Wallet flows | Sankey diagram of inflows and outflows |
    | Price chart | OHLCV candles with 24h stats |

    The Assistant deploys the app to Vercel and returns a claim URL. Claim the project with a free Vercel account, then add your `ALLIUM_API_KEY` in the project settings to connect live data. Ask for changes in the chat and the Assistant redeploys.
  </Tab>
</Tabs>

***

## Stay in control

| Control | What it does |
| :- | :- |
| **Auto mode** (default) | The Assistant runs and saves queries, edits dashboards, and publishes shares and reports without stopping to ask. |
| **Manual mode** | The Assistant asks before each query run, edit, share, or deploy. Click **Allow**, **Always Allow**, or **Deny**. **Always Allow** stops it asking for that tool in every session. |
| **Always asks** | Deleting a dashboard and saving a skill need your approval in both modes. |
| **Compute profile** | Pick the profile your queries run on, from the composer. See [Compute profiles](/app/query-management/compute-profiles). |
| **Stop and retry** | Stop a reply that is going in the wrong direction, or retry it. |
| **Feedback** | Rate any reply with thumbs up or down. |

Press `Shift+Tab` in the composer to switch between Auto and Manual.

***

## How the Assistant stays accurate

<AccordionGroup>
  <Accordion title="Allium's skills" icon="book-open">
    Before it writes SQL or builds a dashboard, the Assistant loads Allium's own guidance: SQL optimization rules, chain-specific pitfalls, dashboard and chart specs, product guidance, and the dated list of supported chains. Your agent can load the same guidance through [Skills over MCP](/ai/mcp/tools-reference/skills).
  </Accordion>

  <Accordion title="Specialist subagents" icon="users">
    For heavy steps, the Assistant hands off to a focused subagent and keeps only the result:

    * **SQL expert**: iterates on a complex query until it validates and runs
    * **Docs expert**: researches across many documentation pages
    * **Dashboard generator**: assembles a multi-element dashboard, starting from Terminal
    * **PDF report generator**: lays out a report

    A subagent shows as one step in the conversation.
  </Accordion>

  <Accordion title="Questions back to you" icon="circle-question">
    When a request is ambiguous, such as which chains or what time window, the Assistant asks a short multiple-choice question before it spends compute.
  </Accordion>
</AccordionGroup>
