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 happens behind the scenes
What happens behind the scenes
- Schema search - searches Allium’s database schemas to find relevant tables and columns
- Documentation lookup - checks Allium docs for data model details and best practices
- SQL generation - writes an optimized query using the discovered schemas
- Validation - runs
EXPLAINon the query to catch syntax errors before execution - Execution - runs the query on Allium’s Snowflake warehouse (you’ll see a confirmation prompt)
- Results - presents the data with a clear summary
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.
Dashboards and visualizations
Create interactive dashboards from your data with charts, tables, and configurable layouts. Example prompts:What happens behind the scenes
What happens behind the scenes
- Runs queries to gather the data
- Creates a dashboard in Allium Explorer with appropriate chart types
- Configures visualizations - line charts for time series, bar charts for comparisons, tables for detailed data
- Returns a link to the dashboard in the Allium App
Sharing and export
Share your analysis with the world or export it for offline use.Public links
app.allium.so/s2/...) that anyone can view without logging in.
Share to X / LinkedIn
- A summary of key insights (never raw data)
- A link to the dashboard
- Relevant hashtags
PDF reports
Real-time data
Get live token prices, wallet balances, and transaction history without writing SQL. Example prompts:Available operations
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
- Balances - current token holdings
- Transactions - recent transaction history
- History - historical balance snapshots over time
Web search
The assistant can search the web for context that isn’t in Allium’s database. Example prompts:- Current events and market news
- Protocol research and governance updates
- Context about new projects or tokens
For blockchain-specific data (schemas, tables, on-chain data), the assistant automatically uses Allium’s tools instead of web search.
Address lookup
Identify wallets and contracts by looking up labels, names, and project associations. Example prompt:- 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:Data pipelines (Beam)
Feature-gated - Beam pipelines are available to organizations with the Custom Transforms feature enabled. Contact support@allium.so to request access.
What happens behind the scenes
What happens behind the scenes
- Creates a pipeline config with source (chain + entity), transforms (JavaScript or set filters), and sinks (Kafka topics)
- Deploys workers - creates Kafka topics, provisions credentials, and spins up workers
- Returns connection details - Kafka credentials and code snippets (Python and TypeScript) to consume the stream
- Monitors health - check deployment status and worker health anytime
Live web apps (Vercel)
Feature-gated - Vercel app deployment requires the feature to be enabled for your organization. Contact support@allium.so to request access.
Available app types
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
What happens behind the scenes
What happens behind the scenes
- Generates app code - Next.js app with Allium API integration
- Deploys to Vercel - builds and deploys the app
- Returns a claim URL - you claim ownership with a free Vercel account
- Iterate - read, edit, and redeploy files through conversation
ALLIUM_API_KEY in Vercel project settings to connect your app to live data.