"Blockchain Explorer" software?
Abe does exactly what you want. I will walk the entire blockchain from bitcoin-qt/bitcoind and populate a local database. It supports several database backends including sqlite, Postgres, MySQL and Oracle.

It will take quite some time to walk the blockchain and populate the database, possibly a few days.

It has a web based interface that is very similar to blockchain.info and blockexplorer.