MuhammadAsim6/ZigIndexer-Without-Partitioning- ? reverse-engineered prompt

Build me a blockchain data indexer that can pull blocks and transactions from a chain RPC endpoint and store everything in PostgreSQL so it can power things like a block explorer or analytics dashboard.

I want it to run locally or in Docker, with a simple env file for database and RPC settings. It should resume from the last indexed block if it stops, process blocks one by one, and handle large histories without losing data. Make it modular so different networks or message types can be supported separately, and include whatever decoding is needed to turn raw chain data into useful records.

Please set up the database schema, the indexing flow, and the basic scripts to start, reset, and view logs. If anything needs current docs or chain specific details, look them up online and keep the setup easy to run from the README.