aggregate-db
Read-only
Run a MongoDB aggregation pipeline on a database. Supports database-level stages: $changeStream, $currentOp, $documents, $listLocalSessions, $queryStats.
Instructions
Run an aggregation against a MongoDB database
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| database | Yes | Database name | |
| pipeline | Yes | An array of aggregation stages to execute. The first stage must be a database-level aggregation stage (one of `$changeStream`, `$currentOp`, `$documents`, `$listLocalSessions`, `$queryStats`). https://www.mongodb.com/docs/manual/reference/mql/aggregation-stages/#db.aggregate---stages | |
| connectionId | Yes | The connection to run the operation against. Use the id returned by one of the connect tools, or "preconfigured" to use the connection string the server was configured with. | |
| responseBytesLimit | No | The maximum number of bytes to return in the response. This value is capped by the server's configured maximum and cannot be exceeded. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| documents | Yes | The documents returned by the aggregation pipeline | |
| appliedLimits | Yes | The limits applied to the aggregation pipeline | |
| aggResultsCount | No | The total number of documents returned by the aggregation pipeline |