Cloud Azure Sql

What it does

This skill allows AI agents to interact with and manage Microsoft Azure SQL databases. It enables querying data, executing stored procedures, and performing basic database administration tasks directly through natural language prompts. The agent can retrieve information from tables or modify data based on user instructions.

When to use it

• Data Retrieval: Quickly pull specific data points from an Azure SQL database without needing to write complex queries. For example, "Show me all orders placed last week."
• Report Generation: Generate simple reports by querying and formatting data stored in the database. "Create a report showing total sales per region."
• Database Administration (Basic): Perform basic administrative tasks like checking database status or running scripts. “Check the current health of the ‘production’ database.”

Key capabilities

• Azure SQL Database Connectivity
• Data Querying via Natural Language
• Stored Procedure Execution
• Basic Database Status Checks

Example prompts

• "What is the total number of customers in the 'Customers' table?"
• "Execute the stored procedure 'UpdateOrderStatus' with order ID 123."
• “Show me all products with a price greater than $50.”

Tips & gotchas

The agent requires appropriate Azure credentials and access to the target SQL database. Complex database operations or schema modifications may require more specific instructions or be beyond its current capabilities.