Mongodb

What it does

This skill provides access to and interaction with a MongoDB database. It allows agents to query, insert, update, and delete data within a specified MongoDB instance. The agent can also execute aggregation pipelines for complex data analysis and reporting tasks.

When to use it

• Data Retrieval: Retrieve specific product information from an e-commerce catalog stored in MongoDB.
• Inventory Management: Update stock levels in a warehouse database after processing orders.
• Report Generation: Generate sales reports by querying and aggregating data from a MongoDB database containing transaction records.
• User Profile Updates: Modify user profile details within a MongoDB database based on user input or system events.

Key capabilities

• Querying (find)
• Inserting (insert)
• Updating (update)
• Deleting (delete)
• Aggregation Pipelines

Example prompts

• "Find all customers in the 'customers' collection with a city of 'New York'."
• "Insert a new product into the 'products' collection with name 'Widget', price 19.99, and category 'Electronics'."
• "Update the quantity field for product ID '123' in the 'inventory' collection to 50."

Tips & gotchas

• Requires access credentials (username/password) and connection details (host/port) for the MongoDB instance.
• Be mindful of data types when inserting or updating documents; incorrect types can lead to errors.