How to extract all info for a public address from a local full node’s db?

I recently started running bitcoind on a local Debian host, and I am still learning how to use the information in the local copy of the bitcoin blockchain.

I would like to extract all the information for one or more public bitcoin addresses currently available in the full node locally1.

I recently learned that, contrary to my initial expectation, bitcoin core is not suitable for performing this sort of query.

Therefore, I went back to Google, but I’ve come up empty 2. Hence I’m posting my question here.

Specifically, I would like to know

  1. what software (preferably in the form of one or more Debian packages) would I need to install on the local full node that would enable me to extract all the information for one or more public bitcoin addresses currently available in the full node locally;
  2. how exactly would I use this software to perform such queries.

1 I want to do this without reference to any specific wallet. Having to add this requirement feels extremely weird to me (like having to add the requirement that answers to my question should work seven days a week). This is a clear sign to me that there is still at least one pretty gigantic gap and/or confusion in my understanding of bitcoin, because I don’t understand why a wallet should be even relevant to the kind of query I want to do. I would have thought that a wallet would be, at most, an optional piece of information to modify the query, not an essential input for it. But the fact is that I have not been able to find any way to accomplish what I want to do that does not do it in the context of a specific wallet. This is just mind-boggling to me.

2 I am beginning to realize that the queries I want to perform on a full node’s database (and without reference to a wallet) is something practically no one cares to do, and therefore it is hard to find tools for doing them. Again, this strikes me as a bit weird, and feeds my growing suspicion that I am totally missing the point about bitcoin, blockchains, full nodes, etc.