Anyone know how to have Abe show top wallet balances? If not already built in, how could I query the mysql DB for this info?
As unick says, it is not built in. You can search this thread for "txout_value" to find a query that gives the amount received by an address ("pubkey"). A similar query (joining txin with txout on txout_id) can give the amount received. Subtract to get the "balance" for that particular public key (which, you must know, is not the same as a wallet.dat file). Use GROUP BY to put them all into a table and select from it ordering by balance. Remember to limit the results to where chain_candidate.in_longest=1 in case your database contains side-chains.