Azure Cosmos Db Py

What it does

This skill allows AI agents to interact with Azure Cosmos DB using Python. It enables querying, creating, updating, and deleting documents within a Cosmos DB container. The agent can manage data stored in this NoSQL database for various applications.

When to use it

• Data Retrieval: An agent needs to fetch product information from a Cosmos DB store based on user search criteria.
• Order Management: An AI assistant manages customer orders by creating new order documents and updating existing ones within Cosmos DB.
• Log Analysis: An agent analyzes application logs stored in Cosmos DB, identifying error patterns or performance bottlenecks.
• Content Storage: The agent needs to store user-generated content (e.g., reviews, comments) in a scalable database like Cosmos DB.

Key capabilities

• Querying documents
• Creating new documents
• Updating existing documents
• Deleting documents
• Python integration

Example prompts

• "Retrieve all products with a price greater than $50 from the 'products' container."
• "Create a new order document for customer ID 12345, including items [item1, item2]."
• "Update the status of order ID 67890 to 'shipped'."

Tips & gotchas

• Requires an active Azure subscription and Cosmos DB account with appropriate access permissions.
• Familiarity with Python and basic database concepts is helpful for constructing effective prompts.