GUI tools such as MongoDB compass or Studio 3T does not meet below requirements.
I am wondering if any GUI tool for MongoDB Aggregation which allows me to build Aggregation via Excel-Way (click and select with minor manual commands) to get rid of drafting raw MongoDB Aggregation commands, which is quite complicated and expensive (too much time and efforts for a simple query) to use.
Yes, all those examples for MongoDB Aggregation on official docs are relatively simple, however, when it comes to real world query, even a simple query requires complicated Aggregation command. check this example here.
Another example, mongodb does not provide tools for me to check the output of each aggregation command (not stage) one-by-one.
db.collection.aggregte([
{$map:
{
input: "$quizzes",
as: "grade",
in: { $add: [ "$$grade", 2 ] }
}
}
])
it throws me an error "unknown top level operator: $map"
$mapis an operator; the error is because you are using it incorrectly. Aggregation query is made of Stages and Operators. And, each stage does some data transformation and passes the data as input to the next stage. Please follow the syntax and examples for each stage and operator form the MongoDB Manual. See: Aggregation Pipeline Quick Reference.