Indexers are pieces of softwares that listen to the blockchain and index information to make it easier to access for the user.
For a scheme, see Architecture technique Ğ1v2
They can index for example:
- Transaction history
- Aliases of identities
- …
Here is some tooling for substrate ecosystem: