Give your team real-time SQL access to on-chain data and save 3 hours/week of manual blockchain reconciliation.
~3 hrs
Saved / wk
Medium
Setup
No AI
AI
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.
~3 hrs
Saved / Week
Some setup required
Setup Complexity
No AI involved
AI Status
Step 1: Use Better Sol to generate the typed TypeScript client for your deployed Solana program.
Step 2: Create a Supabase table that mirrors your on-chain data model (e.g., user_id, transaction_hash, amount, timestamp).
Step 3: Write a Node.js listener script using the Better Sol client to subscribe to on-chain program events via WebSocket.
Step 4: On each event, use the Supabase JS client to upsert the transaction record into your table.
Step 5: Deploy the listener as a long-running Supabase Edge Function or a simple server.
Step 6: Connect Metabase to your Supabase database and build a dashboard showing transaction volume, top users, and daily activity.
Upgrade to Plus for AI-powered step-by-step guides
See PlansBetter Sol lets you write Solana blockchain programs entirely in TypeScript — no Rust toolchain required. You define your program once, and Better Sol generates the on-chain program, a fully typed client, and a database schema from that single file. You can deploy to Solana with one command, and your bundle stays small at 41 KB.
Open-source backend platform on PostgreSQL — database, authentication, file storage, edge functions, and real-time subscriptions out of the box. Firebase alternative you can self-host. 99,500+ GitHub stars. Free: 2 projects, 500MB, 50K MAU. Pro: $25/month (8GB, 100K MAU). Team: $599/month (SOC 2).
Open-source business intelligence — explore data, build dashboards, and answer questions without writing SQL. Self-host free or use managed cloud. Connects to your databases and turns raw data into charts, reports, and alerts. Open source: free (unlimited). Starter cloud: $85/month. Metabot AI: $100/month add-on.
