Azure SQL Server (OAuth) MCP connector
Azure SQL Server (OAuth) is Microsoft's relational database management system for storing and managing structured data in the cloud. The Azure SQL Server (OAuth) MCP connector allows AI agents to execute SQL statements and queries against a database using secure OAuth authentication. It also supports returning single scalar values from queries, enabling precise data retrieval and database automation within broader workflows.
Authentication type
- OAuth 2.0 Authorization Code - Requires a one-time user login to authorize the agent to access the service on their behalf.
Uses
Use the Azure SQL Server (OAuth) MCP connector to perform the following actions:
- Retrieve sales, order, or customer records from Azure SQL Server tables
- Update customer or order statuses directly within Azure SQL Server
- Insert new leads, transactions, or records into business tables
- Delete outdated, duplicate, or test records from the database
- Calculate totals, counts, or averages for financial reporting
- Check pending order or inventory counts using scalar queries
- Sync data between Azure SQL Server and other business workflows
- Audit recent changes by querying transaction history and timestamps
Example prompts
Use the following example prompts to invoke Azure SQL Server (OAuth) MCP connector tools from your AI assistant or Boomi Connect workflow:
Show me all open invoices from last month in Azure SQL Server (OAuth).Add a new customer record to Azure SQL Server (OAuth).How many orders are still pending in Azure SQL Server (OAuth)?Update the shipping status for order 4521 in Azure SQL Server (OAuth).Delete the test records from the customer table in Azure SQL Server (OAuth).What is the total revenue for this quarter in Azure SQL Server (OAuth)?List all employees hired in the last 30 days from Azure SQL Server (OAuth).Remove duplicate entries from the product catalog in Azure SQL Server (OAuth).Give me the average order value from Azure SQL Server (OAuth).Find all overdue accounts in Azure SQL Server (OAuth).
Azure SQL Server (OAuth) MCP connector tools
The Azure SQL Server (OAuth) MCP connector provides the following tools. Each tool maps to a specific action you can invoke from your AI agent or automation.
| Tool | Description |
|---|---|
| azuresqlserveroauth_azuresqlserverexecutenonquery_invoke | Execute a non-query SQL statement that returns the number of rows affected |
| azuresqlserveroauth_azuresqlserverexecutequery_invoke | Returns zero or more rows from a SQL query |
| azuresqlserveroauth_azuresqlserverexecutescalar_invoke | Returns a single value from a SQL query e.g. |
