Indexer and data

An Envio HyperIndex indexer turns Plans events on Monad into everything the app reads: plans, member ledgers, live balances, budget bars, the settle-up graph, the activity feed, a fresh-device rebuild and the public traction stats. The app keeps no database of its own.

• envio@3.12.1, TypeScript handlers, Vitest tests.
• Monad mainnet 143 and testnet 10143, both native HyperSync networks.
• PlansFactory, KeyRegistry, ClaimEscrow and PlansSend have static addresses; every Pot is registered dynamically from PotCreated.
• Entities are per chain: filter every query by chainId. Addresses are lowercase. Amounts are AUSD base units (6 decimals).

SchemaCopy Anchor Link

32 entities and 13 enums, linked with @derivedFrom. Two layers:

1. Raw and lifecycle entities, one per onchain object or event: Account, Pot, Member, RulesVersion, AllowlistEntry, Contribution, Spend, SpendShare, Vote, Dispute, DisputeVote, Freeze, RuleChange, RuleChangeVote, KeyWrap, Ack, Payout, Pull, Debt, PotSettlement, Claim, Send, Activity.
2. Derived entities, maintained by the handlers:

The ledgerCopy Anchor Link

The indexer mirrors the contract: net = contributed + personalPaid − share − withdrawn, and tracks each pot's balance independently. The tests assert Σ net == balance after every scenario.

The settle-up graphCopy Anchor Link

Recomputed after every change to any member's net, with a deterministic greedy min-cash-flow: the largest debtor pays the largest creditor min(debt, credit), ties broken by address. Leftover credit is owed by the pot's own balance (PotToMember). Tested on 2,000 random pots: the edges balance exactly, every member is on one side only, there are at most (debtors + creditors − 1) member-to-member edges, and the output doesn't depend on input order.

CorridorsCopy Anchor Link

A corridor is an ordered country pair such as GB-IN. Sources: direct sends, send-by-link claims, a plan's LINK claims, settlement pulls and debt payments (split across the debtor's settle-up edges). A Payout alone isn't attributed, because the pot holds pooled money; the cross-member part of a settlement is counted once, on the pull or debt-payment side. Flows with an unknown country aren't attributed; domestic pairs are kept with isCrossBorder = false.

Internal accounts and demo plansCopy Anchor Link

indexer/internal-accounts.json lists the demo members (Ben, Asha, Maya) and team accounts (treasury, deployer, test phones). A demo plan is one created by an internal account or joined by any demo member. If a demo member joins a plan after it was counted, everything that plan contributed to the stats is withdrawn.

Metric definitionsCopy Anchor Link

All metrics are per chain and exclude internal accounts and demo plans. They match docs/traction.md and the stats page.

QueriesCopy Anchor Link

The full set is in indexer/queries/; node queries/run.mjs <endpoint> checks them against a live endpoint.

query MyPlans($account: String!, $chainId: Int!) {
  Member(where: { account_id: { _eq: $account }, chainId: { _eq: $chainId } }, order_by: { joinedAt: desc }) {
    id status net contributed share debt
    pot { id meta status startTime endTime balance memberCount activeMemberCount countries frozenUntil isDemo }
  }
  Account(where: { id: { _eq: $account }, chainId: { _eq: $chainId } }) {
    id key country isUser keyWraps(order_by: { timestamp: desc }) { pot_id by_id wrap timestamp }
  }
}

query Stats($chainId: Int!) {
  GlobalStats(where: { id: { _eq: "global" }, chainId: { _eq: $chainId } }) {
    users accounts potsCreated fundedPots medianMembersPerPot medianCountriesPerPot
    spends approvals settlements settledVolume crossBorderVolume updatedAt
  }
  DailyStats(where: { chainId: { _eq: $chainId } }, order_by: { day: asc }) { date newUsers spends settledVolume }
  Corridor(where: { chainId: { _eq: $chainId }, isCrossBorder: { _eq: true }, count: { _gt: 0 } },
           order_by: { volume: desc }) { fromCountry toCountry volume count }
  Account(where: { chainId: { _eq: $chainId }, ttffaCounted: { _eq: true } },
          order_by: { timeToFirstFundedAction: asc }) { timeToFirstFundedAction }
}

Run it locallyCopy Anchor Link

cd indexer
pnpm install
pnpm codegen
pnpm test              # no network, no Docker
cp .env.example .env   # ENVIO_API_TOKEN and, once deployed, the contract addresses
pnpm dev               # Postgres + Hasura in Docker; GraphQL at http://localhost:8080/v1/graphql
node queries/run.mjs