We're excited to announce that WinDB API access is now available through Dhali.
WinDB is XRPLWin's full-history, indexed database covering both the XRP Ledger and Xahau. Until now, accessing this data meant working directly with our infrastructure — now, developers can query it through a clean, metered API powered by Dhali.
What this means for developers:
- Full-history data — every transaction, account, and ledger object since genesis, not just recent state
- Indexed for speed — built on ClickHouse, designed for fast analytical queries over large datasets
- XRPL and Xahau coverage — one API for both networks
- Pay-per-use access via Dhali — no need to run or maintain your own indexing infrastructure
What's inside WinDB
Behind the API sits a ClickHouse-powered schema spanning accounts and balances, transactions and ledgers, NFTs and collections, AMM pools and token metrics, and — for Xahau — hooks and their execution history. Daily and hourly rollups are precomputed across most of these datasets, so aggregate queries like historical balances, volume trends, or collection stats return fast even across the full chain history, rather than being computed live from a node on every request.
Why through Dhali
Rather than standing up and maintaining your own indexing infrastructure, Dhali gives you pay-per-use access to WinDB's full dataset. You only pay for the queries you run, with no upfront infrastructure cost or maintenance overhead — ideal for teams building dashboards, analytics, or wallets without wanting to run a full historical index themselves.
This is part of our ongoing push to make XRPL and Xahau data more accessible to builders — whether you're running analytics, powering a wallet, or building the next generation of tools on these networks.
Why indexed beats querying a raw node
A standard XRPL or Xahau node is built to validate and relay transactions — not to answer analytical questions. Ask it for a single account's current balance and it responds instantly. Ask it for that account's full balance history, every NFT it has ever traded, or daily transaction volume across a token over the last two years, and you're stuck replaying ledgers one by one, often thousands or millions of them, just to compute an answer that dissolves the moment you close the connection.
Who this is for
- Wallet and portfolio apps — pull full balance and NFT history for an account without maintaining your own index
- Analytics dashboards — chart token volume, AMM pool activity, or network metrics over time using precomputed rollups
- NFT marketplaces and tools — query collection stats, ownership history, and trait data across the full chain
- Xahau hook developers — inspect historical hook executions and activity without replaying ledgers
- Researchers and auditors — reconstruct account or token history at any point since genesis
If your project touches any of the above, WinDB via Dhali gives you a shortcut past the infrastructure work.
In conclusion
Making WinDB available through Dhali is opening infrastructure up to the rest of the ecosystem — so builders can spend their time on their product, not on indexing ledgers.
If you're building something on XRPL or Xahau and full-history data would help, give it a try at pay.dhali.io