Azure Cosmos Py

What it does

This skill allows AI agents to interact with Azure Cosmos DB using Python. It facilitates creating, reading, updating, and deleting documents within a Cosmos DB container. The skill leverages the azure-cosmos library to provide a programmatic interface for managing data in this NoSQL database service.

When to use it

• Data Migration: Automate the process of moving data between different Cosmos DB accounts or containers.
• Inventory Management: Build an agent that can update product quantities and details stored in a Cosmos DB inventory system.
• Log Analysis: Retrieve and analyze log data stored within Cosmos DB for troubleshooting or reporting purposes.
• Content Management: Create an agent to manage website content, storing articles and media assets in Cosmos DB.

Key capabilities

• Connects to Azure Cosmos DB accounts.
• Creates new containers.
• Reads documents from a container.
• Updates existing documents within a container.
• Deletes documents from a container.

Example prompts

• "Retrieve all orders with a status of 'pending' from the 'orders' container."
• "Create a new document in the 'products' container with these details: {name: 'Widget', price: 19.99}.”
• “Update the ‘quantity’ field to 5 for product ID ‘XYZ-123’ in the ‘inventory’ container.”

Tips & gotchas

• Requires an Azure subscription and Cosmos DB account with appropriate access credentials.
• Familiarity with Python is helpful for understanding and debugging any issues that may arise.