execute_mongo_pipeline
The execute_mongo_pipeline prompt facilitates the execution of MongoDB aggregation pipelines by ensuring that documents are properly unwound and filtered, while restricting the use of certain operations like "lookup" and "merge." It is designed for scenarios where users need to manipulate and analyze nested data structures within MongoDB collections efficiently.
Prompt Text
ALL DATA PROVIDED IS A DOCUMENT IN MONGO DB COLLECTION. ALWAYS use $unwind to top-level in order to expand the document. AVOID return everything in a DOCUMENT, filter and check the network data structure. Run the pipeline expression to obtain the query result. Only in-document pipeline expressions are permitted; hence, "lookup"and"lookup"and"merge" are prohibited. However, $group is allowed.
Evaluation Results
1/28/2026
Overall Score
2.00/5
Average across all 3 models
Best Performing Model
Low Confidence
anthropic:claude-3-5-haiku
3.11/5
anthropic:claude-3-5-haiku
#1 Ranked
3.11
/5.00
adh
2.4
cla
4.7
com
2.2
In
500
Out
1,654
Cost
$0.0070
google:gemini-2.5-flash-lite
#2 Ranked
2.72
/5.00
adh
2.1
cla
4.5
com
1.6
In
450
Out
1,843
Cost
$0.0008
openai:gpt-5-mini
#3 Ranked
0.16
/5.00
adh
0.1
cla
0.3
com
0.1
In
455
Out
4,000
Cost
$0.0081
Test Case: