What problem does it solve? Keeping a blockchain indexer in sync with evolving smart contracts is error-prone: missed events, non-idempotent handlers, and schema drift silently corrupt the data your API and UI depend on. This Skill provides a structured workflow for maintaining Ponder event coverage and Postgres projections so every on-chain event is handled, projected, and queryable. ## Core Features & Use Cases - Event Coverage Checklist: Defines the minimum required event set across turn lifecycle, participation, shop, draw, payout, and resource domains so nothing is missed when contracts change. - Projection Integrity Rules: Enforces idempotent keys (txHash, logIndex), upsert semantics for player/day/month entities, and consistent derived fields like phase status and remaining stock. - End-to-End Change Workflow: Guides the full pipeline from ABI regeneration through Ponder handlers, dbmate migrations, Kysely typings, and replay/reorg testing. - Use Case: After adding a new RelicBought event to your game contracts, use this Skill to regenerate the ABI, write the handler, add the migration, update API types, and verify with duplicate-replay tests. ## Quick Start Ask the AI to add Ponder handler coverage and a Postgres projection for a newly added contract event, following the change workflow and testing checklist.
