Better Sol generates a fully typed client alongside your Solana program. This workflow uses that client to listen for on-chain transactions — token transfers, program calls, state changes — and writes each event in real time to a Supabase table. Your business team can then query transaction history, loyalty point balances, or NFT ownership directly in SQL without touching the blockchain.
Use Better Sol to generate the typed TypeScript client for your deployed Solana program.
Create a Supabase table that mirrors your on-chain data model (e.g., user_id, transaction_hash, amount, timestamp).
Write a Node.js listener script using the Better Sol client to subscribe to on-chain program events via WebSocket.
On each event, use the Supabase JS client to upsert the transaction record into your table.
Deploy the listener as a long-running Supabase Edge Function or a simple server.
Connect Metabase to your Supabase database and build a dashboard showing transaction volume, top users, and daily activity.
Create a free account to get the steps written out for your tools, click by click.
Create a free accountGive your team real-time SQL access to on-chain data and cut out the manual blockchain reconciliation work each week.
Grab a 15-minute chat. We don't sell software, so we have no stake in which one you use.
