20.0.0-alpha.1 (2026-11-16)
- feat!: 🎸 link multisigs, PIPs, subsidies, EVM and confidential assets to their accounts (20bb87f)
- feat!: 🎸 index eras, elected validators and slashes (beeda48)
- feat!: 🎸 index corporate actions, ballots, checkpoints and offerings (8a43137)
- feat!: 🎸 record settlement parties and approvals per holder (a9e908c)
- feat!: 🎸 merge the external agent entities into AssetAgent (1550d24)
- feat!: 🎸 hold assets at portfolio and account grain, one row per token (8f6bd0f)
- feat!: 🎸 key claims and compliance as the chain does (b559001)
- feat!: 🎸 record identity keys as time-bounded memberships (2b396e4)
- feat!: 🎸 record POLYX as a double-entry ledger, matched to chain balances (c19b924)
- feat!: 🎸 record where every row came from, and store arguments canonically (fb2b7c1)
- feat!: 🎸 build the database from the schema, with no SQL migrations (c24a78b)
- feat!: ⬆️ 🎸 run on Postgres 18, Node.js 24.22.1 and node-core 19.4.0 (dd3943d)
Features
- 🎸 decode every event, call and storage item by name, checked per runtime (119db74)
- 🎸 start an index from any block, seeded from chain storage (25a3b81)
BREAKING CHANGES
- MultiSig.address is the Account relation account; read accountId.
MultiSig.creator and creatorAccount are nullable. MultiSigAdmin.identityId is the Identity
relation admin; read adminId. - ProposalVote.account, MultiSigProposal.creatorAccount and BridgeEvent.recipient
are Account relations; read the *Id column. EvmTransaction.fromAddress is fromAccountId.
Proposal.owner is nullable. - ConfidentialAccount.account is renamed publicKey, and encryptionKey is a
relation; read encryptionKeyId. ConfidentialAsset.auditors and mediators, and the MediatorKey
type, are replaced by keys { role encryptionKeyId accountId }.
ConfidentialSettlement.assetRootBlock is nullable. - Proposal.balance is removed; read pips.deposits(pipId, proposer) from the chain.
- EvmAccountMapping is removed. Find an account by its H160 with
accounts(filter: { evmAddress: { equalTo: $h160 } }), and read revive.originalAccount(h160) for
whether it is mapped. - StakingEvent.stashAccount is the Account relation stash; read stashId.
StakingEvent.rewardDestinationAccount is an Account relation; read rewardDestinationAccountId. - Investment.stoId is the offering's id (asset/number) instead of its number.
Investment.offeringAssetId and raisingAssetId, and Sto.raisingAssetId, are Asset relations, null
for an off-chain raising asset, whose ticker is in raiseToken and raisingTicker. - Sto.tiers carries price, remaining and total as "123", not "123n".
- Leg's from, to, fromAccount, toAccount, fromPortfolio and toPortfolio, and
InstructionParty's, InstructionAffirmation's and InstructionEvent's identity, account and
portfolio, are relations; read the *Id column or walk the entity. OffChainReceipt.signer is
signerId. An off-chain leg's assetId is null, and its ticker is in ticker. - an account-level holder is no longer its own InstructionParty.
- InstructionAffirmation is one row per holder, created Pending with the
instruction; a withdrawal sets it back to Pending; InstructionEvent.identity is the caller for
affirm, withdraw and auto-affirm events. A mediator's affirmation row is instructionId/mediator/did,
and a withdrawn one stays, as Pending. - a rejection writes no InstructionAffirmation; read Instruction.rejectedBy and
rejectedBySigner. AffirmStatusEnum.Rejected is removed and Pending added.
InstructionAffirmation.portfolios and InstructionParty.portfolios are removed; read portfolioId
per holder row. - AssetMandatoryMediator.addedBy is nullable.
- AssetPreApproval is removed. Whether a receiver must affirm is the runtime API
settlementApi.getReceiverAffirmationRequirement(receiver, assetId), and the pre-approval alone is
asset.preApprovedAsset(did, assetId); what an instruction did is
InstructionAffirmation.isAutomaticallyAffirmed. - TickerExternalAgent is renamed AssetAgent, and its caller field identity;
TickerExternalAgentHistory is renamed AssetAgentHistory, whose type is the AgentHistoryType enum
instead of a String, and which has no updatedEvent; TickerExternalAgentAction is renamed
AssetAgentAction. The tickerExternalAgents, tickerExternalAgentHistories and
tickerExternalAgentActions queries become assetAgents, assetAgentHistories and assetAgentActions,
and callerId filters become identityId. AgentGroupMembership.member is an Identity relation;
read memberId. - PortfolioMovement and PortfolioMovementTypeEnum are removed. Query
assetTransactions with isInternalTransfer: { equalTo: true }; fungible and non-fungible
movements differ by amount or nftIds being null. - NftHolder and Identity.heldNfts are removed. An identity's holding of an asset,
fungible or NFT, is its AssetHolder, and its tokens are nfts filtered by holding. - Asset.isUniquenessRequired is removed.
- AssetTransaction.fromAccount and toAccount are Account relations; read
fromAccountId and toAccountId. - a memo that is not ASCII text changes. Non-ASCII UTF-8 decodes correctly, and a
binary memo, or one with a NUL or control character in it, is the 0x-prefixed hex of all 32
bytes. Event and call arguments keep memos as hex. - text set before v14 keeps its spaces, and an asset created with no funding round
name has fundingRound "". - Claim ids include the issuer, so claim counts rise where issuers used to
collide. A Custom claim without a scope has a null scope and the id
target/issuer/Custom/. - the ClaimScope entity is removed. Query Claim.scope with { contains: … }, as the
SDK already does. - TrustedClaimIssuer.issuer is an Identity relation: filter on issuerId, and read
the identity through issuer. - ClaimTypeEnum loses InvestorUniqueness, InvestorUniquenessV2 and NoData.
- from 7.0, an asset-scoped claim's scope.value is the asset id, not the ticker.
Read the asset from scope.assetId. - the TransferManager entity, TransferRestrictionTypeEnum and the
transferManagers query, Asset.transferManagers included, are removed. - Identity.secondaryAccounts is removed. Read
Identity.keys(filter: { role: { equalTo: SecondaryKey }, validToBlockId: { isNull: true } }), which
returns IdentityKey rows, each with an account relation. - the AccountHistory and Permissions entities are removed, and so is
Account.permissions. Read key-membership history and per-interval permissions from IdentityKey;
an account's current permissions are its active IdentityKey row's permissions. - the ChildIdentity entity and Identity.children are removed.
- Identity.primaryAccount is an Account relation; read primaryAccountId.
Authorization.toKey is removed: a key's authorization is toAccountId, an SS58 address. - pre-7.0 rows of IdentityKey.permissions.transactions, AgentGroup.permissions,
JoinIdentity and RotatePrimaryKeyToSecondary Authorization.data, and every built-in group's
AssetAgentHistory permissions hold the map form. - polyxTransactions is replaced by polyxEntries. A query that matched an account
across the from and to columns filters on one accountId. BalanceTypeEnum is removed; use
PolyxEntry.pool, kind and direction. The same staking event name means a lock before the v8
upgrade and a hold after it. - createdBlock and updatedBlock are removed from every entity; read
createdEvent { block } instead, and order by ID_* where CREATED_BLOCK_ID_* was used. datetime,
eventIdx and extrinsicIdx are removed wherever an entity copied them; read
createdEvent { block { datetime } }, createdEvent { eventIdx } and
createdEvent { extrinsic { extrinsicIdx } }. Identity.eventId, Account.eventId and
DistributionPayment.eventId are removed. AssetTransaction's scheduled-transaction signal, which
was a null extrinsicIdx, is a null createdEvent { extrinsic }. - Event.attributesTxt and Event.eventArg_0 to eventArg_3 are removed, and so are
the Event columns claimType, claimScope, claimIssuer, claimExpiry, corporateActionTicker,
fundraiserOfferingAsset and transferTo. Read Event.args, and find events by what they involve
through Event.refs. Extrinsic.paramsTxt is removed; read Extrinsic.args. Values are in the
canonical encoding, not toHuman text, so a moment needs Number() before new Date(). - Instruction, Venue, Proposal and Authorization ids are zero-padded to 10 digits
("0000014712", not "14712"). A filter or join on the unpadded id must use the padded form. - generated collection names are replaced by declared ones, for example
claimsByTargetId by claims, and Asset.assetTransactions by Asset.transactions. - the FoundType and Debug entities and their queries are removed.
- a database built by an earlier release cannot be upgraded in place. Drop it and
reindex from genesis. - the database is a new Postgres major version with a new volume path. An existing
data volume has to be recreated, and the chain reindexed from genesis.