dune-to-allium
Dune → Allium Query Conversion Skill
Convert Dune Analytics (Trino) SQL queries to Allium (Snowflake) SQL. SQL dialect conversions apply to all chains. Comprehensive Solana and EVM chain mappings included.
Prerequisites
- Allium API key in
~/.allium/credentials:
Get your key at https://app.allium.so/settings/api-keys. IfAPI_KEY=allium_... QUERY_ID=...QUERY_IDis missing, theallium_query.pyscript creates one automatically. - (Optional)
DUNE_API_KEYin project.envfile for automated result fetching viadune_query.py. Alternatively, run the original query in the Dune app and export results manually.
Conversion Workflow
Step 1: Accept Dune SQL
Get the Dune query via one of:
More from allium-labs/skills
allium-onchain-data
>-
48allium-x402
>-
36alchemy-api
Wire Alchemy into application code (server, backend, dApp, script) using a standard API key. Preferred app-integration path for normal server/backend usage. Covers EVM JSON-RPC, WebSocket subscriptions, Simulation, Webhooks/Notify, Solana RPC, Solana DAS, Solana Yellowstone gRPC, Sui gRPC, Wallets/Account Kit, Account Abstraction, and operational topics. Requires `$ALCHEMY_API_KEY`. For app code without an API key (autonomous agent paying per-request, or explicit x402/MPP), use `alchemy-agentic-gateway` instead.
7alchemy-agentic-gateway
Wire Alchemy into application code without an API key, using the x402 or MPP gateway with wallet-based auth (SIWE/SIWS) and per-request payments (USDC via x402, or USDC/credit-card via MPP). Specialized app-integration path. Use when the user is building application code AND no API key is available, or they're an autonomous agent that needs to pay for itself, or they explicitly want x402/MPP. For normal app code with an Alchemy API key, use `alchemy-api`.
7allium-data
>-
5