Get all fields in a collection

Vishal_Ghodake · 2025-03-11T10:21:06.600Z

Hello, I want to extract all the fields present in a collection, including nested fields. How can I extract the fields using shell or compass?

Jack_Woehr · 2025-03-12T10:13:58.089Z

In mongosh, is this what you want?

db.mycollection.aggregate([ { $group: { '_id': "$_id", 'otherFields': { $push: { fields: "$$ROOT" } } } }] )

Vishal_Ghodake · 2025-03-12T11:14:48.676Z

Hello Jack,

I want to list out only field names present in a collection. values are not required.

Jack_Woehr · 2025-03-12T11:52:23.750Z

Object.keys(db.YOURCOLLECTION.findOne()) gets the top level.
You’d need to write something recursive like that to get the sub fields.