mongo_extract_indexes_to_csv.js

print("Database,Collection,Index Name,Is Unique,Is Sparse,TTL (seconds),Fields");

db.getMongo().getDBs().databases.forEach(function(database) {
//     print("\nDatabase:", database.name);
    
    if (database.name !== 'admin' && database.name !== 'local' && database.name !== 'config') {
        var dbs = db.getSiblingDB(database.name);
        
        dbs.getCollectionNames().forEach(function(collName) {
//             print("\collName:", collName);
            var indexes = db.getCollection(collName).getIndexes();
            
            indexes.forEach(function(index) {
                // Format fields with their sort direction
                var fields = [];
                for (var field in index.key) {
                    var direction = index.key[field];
                    var directionText = direction === 1 ? "ASC" : 
                                      direction === -1 ? "DESC" : 
                                      direction === "text" ? "TEXT" : direction;
                    fields.push(`${field} (${directionText})`);
                }
                
                // Create CSV row
                var row = [
                    `"${database.name}"`,
                    `"${collName}"`,
                    `"${index.name}"`,
                    index.unique || false,
                    index.sparse || false,
                    index.expireAfterSeconds || '',
                    `"${fields.join(', ')}"`
                ];
                
                print(row.join(','));
            });
        });
    }
});