# MongoDB

The **MongoDB Node** in StackAI allows you to query a MongoDB database directly from your workflow. This node is ideal for retrieving data from your collections using flexible filters, making it easy to integrate database results into your AI-powered automations.

**How to use it?**

To use the MongoDB node, you need to provide the following required inputs and configurations:

* **Database Name (Required Configuration)**
  * Description: The name of the MongoDB database you want to query.
  * Example: "customer\_data"
* **Collection Name (Required Configuration)**
  * Description: The name of the collection within the database to query.
  * Example: "orders"
* **Filter (Required Input)**
  * Description: The MongoDB query filter in JSON format. This determines which documents are returned.
  * Example:
    * To find all orders for a specific user: {"user\_id": "499484bb-fd54-4fb0-93e5-4ad98bdcdf94"}
    * To find users aged 18 or older: {"age": {"$gte": 18}}
    * To find orders with status "active" or "pending": {"status": {"$in": \["active", "pending"]}}
    * To find documents created after a certain date: {"created\_at": {"$gte": "2024-01-01T00:00:00Z"}}

**Example of Usage**

Suppose you want to retrieve all active orders from the "orders" collection in the "customer\_data" database:

* **Database Name:** "customer\_data" (Required)
* **Collection Name:** "orders" (Required)
* **Filter:** {"status": "active"} (Required)

**Expected Output**

* **Results (Required Output)**
  * Description: An array of objects, each representing a document from the collection that matches the filter.
  * Example:

    ```json
    {
      "results": [
        {
          "order_id": "12345",
          "user_id": "abcde",
          "status": "active",
          "amount": 99.99
        },
        {
          "order_id": "12346",
          "user_id": "fghij",
          "status": "active",
          "amount": 49.99
        }
      ]
    }
    ```

**Available Actions**

* **Query MongoDB**
  * Description: Retrieve documents from a specified database and collection using a JSON filter.
  * Required Inputs:
    * Database Name (string, required)
    * Collection Name (string, required)
    * Filter (string, required; JSON format)
  * Output:
    * Results (array of objects, required): The documents matching your query.

**Summary**

The MongoDB node in StackAI is a powerful tool for querying your MongoDB collections. By specifying the database, collection, and filter, you can retrieve exactly the data you need and use it in your automated workflows.