I believe you would benefit from the subgraph debug tool developed by Limechain.
The subgraph debug tool saves developers time during the debug process. Sometimes, when a subgraph is deployed, it fails at specific point in the syncing process. Typically, a developer would need to attempt to fix the problem, redeploy and wait for syncing to complete to see if the problem was fixed.
The subgraph debug tool allows developers to run their mappings using the store from the failed subgraph. It will run locally on the block the subgraph failed, so that developers can receive feedback on their attempts to fix the problem quickly.
The tool also allows developers to easily fork and build off existing subgraphs which enables a larger use case for the tool.
You can view the demo of this tool shared at Core R&D Call #10 at 35:48 in this video⬇️
There is also a subgraph testing playlist here⬇️
Here are some additional resources in The Graph Docs: