Again, not Magento. Very handy though!
SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'your_schema';
Then you can use show indexes from table_name to see more info about the index.
show indexes from table_name