Azure Cosmos 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 also perform administrative tasks like creating databases and containers.

When to use it

• Data Retrieval: An agent needs to fetch product information from a Cosmos DB database for customer service.
• Order Processing: An agent automates order creation in an e-commerce system by writing new documents to a Cosmos DB container.
• Inventory Management: The agent updates inventory counts stored in Cosmos DB based on sales data.
• Reporting & Analytics: An agent extracts data from Cosmos DB for generating reports and dashboards.

Key capabilities

• Querying Cosmos DB containers
• Creating new documents within a container
• Updating existing documents
• Deleting documents
• Creating databases and containers
• Python-based interaction

Example prompts

• "Retrieve all orders placed in the last week from the 'orders' container."
• "Create a new product document with name 'Widget X', price 19.99, and quantity 100."
• "Update the status of order ID '12345' to 'shipped'."

Tips & gotchas

• Requires an active Azure subscription and Cosmos DB account.
• Ensure the AI agent has appropriate access permissions (connection string or credentials) configured within your Cosmos DB environment.