> ## 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, from SQL generation to deploying live web apps.

The assistant has access to **12+ tool categories** that it chains together automatically. You don't need to tell it which tools to use - just describe what you want.

## Natural language to SQL

The assistant finds the right tables, writes SQL, validates it, and executes it - all from a plain English question.

**Example prompt:**

```
What are the top 10 protocols by TVL on Ethereum this week?
```

<Accordion title="What happens behind the scenes">
  1. **Schema search** - searches Allium's database schemas to find relevant tables and columns
  2. **Documentation lookup** - checks Allium docs for data model details and best practices
  3. **SQL generation** - writes an optimized query using the discovered schemas
  4. **Validation** - runs `EXPLAIN` on the query to catch syntax errors before execution
  5. **Execution** - runs the query on Allium's Snowflake warehouse (you'll see a confirmation prompt)
  6. **Results** - presents the data with a clear summary
</Accordion>

<Note>
  **Query confirmation** - the assistant asks for your approval before executing SQL queries. You'll see the exact query it wants to run and can approve or reject it.
</Note>

***

## Dashboards and visualizations

Create interactive dashboards from your data with charts, tables, and configurable layouts.

**Example prompts:**

```
Create a dashboard showing daily active wallets on Solana vs Ethereum
```

```
Add a bar chart showing top 10 DEXes by volume to my dashboard
```

<Accordion title="What happens behind the scenes">
  1. **Runs queries** to gather the data
  2. **Creates a dashboard** in Allium Explorer with appropriate chart types
  3. **Configures visualizations** - line charts for time series, bar charts for comparisons, tables for detailed data
  4. **Returns a link** to the dashboard in the Allium App
</Accordion>

You can iterate on dashboards in the same conversation - add charts, change layouts, or update queries.

***

## Sharing and export

Share your analysis with the world or export it for offline use.

### Public links

```
Make this dashboard public and give me the link
```

Creates a shareable URL (`app.allium.so/s2/...`) that anyone can view without logging in.

### Share to X / LinkedIn

```
Share a summary of this analysis on X
```

The assistant generates a **pre-filled post** with:

* A summary of key insights (never raw data)
* A link to the dashboard
* Relevant hashtags

You click the generated link to review and post - the assistant never posts on your behalf.

### PDF reports

```
Generate a PDF report of this analysis
```

Creates a downloadable PDF with tables, charts, and text sections. Supports portrait/landscape orientation, custom titles, and subtitles. Download links are valid for **7 days**.

***

## Real-time data

Get live token prices, wallet balances, and transaction history without writing SQL.

**Example prompts:**

```
What's the current price of ETH?
```

```
Show me the token balances for vitalik.eth
```

```
Get the last 50 transactions for this wallet: 0xabc...
```

<Accordion title="Available operations">
  **Token prices:**

  * **Latest** - current price for any token
  * **History** - historical prices with minute/hour/day granularity
  * **Stats** - 24h/1h high, low, and percent change

  **Wallet info:**

  * **Balances** - current token holdings
  * **Transactions** - recent transaction history
  * **History** - historical balance snapshots over time
</Accordion>

***

## Web search

The assistant can search the web for context that isn't in Allium's database.

**Example prompts:**

```
What's happening with the Ethereum Pectra upgrade?
```

```
Find recent news about Uniswap governance proposals
```

Useful for:

* **Current events** and market news
* **Protocol research** and governance updates
* **Context** about new projects or tokens

<Note>
  For blockchain-specific data (schemas, tables, on-chain data), the assistant automatically uses Allium's tools instead of web search.
</Note>

***

## Address lookup

Identify wallets and contracts by looking up labels, names, and project associations.

**Example prompt:**

```
Who owns this wallet: 0xd8dA6BF26964aF9D7eEd9e03E53415D37aA96045?
```

Returns:

* **Name** and **label** (e.g., "Vitalik Buterin")
* **Category** (e.g., "Individual", "DEX", "Bridge")
* **Project** association (e.g., "Uniswap", "Aave")
* **Chain** information

***

## Organization memory

Persistent key-value storage shared across all users in your organization. The assistant remembers preferences, key addresses, and context across sessions.

**Example prompts:**

```
Remember that our treasury wallet is 0xabc...
```

```
What do you know about our organization?
```

See the dedicated [Organization memory](/ai/assistant/memory) page for details.

***

## Data pipelines (Beam)

<Note>
  **Feature-gated** - Beam pipelines are available to organizations with the Custom Transforms feature enabled. Contact [support@allium.so](mailto:support@allium.so) to request access.
</Note>

Create real-time data pipelines that stream blockchain events through custom transforms to Kafka topics.

**Example prompts:**

```
Create a pipeline that streams Polygon logs and filters for USDC transfer events
```

```
Deploy my pipeline and show me the Kafka connection details
```

<Accordion title="What happens behind the scenes">
  1. **Creates a pipeline config** with source (chain + entity), transforms (JavaScript or set filters), and sinks (Kafka topics)
  2. **Deploys workers** - creates Kafka topics, provisions credentials, and spins up workers
  3. **Returns connection details** - Kafka credentials and code snippets (Python and TypeScript) to consume the stream
  4. **Monitors health** - check deployment status and worker health anytime

  Pipeline management is fully conversational - create, update, deploy, teardown, and check stats all through chat.
</Accordion>

***

## Live web apps (Vercel)

<Note>
  **Feature-gated** - Vercel app deployment requires the feature to be enabled for your organization. Contact [support@allium.so](mailto:support@allium.so) to request access.
</Note>

Deploy interactive Next.js web apps from a conversation. The assistant generates the code and deploys it to Vercel.

**Example prompts:**

```
Build me a wallet tracker app for Ethereum and Polygon
```

```
Create a token price chart for ETH with 24h stats
```

<Accordion title="Available app types">
  * **Wallet tracker** - track holdings, PnL, and transactions
  * **Token analytics** - analyze token prices and stats
  * **Custom dashboard** - SQL-powered dashboard with configurable widgets
  * **Wallet flows** - Sankey diagram of wallet inflows/outflows
  * **Price chart** - OHLCV candlestick chart with dynamic coloring and 24h stats
</Accordion>

<Accordion title="What happens behind the scenes">
  1. **Generates app code** - Next.js app with Allium API integration
  2. **Deploys to Vercel** - builds and deploys the app
  3. **Returns a claim URL** - you claim ownership with a free Vercel account
  4. **Iterate** - read, edit, and redeploy files through conversation

  After claiming, add your `ALLIUM_API_KEY` in Vercel project settings to connect your app to live data.
</Accordion>