Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.synehq.com/llms.txt

Use this file to discover all available pages before exploring further.

Execute native MongoDB queries and aggregation pipelines directly using mongosh syntax. SyneHQ provides full support for MongoDB’s native query language, allowing you to leverage the complete power of MongoDB operations.
MongoDB Shell Interface

​
Why Use Mongosh?

Native MongoDB Syntax

Use MongoDB’s native query language without any abstraction layers

Full Feature Support

Access all MongoDB operations including aggregation pipelines and complex queries

Performance Optimized

Direct execution against MongoDB with no translation overhead

Familiar Environment

Standard mongosh syntax that MongoDB developers already know

​
Aggregation Pipeline

This section shows aggregation pipeline examples that use the following pizza orders collection:

​
Complete Aggregation Pipeline Example

db.orders.insertMany( [
   { _id: 0, name: "Pepperoni", size: "small", price: 19,
     quantity: 10, date: ISODate( "2021-03-13T08:14:30Z" ) },
   { _id: 1, name: "Pepperoni", size: "medium", price: 20,
     quantity: 20, date : ISODate( "2021-03-13T09:13:24Z" ) },
   { _id: 2, name: "Pepperoni", size: "large", price: 21,
     quantity: 30, date : ISODate( "2021-03-17T09:22:12Z" ) },
   { _id: 3, name: "Cheese", size: "small", price: 12,
     quantity: 15, date : ISODate( "2021-03-13T11:21:39.736Z" ) },
   { _id: 4, name: "Cheese", size: "medium", price: 13,
     quantity:50, date : ISODate( "2022-01-12T21:23:13.331Z" ) },
   { _id: 5, name: "Cheese", size: "large", price: 14,
     quantity: 10, date : ISODate( "2022-01-12T05:08:13Z" ) },
   { _id: 6, name: "Vegan", size: "small", price: 17,
     quantity: 10, date : ISODate( "2021-01-13T05:08:13Z" ) },
   { _id: 7, name: "Vegan", size: "medium", price: 18,
     quantity: 10, date : ISODate( "2021-01-13T05:10:13Z" ) }
])
Calculate Total Order Quantity The following aggregation pipeline example contains two stages and returns the total order quantity of medium size pizzas grouped by pizza name: 
db.orders.aggregate([
   // Stage 1: Filter pizza order documents by pizza size
   {
      $match: { size: "medium" }
   },
   // Stage 2: Group remaining documents by pizza name and calculate total quantity
   {
      $group: { _id: "$name", totalQuantity: { $sum: "$quantity" } }
   }
] )
For more consult mongodb docs here — > https://www.mongodb.com/docs/manual/introduction/